From the looks of your create table statement you didn't specify a primary key.
-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of A.Fritz@xxxxxxxxx
Sent: Friday, October 30, 2009 11:25 AM
To: java400-l@xxxxxxxxxxxx
Subject: java.sql.Statement.RETURN_GENERATED_KEYS on v6R1 fails
Hi, I have postet it yesterday, but I got some new information.
The following code works fine with V5R4 but not on V6R1
I have created Table:
drop table usraf.go1
create table usraf.GO1 (
govdc char(30)
)
executed InsertStatement:
AS400JDBCDataSource ds= new AS400JDBCDataSource("192.168.2.2" ,"XXX",
"XXX");
try{
ds.getConnection().createStatement().executeUpdate("INSERT INTO usraf.GO1
(govdc ) VALUES ('§ÄÄÄÖÖÖ' )",java.sql.Statement.RETURN_GENERATED_KEYS);
}
catch (SQLException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
the string i used is only for test purpose.
The column uses CCSID 273
The jt400.jar is the same.
After executing the statement on both servers I can find the entry but the
text is not
correct on V6R1. The carrecters I can see are:
@¢¢¢\\\
When using same code but with java.sql.Statement.NO_GENERATED_KEYS, or
without 2nd parameter, then everything is ok. All characters are correct.
Also on V5R4 everything is correct
Thanks in advanced for any advie or help.
Mit freundlichen Grüßen / Best regards
DI(FH) Andreas Fritz
Leitung Java-Entwicklung
__________________________________________
Vector SW DV GmbH
Ernst-Melchior-Gasse 20
1020 Wien / Austria
fon: +43 1 216 50 40 - 0
fax: +43 1 216 50 40 - 50
UID: ATU15116602
FB: 99492m
Firmenbuchgericht: Handelsgericht Wien
Besuchen Sie uns / visit us at
http://www.vector.eu
__________________________________________
midrange.com
