MIDRANGE dot COM Mailing List Archive



Home » JAVA400-L » October 2009

RE: Antwort: RE: java.sql.Statement.RETURN_GENERATED_KEYS on v6R1 fails



fixed

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
__________________________________________






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact