Robotframework-Database-Library
Robotframework-Database-Library copied to clipboard
Issue with connecting multiple times with different drivers using jaydebeapi
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
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.