sqlite-jdbc
sqlite-jdbc copied to clipboard
xerial
SQLite JDBC Driver
It would be possible if you can transform internally the Long value of date to Date? I did use Apache Commons DbUtils, and it has one feature that is awesome,...
This issue effects mainly using deprecated functions in [spatialite](http://www.gaia-gis.it/gaia-sins/). - RTreeWithin - RTreeContains - RTreeIntersects - RTreeDistWithin via the `sqlite3_rtree_geometry_callback` If one does a search for RTreeIntersects they will find...
`SQLiteConfig` class sets default values such as `dateStringFormat` already in place when `toProperties` is called. This happens prematurely because `extractPragmasFromFilename` of `CoreConnection` thinks that these values are user defined because...
Hello, I am facing a problem using JDBC3Statement sqlite implementation of Statement. The JDK API says about Statement.setQueryTimeout() ``` seconds - the new query timeout limit in seconds; zero means...
The following code does not close the Statement, if the ResultSet is empty (has no results): ``` Statement stmt = con.createStatement(); stmt.closeOnCompletion(); //now closing the ResultSet should close the Statement...
Is there a way to add in a native for ppc (not ppc64). Ubuntu Trusty doesn't seem to have an OpenJDK 8 for ppc.
When a proxy connection returned by SQLitePooledConnection#getConnection() is used to create a statement, the underlying physical connection is exposed on the statement. I am using a third-party library which is...
CachedRowSet with SQLite and Xerial driver - the call of method execute() throws SQLException "not implemented by SQLite JDBC driver", sample code: ``` Connection connection = DriverManager.getConnection("jdbc:sqlite:sample.db"); CachedRowSet crs =...
Add this example of a more modern demo Sample.java ``` import java.sql.*; public class SampleModern { public static void main(String[] args) { try (Connection connection = DriverManager.getConnection("jdbc:sqlite:target/demo-modern.db"); Statement statement =...
In [Logstash (an OS ETL application)](https://github.com/elastic/logstash) we have JDBC inputs. If a user supplied configuration (a DSL based text file) has multiple JDBC inputs using SQLite, then the last input...
