Database

Links

The zxJDBC package provides a nearly 100% Python DB API 2.0 compliant interface for database connectivity in jython.

Sample

HSQL

sample-jython-hsql.py A simple sample using an embedded HSQL database.
- Also see the sample from Apache Commons - Database Connection Pools, Commons - DBCP - Database Connection Pools.
- and the Maven HSQL dependency, ../hsql/maven.

MySQL (jython 2.1)

Using jython 2.1 and mysql-connector-java-5.0.6-bin.jar:

from com.ziclix.python.sql import zxJDBC
d, u, p, v = 'jdbc:mysql://server/db_name', 'user', 'password', 'com.mysql.jdbc.Driver'
db = zxJDBC.connect(d, u, p, v)
# optionally
#>>> db = zxJDBC.connect(d, u, p, v, CHARSET='iso_1')

c = db.cursor()
sql = "select * from users"
c.execute(sql)
results = c.fetchall()
for line in results:
    print line
c.close()

SQL Server

db-sql-server.py

Access

db-access.py

from com.ziclix.python.sql import zxJDBC

connect = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=/temp/csobjects-test-database/testadmin.mdb"
driver = "sun.jdbc.odbc.JdbcOdbcDriver"

try:
    db = zxJDBC.connect(connect, None, None, driver)
    c = db.cursor()
    sql = "select * from article"
    c.execute(sql)
    results = c.fetchall()
    for line in results:
        print line
finally:
    print 'Close connection...'
    c.close()

Exception

from com.ziclix.python.sql import zxJDBC

    try:
        Runner().do()
    except zxJDBC.DatabaseError, e:
        print 'Exception:'
        print e
        print
        print r"Don't forget to add the jTDS, Microsoft SQL Server driver to the CLASSPATH:"
        print r'SET CLASSPATH=C:\Users\Patrick\.m2\repository\net\sourceforge\jtds\jtds\1.2\jtds-1.2.jar'