openmolecules.org

 
Home » DataWarrior » Functionality » Retrieve data from SQL database (Can we use any SQL database ?)
Re: Retrieve data from SQL database [message #2190 is a reply to message #2158] Sun, 12 May 2024 12:16 Go to previous messageGo to previous message
thomas is currently offline  thomas
Messages: 693
Registered: June 2014
Senior Member
you would need to add the driver into the class path. On Linux or Mac, you could extend the class path easily in Info.plist or th datawarrior launch script. On Windows this is more difficult. On Windows you could merge the driver into the newest datawarrior_xxx.jar. Or you could patch the exe, which contains the class path.

Then you would need to adapt the method "openConnection()" in class com.actelion.research.datawarrior.task.db.DETaskSQLQuery to properly initialize your driver if the connect string starts with the proper key word.

Thus, if you can compile the DataWarrior source code, and if you run on a non-Windows platform, you can do it for yourself. Otherwise, it is not possible, currently.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: red slide rule after applying filtering macro on EL -- warning, or error?
Next Topic: macro comments
Goto Forum:
  


Current Time: Sun Aug 25 00:23:25 CEST 2024

Total time taken to generate the page: 0.03705 seconds