Re: [OpenBD] Re: sqlite

['Alan Holden' via Open BlueDragon]

Ah yes, the older OpenBD Desktop... memories. I kept using that app up until the last moment I could. I'm using their JettyDesktop now. It's been a really long time, but there may have been a "source" directory in the distro - which is used to populate your application directory with all the files needed on startup. I think there was even a checkbox to turn that option on and off. Anywhoo, if you tried to customize the destination in your (instead of the source in Desktop), then your changes would get stomped @ each startup. I hope I'm not leading you down an outdated or incorrect path here. My recollection is fuzzy. OpenBD's newer JettyDesktop is pretty cool. Al On 6/24/2016 4:32 PM, mark wrote: Sorry but I'm not familiar with obd desktop version, does the web-inf\lib have other jar files in it? Approx. 60-65 files It should not be deleting it, which version of jre are you running. On Friday, June 24, 2016 at 6:13:01 PM UTC-5, tomt wrote: The file I downloaded is named sqlite-jdbc-3.8.11.2.jar and yes it is in the C:\cf\home\WEB-INF\lib I just noticed this though. when I shut the server down and restart it that file some how is being deleted. At 03:55 PM 6/24/2016, you wrote: Did you put the org.sqlite.jdbc jar in the web-inf\lib directory? On Friday, June 24, 2016 at 5:30:00 PM UTC-5, tomt wrote: First the link you gave is wrong, download should be downloads. 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 openbd+u...@googlegroups.com. 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 openbd+u...@googlegroups.com. 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 openbd+unsubscr...@googlegroups.com. 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 openbd+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.