Login | Register
My pages Projects Community openCollabNet

Discussions > users > MySQL

maxq
Discussion topic

Back to topic list

MySQL

Author hms_suprise
Full name john v hite
Date 2007-06-27 08:13:59 PDT
Message I want to make some MySQL queries from my test script. It looks like zxJDBC is available as the following lines execute OK but complain that the driver was not found. I picked up the driver name from the jython page http://www.jython.or​g/docs/zxjdbc.html. The driver name seems a bit unusual but other examples have multi-dotted names too. I also added mysql-connector-java-5.0.6-bin to maxq/lib and the CLASSPATH and tried their driver names to no avail.

Don't know much about jython per se but if you have any insight or ideas about accessing MySQL please sing out.

Thanx,

jh

~~~~~~~~~~~~~~~~~~~~​~~~~~~~~~~~~~~~~~~~~​~~~~~~~~~~~~~~~~~~~~​~~~~~~~

from com.ziclix.python.sql import zxJDBC
        d, u, p, v = "jdbc:mysql://localhost", 'admin', 'myPassword', "org.gjt.mm.mysql.Driver"
        db = zxJDBC.connect(d, u, p, v)
Attachments

« Previous message in topic | 4 of 12 | Next message in topic »

Messages

Show all messages in topic

Configuring logging Hans Schwaebli <hans_schwaebli at yahoo dot com> Hans Schwaebli <hans_schwaebli at yahoo dot com> 2007-05-19 16:45:41 PDT
     Fw: Configuring logging Hans Schwaebli <hans_schwaebli at yahoo dot com> Hans Schwaebli <hans_schwaebli at yahoo dot com> 2007-05-19 17:55:06 PDT
         Re: [maxq-users] Fw: Configuring logging oliverbock Oliver Bock 2007-05-19 19:25:38 PDT
             MySQL hms_suprise john v hite 2007-06-27 08:13:59 PDT
                 Re: [maxq-users] MySQL oliverbock Oliver Bock 2007-06-27 15:49:48 PDT
                     Re: [maxq-users] MySQL hms_suprise john v hite 2007-06-28 08:25:43 PDT
                     Re: [maxq-users] MySQL hms_suprise john v hite 2007-06-28 08:41:48 PDT
                         Re: [maxq-users] MySQL oliverbock Oliver Bock 2007-06-29 04:31:09 PDT
                             Re: [maxq-users] MySQL dadan <dadan8_2003 at yahoo dot com> dadan <dadan8_2003 at yahoo dot com> 2007-09-10 01:20:06 PDT
                                 Re: [maxq-users] MySQL oliverbock Oliver Bock 2007-09-12 14:51:12 PDT
                                     Re: [maxq-users] MySQL dadan <dadan8_2003 at yahoo dot com> dadan <dadan8_2003 at yahoo dot com> 2007-09-13 17:47:35 PDT
                                     Re: [maxq-users] MySQL dadan <dadan8_2003 at yahoo dot com> dadan <dadan8_2003 at yahoo dot com> 2007-09-13 17:48:06 PDT
Messages per page: