----- 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


> Hi,
>
> > 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:
setString(5,...);
setFloat(8,...);
setFloat(9,...);
setInt(2,...);
setString(3,...);
setString(19,...);
...
>
> > 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?
Yes
> - Do you use autocommit?
no, but the exception occurs before the commit()

> - What SQL dialect do you use?
3
> - 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.

gruse
Carsten