CacheRowSetImpl with Oracle
Hi, I have a error in a function, the command is executed in the database, but, in the application I have a error, the function is:
public String testInvoice(String tradetype, long invoice, double value){
String message = new String("Sucess!!!");
CachedRowSetXImpl rowSet = new CachedRowSetXImpl();
try{
rowSet.setDataSourceName("java:comp/env/jdbc/SoloRosas");
String command = "UPDATE SOLOROSAS.FLOWERINVOICES SET SUBTOTAL = ? WHERE TRADETYPE LIKE ? AND INVOICE = ?";
rowSet.setCommand(command);
rowSet.setDouble(1, value);
rowSet.setString(2,tradetype);
rowSet.setLong(3, invoice);
rowSet.execute(); <<< In this point appear the error
rowSet.commit();
}catch(SQLException sqle){
message = sqle.toString();
}finally{
if(rowSet != null){
rowSet.close();
}
}
return message;
}
The database is Oracle 9i, I dont know what is my error please help me
thanks
