Robotframework-Database-Library icon indicating copy to clipboard operation
Robotframework-Database-Library copied to clipboard

Issue with connecting multiple times with different drivers using jaydebeapi

Open IlfirinPL opened this issue 4 years ago • 1 comments

I found issue that when connecting using jaydebeapi, driver is not properly reload classes to connect to databases. I have setup that both drivers are added to CLASSHPATH and base on order of connection to databases will rise different error.

I am look also for some work around for this issue, I have tried to use "Reload Library" but did not provided any solutions

Append To Environment Variable | CLASSPATH | jt400.jar | mssql-jdbc-8.4.0.jre14.jar
Connect To Database Using Custom Params | jaydebeapi | "com.ibm.as400.access.AS400JDBCDriver", ${connection string db2} Connect To Database Using Custom Params | jaydebeapi | "com.microsoft.sqlserver.jdbc.SQLServerDriver", ${connection string ms}

in following order will rise error TypeError: Class com.microsoft.sqlserver.jdbc.SQLServerDriver is not found

when order of connection is changed will rise TypeError: Class com.ibm.as400.access.AS400JDBCDriver is not found

IlfirinPL avatar Aug 27 '20 14:08 IlfirinPL

Connecting multiple times is not currently supported. If you can get working and submit a pull request, that would be great. Unfortunately I am not able to work this at this time.

jerry57 avatar Oct 27 '20 18:10 jerry57