The console window does not bring back any of the meta data for the database. I cannot run any SQL queries against database. I would appreciate any points to getting Sqlite working.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
Thanks for using osDQ. You should first run SQLLite form connection Dialog
which is attached. If it is successful, then use the same parameters and
Database_Type="OTHERS" as sqlLite is not pre-configured.
Make sure the jdbc jar file for SQLLite is under lib/jdbc
The console window does not bring back any of the meta data for the
database. I cannot run any SQL queries against database. I would appreciate
any points to getting Sqlite working.
Thanks for the prompt and helpful response. It worked using your suggested method.
I also managed to get the configFile.txt to work by escaping the slashes. I am running on Windows 7. Config below worked (the \/ is back and forward slash not letter V):
I am trying to use Sqlite. I have placed the Sqlite JDBC driver in the classpath and in the configFile.txt I have the following entry:
Database_Type="Sqlite"
Database_Driver="org.sqlite.JDBC"
Database_Protocol="jdbc:sqlite"
Database_DSN="C:\path\to\my\database\databasefile.db"
Database_User=""
Database_Passwd=""
Database_Catalog=""
Database_SchemaPattern=""
Database_TablePattern=""
Database_ColumnPattern=""
Database_TableType=""
The console window does not bring back any of the meta data for the database. I cannot run any SQL queries against database. I would appreciate any points to getting Sqlite working.
Hi,
Thanks for using osDQ. You should first run SQLLite form connection Dialog
which is attached. If it is successful, then use the same parameters and
Database_Type="OTHERS" as sqlLite is not pre-configured.
Make sure the jdbc jar file for SQLLite is under lib/jdbc
Make us know if you still face any problem.
On Fri, Jan 11, 2019 at 3:20 PM Mpume msimanga@users.sourceforge.net
wrote:
--
regards,
Vivek Singh
Author of "The Reverse Journey" from Frogbooks
Thanks for the prompt and helpful response. It worked using your suggested method.
I also managed to get the configFile.txt to work by escaping the slashes. I am running on Windows 7. Config below worked (the \/ is back and forward slash not letter V):
Database_Type="Sqlite"
Database_Driver="org.sqlite.JDBC"
Database_Protocol="jdbc:sqlite"
Database_DSN="C:\/path\/to\/my\/database\/databasefile.db"
Database_User=""
Database_Passwd=""
Database_Catalog=""
Database_SchemaPattern=""
Database_TablePattern=""
Database_ColumnPattern=""
Database_TableType="TABLE"
Last edit: Mpume 2019-01-11