| Lists: | pgsql-bugspgsql-interfacespgsql-jdbc |
|---|
| From: | "Jos Antonio Matute Calvo" <cmaj(at)encomix(dot)es> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org(dot)pgsql-interfaces(at)postgresql(dot)org |
| Subject: | jdbc driver: Support for 'BOOL' |
| Date: | 2001-01-10 16:31:30 |
| Message-ID: | 93i2nh$2do8$1@news.tht.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs pgsql-interfaces pgsql-jdbc |
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");
Jose A. Matute Calvo
Daratel, S.L.
Zaragoza - Spain.
| From: | Joseph Shraibman <jks(at)selectacast(dot)net> |
|---|---|
| To: | José Antonio Matute Calvo <cmaj(at)encomix(dot)es> |
| Cc: | pgsql-bugs(at)postgresql(dot)org, pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: [INTERFACES] jdbc driver: Support for 'BOOL' |
| Date: | 2001-01-15 19:53:36 |
| Message-ID: | 3A635540.E420BD96@selectacast.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs pgsql-interfaces pgsql-jdbc |
"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(at)selectacast(dot)net
Increase signal to noise ratio. http://www.targabot.com
| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Joseph Shraibman <jks(at)selectacast(dot)net> |
| Cc: | José Antonio Matute Calvo <cmaj(at)encomix(dot)es>, pgsql-bugs(at)postgresql(dot)org, pgsql-interfaces(at)postgresql(dot)org, PostgreSQL jdbc list <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: [INTERFACES] jdbc driver: Support for 'BOOL' |
| Date: | 2001-01-24 14:19:02 |
| Message-ID: | 200101241419.JAA15011@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs pgsql-interfaces pgsql-jdbc |
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(at)selectacast(dot)net
> Increase signal to noise ratio. http://www.targabot.com
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Joseph Shraibman <jks(at)selectacast(dot)net> |
| Cc: | José Antonio Matute Calvo <cmaj(at)encomix(dot)es>, pgsql-bugs(at)postgresql(dot)org, pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: [INTERFACES] jdbc driver: Support for 'BOOL' |
| Date: | 2001-01-25 03:31:38 |
| Message-ID: | 200101250331.WAA29980@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs pgsql-interfaces pgsql-jdbc |
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(at)selectacast(dot)net
> Increase signal to noise ratio. http://www.targabot.com
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From: | Peter T Mount <peter(at)retep(dot)org(dot)uk> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Joseph Shraibman <jks(at)selectacast(dot)net>, =?ISO-8859-1?Q?Jos=E9_Antonio?=Matute Calvo <cmaj(at)encomix(dot)es>, pgsql-bugs(at)postgresql(dot)org, pgsql-interfaces(at)postgresql(dot)org, PostgreSQL jdbc list <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: Re: [INTERFACES] jdbc driver: Support for 'BOOL' |
| Date: | 2001-01-25 13:26:50 |
| Message-ID: | 980429210.3a70299abcb42@webmail.retep.org.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs pgsql-interfaces pgsql-jdbc |
Quoting Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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(at)selectacast(dot)net
> > Increase signal to noise ratio. http://www.targabot.com
> >
>
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman(at)candle(dot)pha(dot)pa(dot)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(at)retep(dot)org(dot)uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/
| From: | Peter T Mount <peter(at)retep(dot)org(dot)uk> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Joseph Shraibman <jks(at)selectacast(dot)net>, =?ISO-8859-1?Q?Jos=E9_Antonio?=Matute Calvo <cmaj(at)encomix(dot)es>, pgsql-bugs(at)postgresql(dot)org, pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: Re: [INTERFACES] jdbc driver: Support for 'BOOL' |
| Date: | 2001-01-26 09:26:16 |
| Message-ID: | 980501176.3a7142b89a36f@webmail.retep.org.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs pgsql-interfaces pgsql-jdbc |
Quoting Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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(at)selectacast(dot)net
> > Increase signal to noise ratio. http://www.targabot.com
> >
>
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman(at)candle(dot)pha(dot)pa(dot)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(at)retep(dot)org(dot)uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/