[1.1.4] IDE: load() does not seem to work anymore

Asked by Ron Turrentine on 2018-08-28

OS: Windows 10
SQL Server: 2012
Utilizing zxJDBC (ziclix)
Driver: Microsoft JDBC driver 7.0 for SQL Server (obtained here):
(https://www.microsoft.com/en-us/download/details.aspx?id=57175)

With the script that I built in SIkuliX 1.1.2, I can successfully connect to our SQL Server and insert/update records.
My script also works well in SikuliX 1.1.3.

However, when I try to run the script in SikuliX 1.1.4, I receive this error:
"driver [com.microsoft.sqlserver.jdbc.SQLServerDriver] not found"

It's the same exact script, just running in 1.1.4 instead of 1.1.3.

The code that I am using to connect to SQL can be viewed in my post here:
https://answers.launchpad.net/sikuli/+question/672153

Is this a bug, or do I need to load the SQL Driver differently in 1.1.4 than I do in 1.1.2 & 3?

Thanks!

Ron Turrentine

Question information

Language:
English Edit question
Status:
Solved
For:
Sikuli Edit question
Assignee:
No assignee Edit question
Solved by:
RaiMan
Solved:
2018-08-29
Last query:
2018-08-29
Last reply:
2018-08-29
Best RaiMan (raimund-hocke) said : #1

Try the following:
copy the micosoft jar to the <app-data>/Sikulix/Extensions folder (where the jython jar is also)

This will auto load it to the Java class path at start up of the IDE, so it should be found later.

The load() command apparently has to be revised. Thanks for finding.

Ron Turrentine (oldtimerocker) said : #2

Thanks RaiMan! I tested your workaround and it did the trick.

I appreciate the help!

Ron

Ron Turrentine (oldtimerocker) said : #3

Thanks RaiMan, that solved my question.

RaiMan (raimund-hocke) said : #4

Thanks for feedback and confirmation.