sqlitejdbc

SQLiteJDBC and PreparedStatement to use pragma table_info

I'm utilizing Java and SQLiteJDBC to work with SQLite. I need to access name of columns for a given table and I've found that I could accomplish this with the following command: pragma table_info(myTable) However, when attempting to do the following I get an error. PreparedStatement _pstmt = this._DBConnection.prepareStatement("pragm...

How do I list all the available views of a particular table in SQLite ?

I want to access all the particular views of any particular table in Sqlite . I know I can get the list of all the available tables in the database using sqlite_master SELECT name from sqlite_master WHERE type='table'; And the list of all the available views using SELECT name from sqlite_master WHERE type ='view'; But I want to f...

Why is this query answered instantly by the sqlite3 application, but slowly using sqlitejdbc?

I'm using Mac OS X v10.4.11 with the standard Java (1.5.0_19) and sqlite3 (3.1.3) that came it. (Yeah, a little old... but see comment below.) I have a sqlite3 database with a table with a few hundred thousand rows, with "name" and "stored" text columns. Name is one of six (so far) short strings; stored is a 19-character standard date...

Derby/JavaDB vs SQLiteJDBC

I found a lot of comparisions here, but not this one; So, what is best in each one? ...

Are there big differences from SQLite to SQLiteJDBC?

Will I get support successful from SQLite users even using SQLiteJDBC? (I know nothing about both) ...

SQLiteJDBC giving org.sqlite.MetaData.getImportedKeys not yet implemented error with Hibernate

Hi all, SQLiteJDBC was giving me the following exception when used with hibernate's "hbm2ddl.auto = update" setting: org.sqlite.MetaData.getImportedKeys not yet implemented Any solutions? I found one below, and am posting it here for my future reference, but anyone else have any better ideas? ...

Compiling sqlitejdbc driver with sqlcipher in cygwin

Hey I managed to compile the sqlitejdbc from here. The instructions in the MakeFile there says: Makefile for the native SQLite JDBC Driver No auto-goop. Just try typing 'make'. You should get two interesting files: build/TARGET_OS/LIBNAME build/sqlitejdbc-vXXX-native.jar To combine these, type: cd build mv LI...

SQLiteJDBC transaction log

Hey I wrote a test java application that uses sqlitejdbc. I was wondering if there was a way to obtain a transaction log that displays the way that the application communicated with the database while it ran. heres what I have written: Class.forName("org.sqlite.JDBC"); Connection conn = DriverManager.getConnection("jdbc:sqlite:test.db...