← Back to team overview

sikuli-driver team mailing list archive

[Question #242920]: Issue when accessing to MySQL database

 

New question #242920 on Sikuli:
https://answers.launchpad.net/sikuli/+question/242920

Hi all,

I'm using the last version of sikuli on Windows 7 with jre7.
I downloaded the last java mysql connector (5.1.28) and added a env variable :
CLASSPATH = C:\Program Files (x86)\MySQL\MySQL Connector J\mysql-connector-java-5.1.28-bin.jar

I'm so launching a sikuli script (no IDE) with basically :

from sikuli import *
from com.ziclix.python.sql import zxJDBC

j = 'jdbc:mysql://localhost:3306/BinckAutoTest'
u = 'root'
p = 'mypassword'
m = 'com.mysql.jdbc.Driver'

try:
  con = zxJDBC.connect(j, u, p, m)
except Exception, e:
  print "database connection issue : ", e

And I'm getting :
database connection issue :  driver [com.mysql.jdbc.Driver] not found


Looking at another post (question 202408) I saw that RaiMan proposed a bat script like :

set cp=C:\Program Files (x86)\MySQL\MySQL Connector J\mysql-connector-java-5.1.28-bin.jar
set cp=%cp%:C:\tmp\jython.jar
java -cp %cp% org.python.util.jython %1.sikuli\%1.py

When I run this bat script I get :
Error: Could not find or load main class Files

Where Am I wrong ?

Thanks a lot,
Rod



-- 
You received this question notification because you are a member of
Sikuli Drivers, which is an answer contact for Sikuli.