Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Jun 30th, 2012  |  syntax: None  |  size: 0.48 KB  |  hits: 12  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. error in Executing PreparedStatement over DB2 Express-C
  2. String query = "SELECT A, B, C, D, LOBJ FROM TABLE WHERE LOBJ = 'sGMMEMDEML2';
  3.  
  4. Statement stmt = con.createStatement()
  5.  
  6. ResultSet rs = stmt.executeQuery(query);
  7.        
  8. String query = "SELECT A, B, C, D, LOBJ FROM TABLE WHERE LOBJ = ?;
  9.  
  10. PreparedStatement preStmt = con.prepareStatement(query);
  11.  
  12. preStmt.setString(1, 'sGMMEMDEML2');
  13.  
  14. ResultSet rs = preStmt.executeQuery();
  15.        
  16. db2set DB2_COMPATIBILITY_VECTOR=ORA # or MYS
  17. db2stop
  18. db2start