aspose file tools
The moose likes JDBC and Relational Databases and the fly likes SQLiteJDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA Java SE 8 Programmer I Study Guide 1Z0-808 this week in the OCAJP forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "SQLiteJDBC" Watch "SQLiteJDBC" New topic
Author

SQLiteJDBC

Michael Keisu
Ranch Hand

Joined: Oct 08, 2009
Posts: 30
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

Joined: Jun 22, 2005
Posts: 86
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

Joined: Oct 08, 2009
Posts: 30
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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: SQLiteJDBC