# test access on database
from com.ziclix.python.sql import zxJDBC

database="jdbc:postgresql://dios/standarddb"
user="amarok"
password="amarok"
driver="org.postgresql.Driver"

db = zxJDBC.connect(database, user, password, driver)

curs = db.cursor()

curs.execute("select count(*) from album")

curs.description

for a in curs.fetchall():
    print a

curs.close()
db.close()