ahh... yes. I misunderstood your problem. Thought that you didn't specify identity column and expect to get the generated key even though your table has none.
but I got no solution for your real problem.
good luck
regards
Mihael
-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of A.Fritz@xxxxxxxxx
Sent: Friday, October 30, 2009 12:15 PM
To: Java Programming on and around the iSeries / AS400
Subject: Antwort: RE: java.sql.Statement.RETURN_GENERATED_KEYS on v6R1 fails
thats correct,
it does not make any difference in behaviour if you define a primary key
for this problem
"Schmidt, Mihael" <Mihael.Schmidt@xxxxxxxxxxx>
Gesendet von: java400-l-bounces@xxxxxxxxxxxx
30.10.2009 11:59
Bitte antworten an
Java Programming on and around the iSeries / AS400
<java400-l@xxxxxxxxxxxx>
An
"Java Programming on and around the iSeries / AS400"
<java400-l@xxxxxxxxxxxx>
Kopie
Thema
RE: java.sql.Statement.RETURN_GENERATED_KEYS on v6R1 fails
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
