Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Jython JDBC connect as sysdba

648427Apr 25 2009 — edited Apr 28 2009
how to connect to oracle as sysdba via jython?
below is the code
please help

from com.ziclix.python.sql import zxJDBC
import java.lang as lang
import java.util.Properties

Properties props=new Properties()
props.put("user","sys")
props.put("password","sys")
props.put("internal_logon","sysdba")

db =zxJDBC.connect('jdbc:oracle:thin:@10.106.253.71:1521:dwdb',props,'oracle.jdbc.driver.OracleDriver')
print 'connection ok'

Result:
----------
Traceback (innermost last):
(no code object) at line 0
File "post.py", line 5
Properties props=new Properties()
^
SyntaxError: invalid syntax

Thanks
Sakthivel K
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 26 2009
Added on Apr 25 2009
14 comments
6,736 views