Random behaviour from a Result Set
2 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Cristian_Rojas
Posted On:   Saturday, May 4, 2002 10:32 AM

I have an application that uses an Updatable ResultSet, but from time to time it gets me a ReadOnly ResultSet. There is only 1 table to read, and this table is generated by another application that just make inserts.


Does any one know what's going on?

Re: Random behaviour from a Result Set

Posted By:   Bozidar_Dangubic  
Posted On:   Sunday, May 5, 2002 07:23 AM

you probably get a read-only result set due to a database lock. check first if someone else is locking your tables. that is the most likely cause of your problem.

Re: Random behaviour from a Result Set

Posted By:   Anonymous  
Posted On:   Saturday, May 4, 2002 09:00 PM

If the query is always the same, I really have no idea. But there are some queries that can not be updatable by nature. You might also turn on logging, both for the driver and DBMS to see if you can garner any further clues.
About | Sitemap | Contact