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
-~----------~----~----~----~------~----~------~--~---
