WatchDirectory home page
WatchDirectory Startseite (Deutsche Version)
Site WatchDirectory (Français)
  Welcome, Guest. Please Login or Register
YaBB - Yet another Bulletin Board
   
  HomeHelpSearchLoginRegister  
 
Page Index Toggle Pages: 1
SQLite ODBC connections (Read 1941 times)
unixrulemas
YaBB Newbies
*
Offline



Posts: 3
SQLite ODBC connections
Dec 2nd, 2005 at 10:24pm
 
Hi,

I see this file newdatabase.sql in C:\Program Files\watchDirectory.
It looks like there is a SQLite db sitting somewhere...is there a way to connect to this db using JDBC?

Thank you.
Back to top
 
 
IP Logged
 
Gert
YaBB Administrator
*****
Offline



Posts: 2224
The Netherlands
Re: SQLite ODBC connections
Reply #1 - Dec 2nd, 2005 at 10:44pm
 
Yes, there is a file called history.db for each of your tasks. They are located below your task-directory, normally C:\Documents and Settings\All Users\Application Data\watchDirectory.
In last month's newsletter, I offered 2 tips to query those databases, see http://www.watchdirectory.net/newsletter/200511.html

Anyway, sqlite has a lot of "wrappers", including a few for Java:
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
also see
http://www.sqlite.org/cvstrac/wiki

I never used any of them, except SQLiteExplorer ( http://www.singular.gr/sqlite/ ). Most of the time, sqlite3.exe (the commandline sql tool) is more than enough.

Gert
Back to top
 

Gert Rijs - gert (at) gdpsoftware (dot) com
Blog: http://blog-en.gdpsoftware.com/
End Alzheimer's: http://www.alz.org&&...
WWW WWW GdPSoftware  
IP Logged
 
Page Index Toggle Pages: 1