sqlite-jdbc
sqlite-jdbc copied to clipboard
xerial
SQLite JDBC Driver
I'm trying to put BLOBs of images to a database and I receive errors after executing the following code: ``` PreparedStatement ps = DriverManager.getConnection("jdbc:sqlite:" + databasePath).prepareStatement("UPDATE users SET picture =...
Does `sqlite-jdbc` currently supports `PreparedStatement#executeLargeUpdate`? I'm trying to use Helidon along with SQLite and I'm getting `java.lang.UnsupportedOperationException: executeLargeUpdate not implemented` so I suppose the default implementation of that method is...
Hi! I am facing an issue and was unable to solve it. It seems that something is wrong with aggregate functions handling on sqlite-jdbc. The error message is: JNI ERROR...
First off, thanks for a great piece of software. SQLite now supports Table-Valued functions. Is there any possibility of the JDBC driver getting an interface for these in the same...
We are trying to create a large SQLite in-memory database and once the DB is created we are dumping it to a file using 'backup to' comand. This is done...
This will address #633. As mentioned in the issue, existing math functions are currently supported by user contributed code (`extension-functions.c ` from https://sqlite.org/contrib). The https://www.sqlite.org/draft/lang_mathfunc.html introduced in 3.35.0 overlap with...
it seems no vacuum setter in SQLiteConfig, how can i set auto_vacuum = INCREMENTAL or auto_vacuum = FULL?
I heavily rely on "ALTER TABLE ... RENAME TO ..." for migrations between database versions in my application. Since upgrading SQLite, this also renames the FOREIGN KEY linking to the...
These pragma are missing: automatic_index ~~secure_delete~~ cache_spill ~~mmap_size~~ Can I set the some other way?
Include new table type "VIRTUAL TABLE". This way, by default, virtual tables will not be shown in [a get tables call](https://docs.oracle.com/en/java/javase/17/docs/api/java.sql/java/sql/DatabaseMetaData.html#getTables(java.lang.String,java.lang.String,java.lang.String,java.lang.String%5B%5D)). Also, if an extension is not loaded, the call...
