Re: [Jython-users] Database Connectivity Problem - Jython

[Alex G. <ale...@ne...>]

  15.10.2010 10:07, rag007 kirjoitti:
> Hi All,
>
> I have some doubts in database connectivity using jython. First of all, I am
> using oracle database. My connectivity jar is ojdbc-10.2.0.4.jar.
>
> I tried so many ways, I will explain in detail.
>
> Jython Path = D:\jython2.5.1
>
> Jdk Path   = C:\Program Files\Java\jdk1.5.0_07\bin
>
> My project file path : C:\Jython\testfile.py
>
> from oracle.jdbc.driver import OracleDriver
> from java.sql import DriverManager
> driver = OracleDriver()
> print driver
> DriverManager.registerDriver(driver)
> Class.forName("oracle.jdbc.driver.")
> conn =
> DriverManager.getConnection("jdbc:oracle:thin:@10.105.146.13:1521:orcl",
> "testdb", "testdb")
>
> In Environment Variables, I set Jython Path and Jdk Path (Path = C:\Program
> Files\Java\jdk1.5.0_07\bin; D:\jython2.5.1;)
>
> Method 1
> =========
> I put ojdbc-10.2.0.4.jar in the C:\Program Files\Java\jdk1.5.0_07\lib
>
> In Environment Variables, I set that path
>
> Method 2
> =========
> I put ojdbc-10.2.0.4.jar in the D:\oracle odbc
>
> In Environment Variables, I set that path..
>
> Method 3
> ========
> I put ojdbc-10.2.0.4.jar in the D:\jython2.5.1
>
> If I am executing the code testfile.py in the command prompt like
>
> C:\jython:>  jython testfile.py
>
> I got this error
>
> Traceback (most recent call last):
>    File "testfile.py", line 2, in<module>
>      from oracle.jdbc.driver import OracleDriver
> ImportError: No module named oracle
>
> Please do needful help....
>
All of your methods were wrong. None of them will put that jar into the 
class path.
You will either have to put the jar into your JRE's lib\ext directory, 
or add the path to the jar (and not its containing directory) to the 
CLASSPATH environment variable, or append it to sys.path programmatically.
> Regards
> Rakesh