| Issue 183: | SMSServer - Update outbound on statusreport - Exception | |
| 1 person starred this issue and may be notified of changes. | Back to list |
Sign in to add a comment
|
I had to include the "id" field in the query to avoid a exception. I am
running it on Linux using the Javacomm v3.
#Database.class - MessagesReceived()
ResultSet rs2;
cmd2 = con.createStatement(ResultSet.TYPE_FORWARD_ONLY,
ResultSet.CONCUR_UPDATABLE);
rs2 = cmd2.executeQuery("select id, status from " + getProperty
("tables.sms_out", "smsserver_out") + " where recipient = '" +
((StatusReportMessage) msg).getRecipient() + "' and ref_no = '" +
((StatusReportMessage) msg).getRefNo() + "'");
#### Exception #####
com.mysql.jdbc.NotUpdatable: Result Set not updatable.This result set must
come from a statement that was created with a result set type of
ResultSet.CONCUR_UPDATABLE, the query must select only one table, and must
select all primary keys from that table. See the JDBC 2.1 API
Specification, section 5.6 for more details.
|
||||||||||||
,
Feb 13, 2009
r1754, thank you.
Status: Completed
Labels: Milestone-v3.4.0 Component-SMSLib Priority-Medium |
|||||||||||||
,
Mar 29, 2009
(No comment was entered for this change.)
Status: Fixed
|
|||||||||||||
|
|
|||||||||||||