SQLite and JPA using Netbeans 6.1
843859May 28 2008 — edited Nov 20 2014Hi,
I'm quite new to Java and I'm starting some homework using Netbeans 6.1 to build a simple GUI to a database.
I've successfully connected Derby as well as H2 databases to simple forms, but when I try to connect a SQLite db I get some errors.
SQLite pure java wrapper (sqlitejdbc-v047-nested) works since I can execute sql queries in Netbeans and view tables and data, but Netbeans refuses to generate entity classes and jTable linked to database table gives me a JPA error in named queries when trying to run my app.
Is SQLite JPA compliant ? Is there an easy way to use java persistence schemas in Netbeans for a SQLite database ?
Maybe the problem can be solved writing on my own entity classes to add to persistence schema or I'm goingo to fail even this way ?
Many thanks for your kind attention
Michele