This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
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


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.
 
Have you checked out Aspose?
 
subject: SQLiteJDBC
 
It's not a secret anymore!