Re: [Firebird-Java] Re: Incorrect values within SQLDA structure
----- Original Message -----
From: "Roman Rokytskyy" <rrokytskyy@...>
To: "Carsten Schäfer" <ca_schaefer@...>
Sent: Thursday, April 04, 2002 3:05 PM
Subject: RE: [Firebird-Java] Re: Incorrect values within SQLDA structure
> > i have no explanation.
> > Your code is working for me, too.
> > But i can easily reproduce the exception with my code.
> > The structure of my code is nearly the same as in your example.
> What are the differences?
the main differences that i have much more columns ;)
I have setFloat,setDouble,setDate,setTimestamp,setLong,setInt in my PreparedStatement.
I have no linear order in my columns.
I have an order like this:
> > I can't post my code because it's to large.
> Ok, maybe you could answer on some of my questions:
> - Does it happen when you put non-empty string there?
> - Do you use autocommit?
no, but the exception occurs before the commit()
> - What SQL dialect do you use?
> - What is the default charset specified for your database?
DEFAULT CHARACTER SET WIN1252
> - Does it exist, when you try to do same operation on other VARCHAR column?
Yes, (but the tested varchar has the same column definition)
> - Does it exist, when you don't have WIN1252 charset specified?
> > My table has about 80 columns.
> - How many columns you use in your insert statement?
I think all.
> - Is it really first column?
no, its column 56
I can send you my insert statement and my table definition, if you want.