Sikuli

SikuliX Oracle DB connection

Asked by Nitin Chaudhari on 2019-11-01

Hi Team,
Thanks for support.

Would like to connect to Oracle Database through SikuliX.
Could you please let me what kind packages I need to have?
What Driver I need to have?
Sample code for creating connection and closing connection.

I am using SikuliX1.1.3.
Thanks in Advance.

Regards,
Nitin Chaudhari

Question information

Language:
English Edit question
Status:
Answered
For:
Sikuli Edit question
Assignee:
No assignee Edit question
Last query:
2019-11-01
Last reply:
2019-11-01
RaiMan (raimund-hocke) said : #1

the principle with (1.1.3 on Java 8)

load("zxJDBC.jar")
load("driver.jar") # the jar containing the driver
from com.ziclix.python.sql import zxJDBC
jdbc_url = 'jdbc:mysql://localhost:3306/BinckAutoTest'
username = 'root'
password = 'password'
MySQLDriver = 'com.mysql.jdbc.Driver' # this must be your oracle driver
urldb = zxJDBC.connect(jdbc_url, username, password, MySQLDriver)

with 1.1.3+ and Java 9+ you cannot use the load() to get the stuff on the Java classpath (for 2.0.0 this will be fixed asap).
In this case you have to use external Jython.

Look in the net for solutions (google sikuli jdbc)

Nitin Chaudhari (cnitin) said : #2

Thanks Raiman for information.
I will check and let you know.

Regards,
Nitin Chaudhari

Can you help with this problem?

Provide an answer of your own, or ask Nitin Chaudhari for more information if necessary.

To post a message you must log in.