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.
