iSQL-Viewer / Discussion / Open Discussion and Support: Table Data Editor Not Working

Nobody/Anonymous - 2004-12-07

I receive the following dialog when attempting to edi a table in the Table Data Editor Dialog.

"An non-updateable ResultSet was recieved. The selected table cannot be edited with this tool."

Why?

I am using Oracle 8i with the ojdbc14.jar drivers.

Thanks!

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Markus A. Kobold - 2004-12-07
  
  In JDBC ResultSets have 2 mode of concurrency, READ_ONLY and UPDATABLE.
  
  Now the reason you are getting the message is because oracle 1.4 drivers do not support updatable resultsets, worse yet the driver was giving me misleading information.
  
  I would also like to point out that this is one of those wierd inconsistencies of the JDBC API's that people tend to dislike, and part of the reason for writing this tool in the first place.
  
  Here is logically what the table editor component/tool does.
  
  When the the table editor tool is open the driver is queried to check to see even if updatable resultsets are even supported. The oracle driver says it does support updatable resultsets, and so the component continues to load, (* you would otherwise get an error saying it wasn't supported *) . Now when the table is queried i tell the driver that i want to execute the statement with updatable results. However as you have seen i double check the result set and it says it is not updatable, so in light of possibly causing instability in the program or worse ruining data, i complain and drop the results.
  
  On the other hand it is my understanding that the 10g+ drivers for oracle do support this but i have no verification on this.
  
  PostgreSQL, and MySQL do support the whole updatable results correctly so if you want to see it work, you can use those platforms.
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Bruce Alspaugh - 2005-10-12
  
  I'm having a similar problem with OneDollarDB (www.daffodildb.com). When I try to insert a new row, I get a "Result Set is Closed" exception. They claim their JDBC 3.0 driver fully supports updateable result sets.
  
  Can someone verify if this is the same problem?
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
  - Markus A. Kobold - 2005-10-12
    
    I personally have never used the onedollardb.
    
    so I unfortunately can contribute any information for you.
    
    If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Bruce Alspaugh - 2005-10-14
  
  I tried to get more information for you by posing the question to the support people for the DB. Here is a link to their response. I imagine this would affect more than just OneDollarDB.
  
  http://www.daffodildb.com/forum/thread.jspa?threadID=1976&tstart=0
  
  OneDollarDB is an open-source pure Java database, supports updateable result sets, multiversion concurrency control, well-documented, and easy to use. It took me about 20 minutes to get it up and running. Should be easy to verify.
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
  - Markus A. Kobold - 2005-10-14
    
    OK Thanks I will double check my source amke sure that i am not in advertanly closing the ResultSet.
    
    If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Table Data Editor Not Working

Forums

Help

Table Data Editor Not Working

Table Data Editor Not Working

Forums

Help

Table Data Editor Not Working document.SUBSCRIPTION_OPTIONS = { "thing": "topic", "subscribed": false, "url": "subscribe", "icon": { "css": "fa fa-envelope-o" } };

Table Data Editor Not Working