From: Lee H. <le...@hu...> - 2012-04-09 21:45:05
|
Sorry for the noob question. Testing Jython 2.5.2 on OpenJDK 1.7 with PostgreSQL 9.1.2 and PostgreSQL JDBC4 driver, getting ImportError when I select a recordset containing a timestamp field. I did search the archives from the last year and googled but the only matches I found indicate this was fixed long ago. >>> from com.ziclix.python.sql import zxJDBC >>> d, u, p, v = "jdbc:postgresql:mydatabase",'myuser', 'mypassword', "org.postgresql.Driver" >>> db = zxJDBC.connect(d, u, p, v) >>> c = db.cursor() >>> c.execute('select mytimestamp from mytable') Traceback (most recent call last): File "<stdin>", line 1, in <module> ImportError: No module named datetime >>> Thanks much for any help or ideas. -- Lee |
From: Chris C. <Chr...@ac...> - 2012-04-09 21:57:51
|
On Monday 2012-04-09 14:51 (-0700), Lee Hughes <le...@hu...> wrote: > Sorry for the noob question. Testing Jython 2.5.2 on OpenJDK 1.7 with > PostgreSQL 9.1.2 and PostgreSQL JDBC4 driver, getting ImportError when > I select a recordset containing a timestamp field. I did search the > archives from the last year and googled but the only matches I found > indicate this was fixed long ago. > > >>> from com.ziclix.python.sql import zxJDBC > >>> d, u, p, v = "jdbc:postgresql:mydatabase",'myuser', 'mypassword', > "org.postgresql.Driver" > >>> db = zxJDBC.connect(d, u, p, v) > >>> c = db.cursor() > >>> c.execute('select mytimestamp from mytable') > Traceback (most recent call last): > File "<stdin>", line 1, in <module> > ImportError: No module named datetime > >>> > > Thanks much for any help or ideas. > Quick check list: 1. Are you sure it is 2.5 and not 2.2? 2. What happens if you import datetime manually/explicitly? Either standalone or before the jdbc import. 3. Have you tried testing the 2.5.3 RC? 4. Have you tried http://code.google.com/p/jyjdbc/ instead of zxJDBC? 5. This is an odd suggestion I'll admit; have you tried the Sun/Oracle JDK? It shouldn't make any difference but if you have one floating around to test with it is worth trying. Chris |
From: Lee H. <le...@hu...> - 2012-04-10 01:58:19
|
> > Quick check list: > > 1. Are you sure it is 2.5 and not 2.2? > # jython Jython 2.5.2 (Release_2_5_2:7206, Mar 2 2011, 23:12:06) [OpenJDK 64-Bit Server VM (Sun Microsystems Inc.)] on java1.6.0_23 Type "help", "copyright", "credits" or "license" for more information. >>> > 2. What happens if you import datetime manually/explicitly? Either > standalone or before the jdbc import. > Hmm now it works fine, I'm guessing because I reinstalled Jython with the Standard option instead of the Core option in order to pick up the distutils that jyjdbc setup required. > > 4. Have you tried http://code.google.com/p/**jyjdbc/<http://code.google.com/p/jyjdbc/>instead of zxJDBC? > Wow, nice package, works perfectly. I'll be testing it with Postgres/MySQL/Oracle/SQL Server/DB2 and hopefully Netezza. Thanks very much for your help! -- Lee |