• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Exception While Updating

 
Maryam Nouhnejad
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I get an exception when I want to use update in my database methods.

the exception is :

Exception in thread "main" 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.
I wrote the ResultSet this way :

PreparedStatment pstmt = Connection.PreparedStatment("select * from laptop" , ResultSet.TYPE_SCROLL_SENSITIVE , ResultSet.CONCUR_UPDATABEL);

ResultSet rs = pstmt.executeQuery();


(Note that I only use one table)

I don't know what the problem can be... would you please help me?
 
Carol Enderlin
drifter
Ranch Hand
Posts: 1364
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Does the table have a primary key?

Next time you post code, please copy-paste instead of typing it in, that is obviously not the actual code you are using.
 
Maryam Nouhnejad
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I could solve my problem .
I made a primary key for my table and now I recive no exception .
Thanks
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic