telosystools

Open full view…

SQLite database driver

torpedomick
Mon, 01 Jul 2019 07:37:21 GMT

I tried to use SQLite in Telosys, but did not work. Could not connect to .jar file sqlite-jdbc-3.23.1.jar ldb: . Driver class : /Users/md/Documents/AAA/ctl/TelosysTools/lib/sqlite-jdbc-3.23.1.jar . JDBC URL : sqlite:////User/md/Documents/CAPP.sqlite cdb: Checking database... [ERROR] Exception class : TelosysToolsException [ERROR] Exception message : Cannot load class '/Users/md/Documents/AAA/ctl/TelosysTools/lib/sqlite-jdbc-3.23.1.jar' (ClassNotFoundException) I tried with three and four slashes .. any idea? help woulf be very appreciated!

Telosys Team
Tue, 02 Jul 2019 21:53:47 GMT

The driver class must be a Java class name (not a .jar file name) According to this article https://stackoverflow.com/questions/1525444/how-to-connect-sqlite-with-java it seems to be "org.sqlite.JDBC"

torpedomick
Thu, 04 Jul 2019 08:07:59 GMT

Wow, thank you. I tried this and got: cdb Checking database... [ERROR] Exception class : TelosysToolsException [ERROR] Exception message : Cannot connect to the database. JDBC driver 'connect()' has returned null. because I think it does not know which driver to use now in /lib? I did not find any place to enter this. Is there any special typeName other than "SQLITE"? Or do I have to change someting in the complete package? Thanks again for helping a Java-dumb developer ;-)

Telosys Team
Fri, 05 Jul 2019 20:22:00 GMT

Here's a Blog Post with all information https://telosys.blogspot.com/2019/07/create-database-model-from-sqlite-db.html