SQLite or other "DB in a file" for Java?

[Andrew Fabbro]

Is there something like SQLite for Java? i.e., something that allows
me to speak SQL to a file without having a DBMS to talk to?

In C, there's the SQLite package (http://www.hwaci.com/sw/sqlite/).
I'm just curious what's out there for Java that is similar.

Thanks,

-Drew

 

[Roedy Green]

Is there something like SQLite for Java? i.e., something that allows
me to speak SQL to a file without having a DBMS to talk to?

Yes. There is at least on that runs inside the JVM. see
http://mindprod.com/jgloss/sql.html

 

[Michael Borgwardt]

Is there something like SQLite for Java? i.e., something that allows
me to speak SQL to a file without having a DBMS to talk to?

HSQLDB's standalone mode pretty much works like that (http://hsqldb.org/).
As does using a Microsoft Access DB file via Sun's JDBC-ODBC bridge.