Is there a way to pass a PRAGMA argument to turn OFF sync while instantiating the connection , using a argument to the JDBC driver? The SQLite ODBC driver will do this and I cant use the JDBC driver unless it has this feature since my project has transactionless code and inserts are slowed down greatly by the sync code.
Doesn't auto detect local ODBC DSNs or Microsoft SQL Server instances. You have to manually add them. I call that a deal breaker for this app, even though its a simple thing. Also, when I add the SQL Server JDBC 2.0 driver in the "Add drivers" panel, the SQL Server configuration tab doesn't pick up the addition. Also, SQL Server tab should default to port 1433 filled into the "port" field. Also, SQL Server tab should allow configuration of "integratedSecurity=true" with a checkbox (would require loading the .dll lib).