Hi, in Servoy 5.1.3 I have a connection which works fine with the driver sqlitejdbc-v054.jar in the drivers folder.
In Servoy 5.2 when I try to create the same connection to the same file, I get this message. I’ve tried with sqlitejdbc-v054.jar and then with sqlitejdbc-v056.jar in the drivers folder.
Can anyone suggest how I might fix this?
When you put the jar file in the drivers folder did you restart Servoy?
Yup. Several times, and rebooted the Mac.
All I can tell from the error is that the classpath is not set properly to find the jar file or some dependent of it.
In your previous setup did you have to change the classpath setting when starting servoy?
(Maybe it would be easier to avoid SqlLite and use the 5.2.2 built in postgres dbms )
I installed the driver in the Servoy 5.2.2 applications/driver folder.
I just tried creating a new db server and had to create the folder structure “/Users/ts/db” before it would work.
No error message for me.
Are you sure you have installed Servoy 5.2.2 correctly?
Thanks for the thoughts.
I do use PG for most things, but maintain an SQLITE db for an iPhone app. I’ve been using Servoy to edit that.
Strangely, if duplicate an existing sqlite connection which uses the sqlite driver and change the URL to jdbc:sqlite:/Users/ts/db/MBS.sqlite it works. It’s when I right click on the Database node and click New Server > Empty and fill out the fields that I get this error.
I’m on Mac OSX 10.6
Java 1.6_22
What platform are you developing on?
I use win xp pro at the moment with win 7. I used MySql until 5.2.2 then switched to postgre for all new work.
I did the experiment on win xp. I right clicked and chose empty for the db type and filled in the fields, no errors. Maybe some typing error - try hand type instead of cut and paste.
Better question maybe why you are wanting to use SQLite? Its primary purpose is for embedded applications. Since Servoy requires an application server, its not possible for the client to connect to a local SQLite DB, it must instead connect through the App Server, wich would them be a SQLite DB on the App server. If your looking for a temp db for temp tables, use the in-memory database from database instead.
If you are actually looking for client side SQL storage, it is possible in the Web Client, but would take some work. I’ve been messing around with it and am considering making a plugin for it. Essentially with HTML5 and some client-side JavaScript you can actually access a SQLite DB through the browser. Would be handy for storing some info client-side, like display preferences, last used login name, etc.
Hi Scott!
SQLite is the db that’s used for read-only reference tables in an existing iPhone application that I support. The data are stored on the phone.
I’m simply using Servoy to update data in a local copy, which is then ported to the iPhone app.
antonio:
Thanks for the thoughts.
Strangely, if duplicate an existing sqlite connection which uses the sqlite driver and change the URL to jdbc:sqlite:/Users/ts/db/MBS.sqlite it works. It’s when I right click on the Database node and click New Server > Empty and fill out the fields that I get this error.
Antonio,
Did you fill in the driver class correctly?
It looks like the driver field was left empty (the driver name is shown in the dialog when it cannot be loaded).
Rob
Hi,
Im using SQLite with Servoy 5.2 on a WinBox and it works.
Driver : http://www.zentus.com/sqlitejdbc/
Settings (Database Server)
HTH
Rainer
antonio:
SQLite is the db that’s used for read-only reference tables in an existing iPhone application that I support. The data are stored on the phone.I’m simply using Servoy to update data in a local copy, which is then ported to the iPhone app.
Well, it should work. However I personally use: https://addons.mozilla.org/en-US/firefox/addon/5817/ when dealing with SQLite. Its a nice FireFox addin.
rgansevles:
Did you fill in the driver class correctly?
It looks like the driver field was left empty (the driver name is shown in the dialog when it cannot be loaded).Rob
Hi Rob, yes, I used the dropdown list of drivers and selected org.sqlite.JDBC
rg400005:
Hi,
Im using SQLite with Servoy 5.2 on a WinBox and it works.
Driver : http://www.zentus.com/sqlitejdbc/Settings (Database Server)
- Directory drivers : sqlitejdbc.jar
- Settings in Database-Server :
3.Url : jdbc:sqlite:- Driver : org.sqlite.JDBC
Thanks for the info, I’m using the driver from Zentus called sqlitejdbc-v056.jar
Maybe it’s a classpath thing on MAC with Servoy 5.2.2
goldcougar:
Well, it should work. However I personally use: https://addons.mozilla.org/en-US/firefox/addon/5817/ when dealing with SQLite. Its a nice FireFox addin.
Yes! It should work… It DOES work for existing connections, and it does work if I duplicate an existing connection and change the URL to point to the new file, so I have a work around. It just doesn’t work for new connections on my machine.
Thanks for the Firefox tip. I’ll try that too.
