There is a workaround for this: Go here: http://download.oracle.com/docs/cd/B19306_01/java.102/b14355/resltset.htm#i1022314
and locate the phrase "SELECT t.* FROM TABLE t ...". This change should be easier than adding all fields. On Mar 7, 4:36 pm, Thanasis <[email protected]> wrote: > Ok, got it. > > It seems that Oracle cannot create updatable result sets when the > underline select is a "select * ...". It requires an explicit > declaration of fields. > > For example, in method MessagesReceived() there is an SQL: > > rs = cmd.executeQuery("select * from " + getProperty("tables.sms_in", > "smsserver_in") + " where id = -1"); > > This creates a problem. > If you rewrite it like this: > > rs = cmd.executeQuery("select > id,process,originator,type,encoding,message_date,receive_date,text,original > _ref_no,original_receive_date,gateway_id > from " + getProperty("tables.sms_in", "smsserver_in") + " where id = > -1"); > > everything works ok. > > For the moment, the only thing you can do is to rewrite all "SELECT *" > sql statements and set them to select all fields instead of "*". > I will keep a note to fix this in next release. > > On Mar 7, 4:24 pm, Thanasis <[email protected]> wrote: > > > I tried with Oracle EX 10g (with the included jdbc driver) and I am > > having the same issue... :( Seems like the ResultSets are not > > updatable. > > > On Mar 7, 10:11 am, Thanasis <[email protected]> wrote: > > > > Well, I don't have an answer yet, but I am downloading Oracle Express > > > to install and have a look... > > > > On Mar 6, 6:00 am, Anup <[email protected]> wrote: > > > > > After making some changes in createStatement(), the error is solved. > > > > But till there is one error related to resultset is: > > > > > java.sql.SQLException: Invalid operation for read only resultset: > > > > updateString > > > > > So, can you give me solution for this? > > > > > Thank You. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SMSLib User Group" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/SMSLib?hl=en -~----------~----~----~----~------~----~------~--~---
