db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bob M <rgmatth...@orcon.net.nz>
Subject Problem updating a record
Date Mon, 02 Dec 2013 15:48:29 GMT
Hi there 

I have the following code:- 

****************************************************************************** 
// retrieve the last record from the table 
rs = s.executeQuery("SELECT * FROM USD_JPY ORDER BY Date DESC, Time DESC
FETCH FIRST ROW ONLY"); 
rs.next(); 
String Date1 = rs.getString("Date"); 
String Time1 = rs.getString("Time"); 

myConsole.getOut().println("Date/Time: " + Date1 + ", " + Time1); 

// Update this record by adding predicted return and predicted class 
psUpdate = conn.prepareStatement("UPDATE USD_JPY SET
Return_predicted=?,Class_predicted=?"); 
statements.add(psUpdate); 

psUpdate.setDouble(1, return_current); 
psUpdate.setString(2, class_current); 

conn.commit();

myConsole.getOut().println("Updated latest record with predicted return: " +
return_current + ", predicted class: " + class_current); 
 
*********************************************************** 

However, the record is NOT being updated as I am wishing it to be ?

Any ideas ?

Bob M



--
View this message in context: http://apache-database.10148.n7.nabble.com/Problem-updating-a-record-tp135856.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

Mime
View raw message