473,241 Members | 1,671 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,241 software developers and data experts.

MySQL - Jython2.2

I thought I had a winner mySql-python but it require2 python 2.3-5 and
the tool I am using (maxq) is based on jython 2.2. Is there another
way that I could perform queries from python?
thanx,

jh

Jun 15 '07 #1
4 1079
On 15 Jun, 16:31, HMS Surprise <j...@datavoiceint.comwrote:
I thought I had a winner mySql-python but it require2 python 2.3-5 and
the tool I am using (maxq) is based on jython 2.2. Is there another
way that I could perform queries from python?
For Jython you should use the JDBC driver for the database system in
question (MySQL Connector/J in this case, I believe [1]), either
writing code which uses the JDBC API directly, or using the zxJDBC
module for DB-API compatibility (such as that provided by most other
Python database modules). See here for details:

http://www.jython.org/docs/zxjdbc.html

Paul

[1] http://www.mysql.com/products/connector/j/

Jun 15 '07 #2
On Fri, 2007-06-15 at 07:31 -0700, HMS Surprise wrote:
I thought I had a winner mySql-python but it require2 python 2.3-5 and
the tool I am using (maxq) is based on jython 2.2. Is there another
way that I could perform queries from python?
The low version number is not your main problem. The main problem is
that Jython is based on Java, and it can not use CPython modules such as
MySQL-python. You'll need JDBC:

http://dev.mysql.com/downloads/connector/j/5.0.html
http://www.jython.org/docs/zxjdbc.html

I have not tried this combination myself, so your mileage may vary, but
in theory this should work.

Good luck,

--
Carsten Haese
http://informixdb.sourceforge.net
Jun 15 '07 #3
Ant
On Jun 15, 3:31 pm, HMS Surprise <j...@datavoiceint.comwrote:
I thought I had a winner mySql-python but it require2 python 2.3-5 and
the tool I am using (maxq) is based on jython 2.2. Is there another
way that I could perform queries from python?
If you want to query via Jython, use the jdbc driver from www.mysql.com,
and you an then use JDBC from within Jython. You'll just need to add
the mysql jdbc jar to your classpath.

HTH.

--
Ant...

http://antroy.blogspot.com/


Jun 15 '07 #4
Thanks, everyone.

I will give it a try. Don't know a lot about mySQL (or any flavor SQL)
but from some minute exposure to the ODBC connector I am guessing that
jdbc provides a connector.

Wish me luck....

jh

Jun 15 '07 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: francescomoi | last post by:
Hi. I'm trying to build 'MySQL-python-1.2.0' on my Linux FC2: ---------------------------------- # export PATH=$PATH:/usr/local/mysql/bin/ # export mysqlclient=mysqlclient_r # python setup.py...
0
by: Randell D. | last post by:
Folks, I have installed MySQL v4 (client, server and development rpm's). I've tried and failed to use the recommended mysqladmin to set a root password after the installation (I have another post...
0
by: Donald Tyler | last post by:
Then the only way you can do it that I can think of is to write a PHP script to do basically what PHPMyAdmin is trying to do but without the LOCAL in there. However to do that you would need to...
4
by: mikey | last post by:
Hi all, I'm having great problems trying to install the latest MySQl RPM package onto my Red Hat Linux OS. There is already MySQL v 3.0 pre-installed with the RH Linux distribution disk but I...
0
by: Yun Guan | last post by:
Hello mysql gurus, I am trying to run perl on mysql database on Red Hat box. I want to install DBI and DBD:mysql using CPAN: perl -MCPAN -e shell cpan>install DBI The above succeeded, but...
0
by: Mike Chirico | last post by:
Interesting Things to Know about MySQL Mike Chirico (mchirico@users.sourceforge.net) Copyright (GPU Free Documentation License) 2004 Last Updated: Mon Jun 7 10:37:28 EDT 2004 The latest...
2
by: trihanhcie | last post by:
I m currently working on a Unix server with a fedora 3 as an os My current version of mysql is 3.23.58. I'd like to upgrade the version to 5.0.18. After downloading from MYSQL.COM the package on...
1
by: manish deshpande | last post by:
Hi, When i'm installing MySQL-server-standard-5.0.24a-0.rhel3.i386.rpm by the following command: rpm -i MySQL-server-standard-5.0.24a-0.rhel3.i386.rpm the following error is being shown: ...
3
by: menzies | last post by:
Hi, I"m new to this forum, but I have been trying all day to install DBD::mysql onto my Intel MacBook. I've read lots of forums pages and none have gotten me to a successful 'make test' or a...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.