openmolecules.org Forum: Functionality » Retrieve data from SQL database

Home » DataWarrior » Functionality » Retrieve data from SQL database (Can we use any SQL database ?)

Show: Today's Messages :: Polls :: Message Navigator

Retrieve data from SQL database [message #2158]

Fri, 12 April 2024 12:47

sylvain.guilbaud
Messages: 4
Registered: April 2024

Junior Member

Hello,
while trying to retrieve data from SQL databases, I'm able to make it work with MySQL, but not with InterSystems IRIS (ie : intersystems-community.github.io/iris-driver-distribution/).

Could you please drive me on how to add a new JDBC Driver to Data Warrior ?

Thanks

Report message to a moderator

Re: Retrieve data from SQL database [message #2190 is a reply to message #2158]

Sun, 12 May 2024 12:16

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

Re: Retrieve data from SQL database [message #2213 is a reply to message #2190]

Fri, 24 May 2024 11:35

sylvain.guilbaud
Messages: 4
Registered: April 2024

Junior Member

Hi Thomas,
many thanks for your reply.
I clearly need more information regarding which additional information I need to put into the Info.plist file.
Could your bring me more details on how to proceed ?

Report message to a moderator

Re: Retrieve data from SQL database [message #2268 is a reply to message #2158]

Fri, 02 August 2024 20:20

sylvain.guilbaud
Messages: 4
Registered: April 2024

Junior Member

Hello,
for your information, I posted a PULL REQUEST on the DataWarrior repo to integrate InterSystems IRIS, adding the JDBC IRIS driver, and connection modifications.

Report message to a moderator

Re: Retrieve data from SQL database [message #2269 is a reply to message #2268]

Fri, 02 August 2024 20:22

sylvain.guilbaud
Messages: 4
Registered: April 2024

Junior Member

https://github.com/SylvainGuilbaud/datawarrior/blob/intersystems-iris/img/DataWarrior_with_IRIS.jpg

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Nov 21 22:30:46 CET 2024

Total time taken to generate the page: 0.03572 seconds