Hi all,
i m trying to make connection through OCI Driver provided by oracle.
The downloaded file is "jdbc816jdk12-sol_20.zip" for Solaris platform and is
JDBC 2.0 compliant.
I extracted the file and set the appropriate CLASSPATH
I m making simple connection in 2 ways but getting different exception in both
cases
The code goes here.....
Case 1: ..............................
Driver myDriver = (Driver)Class.forName
("oracle.jdbc.driver.OracleDriver").newInstance();
Properties props = new Properties();
props.put("user", "test");
props.put("password", "test");
props.put("server", "SURYA");
Conncetion conn = myDriver.connect("jdbc:oracle:oci8",
props);
Exception thrown:
Exp:: java.sql.SQLException: Invalid Oracle URL specified
Case 2: DriverManager.registerDriver(new
oracle.jdbc.driver.OracleDriver());
Connection conn =
DriverManager.getConnection("jdbc:oracle:oci8:@SURYA","test", "test");
Exception thrown:
Exp:: java.sql.SQLException: ORA-01031: insufficient
privileges
Thu Aug 02 16:21:32 EST 2001:<E> <ListenThread> Listen
failed, failure count: '1'
java.net.SocketException: Interrupted system call
at java .net.PlainSocketImpl.socketAccept(Native Method)
at java.net.PlainSocketImpl.socketAccept(Compiled Code)
at java.net.PlainSocketImpl.accept(Compiled Code)
at java.net.ServerSocket.implAccept(Compiled Code)
at java.net.ServerSocket.accept(Compiled Code)
at weblogic.t3.srvr.ListenThread.run(Compiled Code)
Where SURYA is service name set in tnsnames.ora
Plz. anybody can tell me where m i wrong ??? I hope everything i hav setted is
right, as i tested with the user/pwd and service name and it is fine. But some
how not able to make up with OCI driver. I tried the similar with other oci
drivers provided by vendors like BEA, there it worked fine, but didnt happened
with driver provided by Oracle.
Kindly anybody can suggest me some freely available OCI driver for Oracle
database which is JDBC 2.0 compliant.
regards,
Abhishek !
Satyam Infoway Ltd
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
