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

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

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

Thank you.
Back to top
IP Logged
YaBB Administrator

Posts: 2260
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

Anyway, sqlite has a lot of "wrappers", including a few for Java:
also see

I never used any of them, except SQLiteExplorer ( ). Most of the time, sqlite3.exe (the commandline sql tool) is more than enough.

Back to top

Gert Rijs - gert (at) gdpsoftware (dot) com
End Alzheimer's:
WWW WWW GdPSoftware  
IP Logged
Page Index Toggle Pages: 1