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: 715
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.

Report message to a moderator

[Message index]
 
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: number of visible rows into macro saving variable
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ] [ PDF ]

Current Time: Sun Nov 24 16:14:44 CET 2024

Total time taken to generate the page: 0.03986 seconds
openmolecules.org