Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQLiteJDBC

 
Michael Keisu
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I came across an exception, which said the following: java.sql.SQLException: NYI
when I tried to implement PreparedStatement stmt = conn.prepareStatement(sql, ResultSet.CONCUR_UPDATABLE);

After some googling, it turns out this feature isn't supported. Not Yet Implemented.

I think ResultSet's "concur updatable" is a really neat feature, and although I'm sure I can think of a workaround, I wonder if anyone has suggestions for better serverless databases?
Preferably something that would be painless to implement in SQLite's stead.

Thanks,
Mike
 
Wei Dai
Ranch Hand
Posts: 86
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think ResultSet's "concur updatable" is a really neat feature
I wonder if anyone has suggestions for better serverless databases

HSQLDB is free and supports servlerless mode and CONCUR_UPDATABLE resultSet.
All of HXTT JDBC drivers are commercial, and support ervlerless mode and CONCUR_UPDATABLE resultSet.
 
Michael Keisu
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks. Although I think i'll try something else with SQLite after all. HSQLDB is making nuts, complaining about user privledges, and then I can't find anything in the documentation that helps much.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic