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
DATABASE connection (JDBC, ODBC...) (Read 2837 times)
YaBB Newbies

Posts: 7
DATABASE connection (JDBC, ODBC...)
Apr 20th, 2006 at 8:41pm
Each time a file is manipulated with watchdirectory => Insert with SQL command into Database via JDBC or ODBC? Filename, fullpath, other information... ????
Back to top
IP Logged
YaBB Administrator

Posts: 2270
The Netherlands
Re: DATABASE connection (JDBC, ODBC...)
Reply #1 - Apr 21st, 2006 at 5:00am

a plugin to do that does not exist yet, but it is planned for the future. If your database has a commandline option, you could use the bat script plugin to call it and insert the info.

Completely made-up sample:
InsertDb.exe insert into tab (datetime, directory, filename, extension) values ("%WD_DTTM%", "%WD_FILE_D%", "%WD_FILE_N%", "%WD_FILE_E%")

Also, the bat file plugin can be used to start Visual Basic scripts, and I believe those have direct support for databases. A sample .VBS is installed with watchDirectory.

Back to top

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