wood burning stoves 2.0*
The moose likes JDBC and the fly likes SQLiteJDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
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.
 
GeeCON Prague 2014
 
subject: SQLiteJDBC