GeeCON Prague 2014*
The moose likes JDBC and the fly likes xml / Data Typer mismatch Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "xml / Data Typer mismatch" Watch "xml / Data Typer mismatch" New topic
Author

xml / Data Typer mismatch

Stu Boulton
Greenhorn

Joined: Oct 02, 2002
Posts: 3
Hi All,
I'm a complete Java and XML beginner and am trying to parse some xml on the iseries.
I've copied a test program of the IBM website to parse an XML file and get it into a DB400 file and am slowly debugging it on the AS400. I'm getting to a method
//;**********************************************
//;Initialise the insert statement
//;
//;
public static void clearPrepSqlParms() {
int r;
try {
for (r = 1; r <= 22; r++) {
psAddress.setString(r, "?");
}
} catch (java.sql.SQLException e) {
e.printStackTrace();
}
}
and receive the message:
e = com/ibm/db2/jdbc/app/DB2JDBCException:F62737DA1701E230
e.SQLState=07006
e.next=null
e.vendorCode=-99999
The prepared insert statement is as follows
psAddress =
dbCon.prepareStatement( "INSERT INTO TEST.ADSBKDP "+
"(AYPNUM, AYSBIP, AYSQNO, AYORDN, AYSDSQ, AYDA01, AYDA02, AYDA03, "+
"AYDA04, AYDA05, AYDA06, AYDA07, AYDA08, AYSDCR, AYSDQT, AYBDTP, "+
"AYDCCD, AYDBDS, AYBDST, AYCOCD, AYPSCD, AYSCMP) "+
"VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ");
as the program has already built the statement previously and not thrown an eception why when I call the method clearPrepSqlParms() does an exception get thrown.( and why does it involve "JDBC")
Thanks in advance
Stu
 
wood burning stoves
 
subject: xml / Data Typer mismatch