Message3849

Author mju
Recipients mju
Date 2008-11-26.10:20:49
SpamBayes Score 0.00024448344
Marked as misclassified No
Message-id <1227694850.16.0.424735077223.issue1184@psf.upfronthosting.co.za>
In-reply-to
Content
After compiling with "jythonc --jar check.jar --all --core --compiler
"C:\Program Files\Java\jdk1.6.0_10\bin\javac.exe" checkDB.py" the
compilation shows no error.
The execution ""C:\Program Files\Java\jdk1.6.0_10\bin\java" -jar
check.jar HOST jdbc:oracle:thin:@10.230.33.21:1521:devdb01 USER PASSWD"
runs into the following error:
Exception in thread "main" Traceback (innermost last):
  File "D:\checkDB.py", line 0, in main
ImportError: cannot import name zxJDBC
I have the same Problems on Windows and on Linux.
The code of checkDB.py:
-----------------------
#/usr/bin/env jython
# -*- coding: utf-8 -*-

from com.ziclix.python.sql import zxJDBC
import sys
import string

argsDB = string.upper(sys.argv[1])
argsurl = sys.argv[2]
argsuser = sys.argv[3]
argspwd = sys.argv[4]

READoracleConn = zxJDBC.connect(argsurl, argsuser, argspwd,
"oracle.jdbc.driver.OracleDriver")
READoracleCursor = READoracleConn.cursor()
READoracleCursor.arraysize = 50

READoracleCursor.execute("""SELECT 1 FROM dual""")
results = READoracleCursor.fetchall()
for line in results:
      ofd=str(line[0])
      print ofd

# Disconnect von Instance...
close=READoracleConn.close()
History
Date User Action Args
2008-11-26 10:20:50mjusetrecipients: + mju
2008-11-26 10:20:50mjusetmessageid: <1227694850.16.0.424735077223.issue1184@psf.upfronthosting.co.za>
2008-11-26 10:20:50mjulinkissue1184 messages
2008-11-26 10:20:49mjucreate