This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
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


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: SQLiteJDBC