jdbc driver: Support for 'BOOL'

Started by Jos� Antonio Matute Calvoover 25 years ago6 messagesbugs

Jump to latest

Jos� Antonio Matute Calvo

cmaj@encomix.es

over 25 years ago

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.

Joseph Shraibman

jks@selectacast.net

over 25 years ago

In reply to: Jos� Antonio Matute Calvo (#1)

Re: [INTERFACES] jdbc driver: Support for 'BOOL'

"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

bruce@momjian.us

over 25 years ago

In reply to: Joseph Shraibman (#2)

Re: [INTERFACES] jdbc driver: Support for 'BOOL'

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

Bruce Momjian

bruce@momjian.us

over 25 years ago

In reply to: Joseph Shraibman (#2)

Re: [INTERFACES] jdbc driver: Support for 'BOOL'

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

Peter T Mount

peter@retep.org.uk

over 25 years ago

In reply to: Bruce Momjian (#3)

Re: Re: [INTERFACES] jdbc driver: Support for 'BOOL'

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/

Peter T Mount

peter@retep.org.uk

over 25 years ago

In reply to: Bruce Momjian (#4)

Re: Re: [INTERFACES] jdbc driver: Support for 'BOOL'

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/