Mysql database connection with Jython

Question

Hello i'm trying to get a mysql database connection with jython. I'm using Python 3.3.2 and Jython 2.5.3

My code looks like this:

import sys
from java.sql import *
sys.path.append("C:\\dev\\git\\LogAnalysis\\mysql-connector-java-5.0.8.jar")
con = DriveManager.getConnection("jdbc:mysql://localhost:3306/statistik", "root", "admin")
stmt = con.createStatement()
rs = stmt.executeQuery("SELECT * FROM search")

and so on. (Only a code snippet)

Each time i get the exeption:

java.sql.SQLException: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/statistik

Can someone give me a tip?

Are you sure JDBC driver is in c:\dev\git\...? Also try to add code: from java.lang import Class; Class.forName("com.mysql.jdbc.Driver") — Michał Niklas
– Michał Niklas, Commented Sep 26, 2013 at 8:47

Community · Accepted Answer · 2017-05-23 12:05:14Z

4

See solution at: Jython CLASSPATH, sys.path and JDBC drivers

For me the easiest solution is to provide batch/shell script which sets CLASSPATH. This looks like:

SET CLASSPATH=C:\dev\git\LogAnalysis\mysql-connector-java-5.0.8.jar;%CLASSPATH%
CALL jython your_program.py %1 ...

Then you can remove line with:

sys.path.append(...)

edited May 23, 2017 at 12:05

CommunityBot

11 silver badge

answered Sep 26, 2013 at 8:56

Michał Niklas

54.5k19 gold badges76 silver badges125 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mysql database connection with Jython

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related