Re: [OpenBD] Re: sqlite

Fri, 24 Jun 2016 18:24:26 -0700

It did this several times. Shut server down, turn back on, file gets deleted. I have explorer open and can see the file disappear upon starting openbd. I have kind of given up on this idea for now and have moved on to php. Working with sqlite is built in. I will still use CF to create my raw data. Then use php to put it in a sqlite database. I will be doing it this way mostly because I am more proficient with CF over php. I have already done this as an experiment in this past hour using cfhttp on the php localhost. The end goal is I have a program on my vps that uses sqlite databases. I will create the database on my laptop and upload it the vps.

Thanks for your help.
Tom Thomas

At 04:32 PM 6/24/2016, you 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 [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.

--
--
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.

Reply via email to