← Back to team overview

sikuli-driver team mailing list archive

[Bug 1274500] [NEW] [request] IDE: want to dynamically add something to Java classpath at runtime (e.g. JDBC driver)

 

Public bug reported:

**** workaround until solution is available in SikuliX

see related question

---------------------------------------------------------

In  the "Can I do X or Y or Z in Sikuli?" there is a bit about
connecting sikuli to a database.

Anyway, my goal is to make the following script run:

    from com.ziclix.python.sql import zxJDBC
    db = zxJDBC.connect("jdbc:mysql//localhost/core", "xxx", "xxx", "com.mysql.jdbc.Driver", CHARSET='iso_1')

I've copied the mysql-connector-java-3.1.14-bin.jar file into sikuli's
libs directory.

I've added an entry to the classpath in the runIDE.cmd script

I've tried adding the classpath entry inside my sikuli script

In all cases, I get:

[error] zxJDBC.DatabaseError ( driver [com.mysql.jdbc.Driver] not found
)

What do I need to do in order to make this work?

** Affects: sikuli
     Importance: High
     Assignee: RaiMan (raimund-hocke)
         Status: Fix Committed

** Changed in: sikuli
       Status: New => Fix Committed

** Changed in: sikuli
   Importance: Undecided => High

** Changed in: sikuli
     Assignee: (unassigned) => RaiMan (raimund-hocke)

** Changed in: sikuli
    Milestone: None => 1.1.0

** Description changed:

+ **** workaround until solution is available in SikuliX
+ 
+ see related question
+ 
+ ---------------------------------------------------------
+ 
  In  the "Can I do X or Y or Z in Sikuli?" there is a bit about
  connecting sikuli to a database.
  
  Anyway, my goal is to make the following script run:
  
-     from com.ziclix.python.sql import zxJDBC
-     db = zxJDBC.connect("jdbc:mysql//localhost/core", "xxx", "xxx", "com.mysql.jdbc.Driver", CHARSET='iso_1')
+     from com.ziclix.python.sql import zxJDBC
+     db = zxJDBC.connect("jdbc:mysql//localhost/core", "xxx", "xxx", "com.mysql.jdbc.Driver", CHARSET='iso_1')
  
  I've copied the mysql-connector-java-3.1.14-bin.jar file into sikuli's
  libs directory.
  
  I've added an entry to the classpath in the runIDE.cmd script
  
  I've tried adding the classpath entry inside my sikuli script
  
  In all cases, I get:
  
  [error] zxJDBC.DatabaseError ( driver [com.mysql.jdbc.Driver] not found
  )
  
  What do I need to do in order to make this work?

-- 
You received this bug notification because you are a member of Sikuli
Drivers, which is subscribed to Sikuli.
https://bugs.launchpad.net/bugs/1274500

Title:
  [request] IDE: want to dynamically add something to Java classpath at
  runtime (e.g. JDBC driver)

Status in Sikuli:
  Fix Committed

Bug description:
  **** workaround until solution is available in SikuliX

  see related question

  ---------------------------------------------------------

  In  the "Can I do X or Y or Z in Sikuli?" there is a bit about
  connecting sikuli to a database.

  Anyway, my goal is to make the following script run:

      from com.ziclix.python.sql import zxJDBC
      db = zxJDBC.connect("jdbc:mysql//localhost/core", "xxx", "xxx", "com.mysql.jdbc.Driver", CHARSET='iso_1')

  I've copied the mysql-connector-java-3.1.14-bin.jar file into sikuli's
  libs directory.

  I've added an entry to the classpath in the runIDE.cmd script

  I've tried adding the classpath entry inside my sikuli script

  In all cases, I get:

  [error] zxJDBC.DatabaseError ( driver [com.mysql.jdbc.Driver] not
  found )

  What do I need to do in order to make this work?

To manage notifications about this bug go to:
https://bugs.launchpad.net/sikuli/+bug/1274500/+subscriptions


Follow ups

References