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



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
 
Gert
YaBB Administrator
*****
Offline



Posts: 2233
The Netherlands
Re: DATABASE connection (JDBC, ODBC...)
Reply #1 - 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%")
 


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