My favorites | Sign in
Logo
                
New issue | Search
for
| Advanced search | Search tips
Issue 183: SMSServer - Update outbound on statusreport - Exception
1 person starred this issue and may be notified of changes. Back to list
 
Reported by italo.ferraz, Feb 13, 2009
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.

Comment 1 by T.Delenikas, Feb 13, 2009
r1754, thank you.
Status: Completed
Labels: Milestone-v3.4.0 Component-SMSLib Priority-Medium
Comment 2 by T.Delenikas, Mar 29, 2009
(No comment was entered for this change.)
Status: Fixed
Sign in to add a comment

Hosted by Google Code