From: Mike H. <mh...@gm...> - 2008-12-08 02:17:55
|
Hello, I am trying to use a database with my program and I thought I would follow one example I found on the net: from com.ziclix.python.sql import zxJDBC db = zxJDBC.connect("jdbc:postgresql://localhost/racing/", "bzimmer", None, "org.postgresql.Driver") c = db.cursor() c.execute("select * from bz") for row in c: print row c.close() db.close() It results in error: Traceback (innermost last): File "jzJDBC.py", line 3, in ? DatabaseError: driver [org.postgresql.Driver] not found Do I have to install some additional software to make this work? I googled it and one answer was to use the --verify option. And that just spit: $ jython --verify jzJDBC.py jython: illegal option -- verify Any help or suggestions appreciated. Thanks, |
From: Mike H. <mh...@gm...> - 2008-12-08 02:22:10
|
Also tried: $ jython jzJDBC.py --verify Traceback (innermost last): File "jzJDBC.py", line 3, in ? DatabaseError: driver [org.postgresql.Driver] not found On Sun, Dec 7, 2008 at 7:17 PM, Mike Hoy <mh...@gm...> wrote: > Hello, > > I am trying to use a database with my program and I thought I would > follow one example I found on the net: > > from com.ziclix.python.sql import zxJDBC > > db = zxJDBC.connect("jdbc:postgresql://localhost/racing/", "bzimmer", > None, "org.postgresql.Driver") > c = db.cursor() > c.execute("select * from bz") > for row in c: > print row > c.close() > db.close() > > It results in error: > > Traceback (innermost last): > File "jzJDBC.py", line 3, in ? > DatabaseError: driver [org.postgresql.Driver] not found > > Do I have to install some additional software to make this work? I > googled it and one answer was to use the --verify option. And that > just spit: > > $ jython --verify jzJDBC.py > jython: illegal option -- verify > > Any help or suggestions appreciated. > > Thanks, > -- Mike Hoy |
From: Leo S. M. <leo...@gm...> - 2008-12-08 02:32:31
|
On Sun, Dec 7, 2008 at 11:17 PM, Mike Hoy <mh...@gm...> wrote: > Hello, > > I am trying to use a database with my program and I thought I would > follow one example I found on the net[...] Are you using Jython2.2, right? Are you setting your classpath correctly (As in ensuring that the PostgreSQL JDBC driver is included on it)? You can always check that by doing the following in the jython interpreter: >>> from java.lang import System >>> print System.getProperty("java.class.path") -- Leo Soto M. http://blog.leosoto.com |