WatchDirectory Forum
http://www.watchdirectory.net/cgi-bin/yabb25/YaBB.pl
watchDirectory forums >> Plugins >> DATABASE connection (JDBC, ODBC...)
http://www.watchdirectory.net/cgi-bin/yabb25/YaBB.pl?num=1145558507

Message started by kenobee on Apr 20th, 2006 at 8:41pm

Title: DATABASE connection (JDBC, ODBC...)
Post by kenobee on 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... ????

Title: Re: DATABASE connection (JDBC, ODBC...)
Post by Gert on Apr 21st, 2006 at 5:00am
Hi,

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:
[code]
InsertDb.exe insert into tab (datetime, directory, filename, extension) values ("%WD_DTTM%", "%WD_FILE_D%", "%WD_FILE_N%", "%WD_FILE_E%")
[/code]
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.

Gert

WatchDirectory Forum » Powered by YaBB 2.5.2!
YaBB Forum Software © 2000-2017. All Rights Reserved.