thanks for the replaybut yesterday i tried to reinstall jython 2.2and wrote the classpath of jython 2.2 and put the JDBC driver which is : mysql-connector-java​-5.0.7-bin.jarin folder C:\Program Files\Java\jre1.6.0_01\lib\extand then i executed the command :from com.ziclix.python.sql import zxJDBCand weew...it succeedand then i tried to reconnect it to MYSQLand it succeed to!!maybe it's my luck..because i tried that path before and i failed!!!but now it happen as my wish!

regardsdadan

Oliver Bock wrote:> > On 10/09/2007, at 18:20, dadan wrote:>> i just want to ask....i done several action to execute this command >> in jython>> command line:>>>>> from com.ziclix.python.sql import zxJDBC>> but the result is like this :>> http://www.nabble.co​m/file/p12588625/err​or%2Bziclix.jpg>>>> java.lang.NoclassdefFoundError : org/python/core/ClassDictInit>> you can see full error in image above..>> i also download mysql-connector-java​-5.0.7-bin.jar. but don't know >> to put in>> in CLASSPATH.>> please tell me how to import zxJDBC.>> thanks>>> > Put the JAR in MaxQ's lib directory. If you are on Windows you will > need to edit the CLASSPATH line in maxq.bat to include the full path > to the new JAR.> > > Oliver> > --------------------​--------------------​--------------------​---------> To unsubscribe, e-mail: users-unsubscribe@ma​xq.tigris.org> For additional commands, e-mail: users-help at maxq dot tigris dot org> > >

thanks for the replaybut yesterday i tried to reinstall jython 2.2and wrote the classpath of jython 2.2 and put the JDBC driver which is : mysql-connector-java​-5.0.7-bin.jarin folder C:\Program Files\Java\jre1.6.0_01\lib\extand then i executed the command :from com.ziclix.python.sql import zxJDBCand weew...it succeedand then i tried to reconnect it to MYSQLand it succeed to!!maybe it's my luck..because i tried that path before and i failed!!!but now it happen as my wish!

regardsdadan

Oliver Bock wrote:> > On 10/09/2007, at 18:20, dadan wrote:>> i just want to ask....i done several action to execute this command >> in jython>> command line:>>>>> from com.ziclix.python.sql import zxJDBC>> but the result is like this :>> http://www.nabble.co​m/file/p12588625/err​or%2Bziclix.jpg>>>> java.lang.NoclassdefFoundError : org/python/core/ClassDictInit>> you can see full error in image above..>> i also download mysql-connector-java​-5.0.7-bin.jar. but don't know >> to put in>> in CLASSPATH.>> please tell me how to import zxJDBC.>> thanks>>> > Put the JAR in MaxQ's lib directory. If you are on Windows you will > need to edit the CLASSPATH line in maxq.bat to include the full path > to the new JAR.> > > Oliver> > --------------------​--------------------​--------------------​---------> To unsubscribe, e-mail: users-unsubscribe@ma​xq.tigris.org> For additional commands, e-mail: users-help at maxq dot tigris dot org> > >

On 10/09/2007, at 18:20, dadan wrote:> i just want to ask....i done several action to execute this command > in jython> command line:>>>> from com.ziclix.python.sql import zxJDBC> but the result is like this :> http://www.nabble.co​m/file/p12588625/err​or%2Bziclix.jpg>> java.lang.NoclassdefFoundError : org/python/core/ClassDictInit> you can see full error in image above..> i also download mysql-connector-java​-5.0.7-bin.jar. but don't know > to put in> in CLASSPATH.> please tell me how to import zxJDBC.> thanks>

Put the JAR in MaxQ's lib directory. If you are on Windows you will need to edit the CLASSPATH line in maxq.bat to include the full path to the new JAR.

java.lang.NoclassdefFoundError : org/python/core/ClassDictInityou can see full error in image above..i also download mysql-connector-java​-5.0.7-bin.jar. but don't know to put inin CLASSPATH.please tell me how to import zxJDBC.thanks

Oliver Bock wrote:> > Fixed. Much obliged.> > > On 29/06/2007, at 01:41, jh wrote:> >> Just a nit as I think either will work but I think the driver name >> is now>> "com.mysql.jdbc.Driver">>>> instead of>>>> "org.gjt.mm.mysql.Dr​iver".Regards,jh> > --------------------​--------------------​--------------------​---------> To unsubscribe, e-mail: users-unsubscribe@ma​xq.tigris.org> For additional commands, e-mail: users-help at maxq dot tigris dot org> > >

Dang, what an idiot I am, I have seen that before too. But no, I forgot about that, probably because when I saw it I knew nothing of any flavor of SQL. Did it slightly differently, after adding mysql-connector-java​-5.0.6-bin.jar to the jar lib. But the snippet below works.

jh wrote:> 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.

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.