pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: [INTERFACES] jdbc driver: Support for 'BOOL'
5+ messages / 3 participants
[nested] [flat]
* Re: [INTERFACES] jdbc driver: Support for 'BOOL'
@ 2001-01-15 19:53 Joseph Shraibman <jks@selectacast.net>
0 siblings, 2 replies; 5+ messages in thread
From: Joseph Shraibman @ 2001-01-15 19:53 UTC (permalink / raw)
To: José Antonio Matute Calvo <cmaj@encomix.es>; +Cc: pgsql-bugs@postgresql.org; pgsql-interfaces
"José Antonio Matute Calvo" wrote:
>
> Problem:
> If try to use field of type "java.sql.Types.BIT" obtains error "Unknown
> Types Value"
>
> Resolution:
>
> Add this:
>
> PreparedStatement.java
> 460,461d459
> < case Types.BIT:
> < set(parameterIndex,
> ((Boolean)x).booleanValue() ? "true" : "false");
Why not set(parameterIndex,x.toString())?
--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio. http://www.targabot.com
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] jdbc driver: Support for 'BOOL'
@ 2001-01-24 14:19 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Joseph Shraibman <jks@selectacast.net>
1 sibling, 1 reply; 5+ messages in thread
From: Bruce Momjian @ 2001-01-24 14:19 UTC (permalink / raw)
To: Joseph Shraibman <jks@selectacast.net>; +Cc: José Antonio Matute Calvo <cmaj@encomix.es>; pgsql-bugs@postgresql.org, pgsql-interfaces@postgresql.org, PostgreSQL jdbc list <pgsql-jdbc@postgresql.org>
Is this a bug? Can someone submit a patch?
[ Charset ISO-8859-1 unsupported, converting... ]
> "Jos? Antonio Matute Calvo" wrote:
> >
> > Problem:
> > If try to use field of type "java.sql.Types.BIT" obtains error "Unknown
> > Types Value"
> >
> > Resolution:
> >
> > Add this:
> >
> > PreparedStatement.java
> > 460,461d459
> > < case Types.BIT:
> > < set(parameterIndex,
> > ((Boolean)x).booleanValue() ? "true" : "false");
>
> Why not set(parameterIndex,x.toString())?
>
>
> --
> Joseph Shraibman
> jks@selectacast.net
> Increase signal to noise ratio. http://www.targabot.com
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] jdbc driver: Support for 'BOOL'
@ 2001-01-25 03:31 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Joseph Shraibman <jks@selectacast.net>
1 sibling, 1 reply; 5+ messages in thread
From: Bruce Momjian @ 2001-01-25 03:31 UTC (permalink / raw)
To: Joseph Shraibman <jks@selectacast.net>; +Cc: José Antonio Matute Calvo <cmaj@encomix.es>; pgsql-bugs@postgresql.org; pgsql-interfaces
Seems the BIT type works in Java 7.1 beta now.
[ Charset ISO-8859-1 unsupported, converting... ]
> "Jos? Antonio Matute Calvo" wrote:
> >
> > Problem:
> > If try to use field of type "java.sql.Types.BIT" obtains error "Unknown
> > Types Value"
> >
> > Resolution:
> >
> > Add this:
> >
> > PreparedStatement.java
> > 460,461d459
> > < case Types.BIT:
> > < set(parameterIndex,
> > ((Boolean)x).booleanValue() ? "true" : "false");
>
> Why not set(parameterIndex,x.toString())?
>
>
> --
> Joseph Shraibman
> jks@selectacast.net
> Increase signal to noise ratio. http://www.targabot.com
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Re: [INTERFACES] jdbc driver: Support for 'BOOL'
@ 2001-01-25 13:26 Peter T Mount <peter@retep.org.uk>
parent: Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 5+ messages in thread
From: Peter T Mount @ 2001-01-25 13:26 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: Joseph Shraibman <jks@selectacast.net>; José AntonioMatute Calvo <cmaj@encomix.es>; pgsql-bugs@postgresql.org, pgsql-interfaces@postgresql.org, PostgreSQL jdbc list <pgsql-jdbc@postgresql.org>
Quoting Bruce Momjian <pgman@candle.pha.pa.us>:
>
> Is this a bug? Can someone submit a patch?
Why not setBoolean(parameterIndex,((Boolean)x),booleanValue());
Also, unless it's changed postgres accepts 't' & 'f' not 'true' or 'false'?
Also, which PreparedStatement.java are we taking about, as there are 2 of them?
Peter
>
>
> [ Charset ISO-8859-1 unsupported, converting... ]
> > "Jos? Antonio Matute Calvo" wrote:
> > >
> > > Problem:
> > > If try to use field of type "java.sql.Types.BIT" obtains error
> "Unknown
> > > Types Value"
> > >
> > > Resolution:
> > >
> > > Add this:
> > >
> > > PreparedStatement.java
> > > 460,461d459
> > > < case Types.BIT:
> > > < set(parameterIndex,
> > > ((Boolean)x).booleanValue() ? "true" : "false");
> >
> > Why not set(parameterIndex,x.toString())?
> >
> >
> > --
> > Joseph Shraibman
> > jks@selectacast.net
> > Increase signal to noise ratio. http://www.targabot.com
> >
>
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman@candle.pha.pa.us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania
> 19026
>
--
Peter Mount peter@retep.org.uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Re: [INTERFACES] jdbc driver: Support for 'BOOL'
@ 2001-01-26 09:26 Peter T Mount <peter@retep.org.uk>
parent: Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 5+ messages in thread
From: Peter T Mount @ 2001-01-26 09:26 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: Joseph Shraibman <jks@selectacast.net>; José AntonioMatute Calvo <cmaj@encomix.es>; pgsql-bugs@postgresql.org; pgsql-interfaces
Quoting Bruce Momjian <pgman@candle.pha.pa.us>:
>
> Seems the BIT type works in Java 7.1 beta now.
Has anything changed with boolean types in the backend then, as nothing has
been done on the JDBC side?
>
> [ Charset ISO-8859-1 unsupported, converting... ]
> > "Jos? Antonio Matute Calvo" wrote:
> > >
> > > Problem:
> > > If try to use field of type "java.sql.Types.BIT" obtains error
> "Unknown
> > > Types Value"
> > >
> > > Resolution:
> > >
> > > Add this:
> > >
> > > PreparedStatement.java
> > > 460,461d459
> > > < case Types.BIT:
> > > < set(parameterIndex,
> > > ((Boolean)x).booleanValue() ? "true" : "false");
> >
> > Why not set(parameterIndex,x.toString())?
> >
> >
> > --
> > Joseph Shraibman
> > jks@selectacast.net
> > Increase signal to noise ratio. http://www.targabot.com
> >
>
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman@candle.pha.pa.us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania
> 19026
>
--
Peter Mount peter@retep.org.uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2001-01-26 09:26 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-01-15 19:53 Re: [INTERFACES] jdbc driver: Support for 'BOOL' Joseph Shraibman <jks@selectacast.net>
2001-01-24 14:19 ` Bruce Momjian <pgman@candle.pha.pa.us>
2001-01-25 13:26 ` Peter T Mount <peter@retep.org.uk>
2001-01-25 03:31 ` Bruce Momjian <pgman@candle.pha.pa.us>
2001-01-26 09:26 ` Peter T Mount <peter@retep.org.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox