I get this error inside administrator creating a datasource.
Could not register database driver org.sqlite.JDBC. Please make sure this driver is in your classpath.
I am using the desktop version of openbd. version 2.0.2. I know, an old version. So far it has done everything I have wanted it to do.
At 01:49 PM 6/24/2016, you wrote:
First download the jdbc driver from here -- https://bitbucket.org/xerial/sqlite-jdbc/download--
put it your WEB-INF\lib directory,
go to Openbd admin datasource other jdbc driver,
OpenBD Datasource Name -- mydatasourcename,
Driver Class --Â org.sqlite.JDBC
JDBC URL --Â jdbc:sqlite:DIRECTORY\FOLDER\mydatabase.db, like this ---- jdbc:sqlite:C:\mydata\testdb.db,
Verification Query -- select * from testtable
should work fine, I'm on windows, might have to change the back slashes to forward slashes on linux? jdbc:sqlite:C:/mydata/testdb.db
good luck.
On Friday, June 24, 2016 at 11:55:16 AM UTC-5, tomt wrote:
--
- Is it possible to use sqlite with openbd. I have another program that
- uses this database and thought it would be neat to pre-populate the
- tables via cf. I found a cfc on http://sqlitecfc.riaforge.org/ but
- its test file throws an error:
- Failed to load class, coldfusion.sql.QueryTable
- 262: Â Â Â Â Â <cfset queryTable = CreateObject("java",
- "coldfusion.sql.QueryTable")>
- Thanks,
- Tom Thomas
--
online documentation: http://openbd.org/manual/
http://groups.google.com/group/openbd?hl=en
---
You received this message because you are subscribed to the Google Groups "Open BlueDragon" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
For more options, visit https://groups.google.com/d/optout.
--
online documentation: http://openbd.org/manual/
http://groups.google.com/group/openbd?hl=en
---
You received this message because you are subscribed to the Google Groups "Open BlueDragon" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
For more options, visit https://groups.google.com/d/optout.
