Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> JDBC and Oracle connection
Hi.
I am not an Oracle expert, but am currently playing a bit with Java and JDBC against Oracle. I have downloaded the new JDBC drivers from Oracle, and am trying to connect to it. Oracle is at 7.3.something.
Connecting to the Oracle with sqlplus is usually done with: sqlplus user/pass_at_t:host:DB
I then try to use the the JDBC/OCI drivers from Oracle, and I am a bit puzzeled as to what connection string I am supposed to use. Anything seems to fail...
I have tried variations of
Connection conn = DriverManager.getConnection (
"jdbc:oracle:oci7_at_t:host:DB", user, password);
and
Connection conn = DriverManager.getConnection (
"jdbc:oracle:oci7_at_host:DB", user, password);
but none of them seems to work. I get an oracle error java.sql.SQLException: ORA-06401: NETCMN: invalid driver designator
I do initialize the drivers, my example is straight from the JdbcCheckup.java example.
I am probably just ignorant here, but would be thankful for any help.
-- ----------------------------------+-------------------------------------Received on Fri Nov 07 1997 - 00:00:00 CST
- Terje A. Bergesen | The UNIX Guru's View of Sex: -
----------------------------------+ -
- Say NO to inferior technology. | # unzip ; strip ; touch ; finger ; -
- Say NO to MS Internet Explorer. | mount ; fsck ; more ; yes ; -
- Say NO to MS Visual J++ | umount; sleep -
![]() |
![]() |