On Fri, 16 Nov 2007, Lance J. Andersen wrote:
The table in this case that needs to be looked at is B-5, not B-4 which i
believe you are referring to. The expectation of setObject(int/String,
Object, int) is that you are sending the value to the backend as the SQL
Type specified for the 3rd
Kris,
Thanks for the follow up.
Kris Jurka wrote:
Lance J. Andersen wrote:
Thank you for your time, but i think there is still a driver issue here:
If i use the same types as i sent in the email and execute
select * from bit_in_min(1::bit)
I have no problems and the table is correctly up
Thank you for your time, but i think there is still a driver issue here:
If i use the same types as i sent in the email and execute
select * from bit_in_min(1::bit)
I have no problems and the table is correctly updated.
This would lead me to believe that the driver has a problem with
corre
Sorry Bad, Cut and paste. This test is a strip down of much larger
test. The reason the metadata is there as this gets run from a
framework which exercises JDBC drivers from all of the major vendors
which is also the reason for the Drivers class.
As far as the INSERT, i did not look at the
The test runs for me when I change all of the underlying types from bit
to boolean:
create table Bit_Tab (MAX_VAL boolean, MIN_VAL boolean, NULL_VAL boolean
NULL) ;
CREATE OR REPLACE FUNCTION Bit_In_Min (MIN_PARAM boolean) returns void as
'begin update Bit_Tab set MIN_VAL=MIN_PARAM; end;' lan
On Thu, 15 Nov 2007, Lance Andersen wrote:
The following bug has been logged online:
Bug reference: 3751
PostgreSQL version: 8.2.x
Description:Conversion error using PreparedStatement.setObject()
Details:
A PreparedStatement.setObject(1, "1", Types.Bit) will fail with the
follo
Lance J. Andersen wrote:
Thank you for your time, but i think there is still a driver issue here:
If i use the same types as i sent in the email and execute
select * from bit_in_min(1::bit)
I have no problems and the table is correctly updated.
This would lead me to believe that the driver
The following bug has been logged online:
Bug reference: 3751
Logged by: Lance Andersen
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.x
Operating system: N/A
Description:Conversion error using PreparedStatement.setObject()
Details:
A PreparedStatement.set
