
Untitled
By: a guest on
Jun 30th, 2012 | syntax:
None | size: 0.48 KB | hits: 12 | expires: Never
error in Executing PreparedStatement over DB2 Express-C
String query = "SELECT A, B, C, D, LOBJ FROM TABLE WHERE LOBJ = 'sGMMEMDEML2';
Statement stmt = con.createStatement()
ResultSet rs = stmt.executeQuery(query);
String query = "SELECT A, B, C, D, LOBJ FROM TABLE WHERE LOBJ = ?;
PreparedStatement preStmt = con.prepareStatement(query);
preStmt.setString(1, 'sGMMEMDEML2');
ResultSet rs = preStmt.executeQuery();
db2set DB2_COMPATIBILITY_VECTOR=ORA # or MYS
db2stop
db2start