Newbie: How doy I connect to Oracle Using JDBC

[Fernando Caceres]

The next code tells me that ->
" Invalid Oracle URL specified: OracleDriver.connect"
import java.sql.*;
What is wrong???
Please help!!!

public class Cafe {
    public static void main(String args[]) {
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:oci8@1.2.3.4:1521:O RCL","user","pass");
Statement sta = con.createStatement();
ResultSet rs = sta.executeQuery("select 'hola' from dual;");
} catch(java.lang.ClassNotFoundException e) {
            System.err.print("Class not Found: ");
            System.err.println(e.getMessage());
}

catch (SQLException ex) {
System.err.println("Query Error: " + ex.getMessage());
}
    }
}

[ Edited by Dave to remove smilies and format code ]
[ December 02, 2002: Message edited by: David O'Meara ]

[David O'Meara]

"TGO",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp.
We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please edit your profile and select a new name which meets the requirements.
Thanks.
Dave

[Michael Zalewski]

Third post I found today that has the same problem. (One DB2, One mySQL, now one Oracle).
Doesn't look like you are registering the driver. Only loading the class. Try

  Connection con = null;
  try {
    DriverManager.registerDriver(
       new oracle.jdbc.driver.OracleDriver()
    );
    con = DriverManager.getConnection(
        "jdbc:oracle:oci8@1.2.3.4:1521:ORCL","user","pass"
    );
     
    ...
     

The above code works if you import oracle.jdbc.driver.*. If you just put classes12.zip or classes2.zip onto the class path, you will need to do Class.forName().newInstance() and cast that to a Driver.
If you don't register the driver, there is no point in creating an instance of the object.
Also, you might want to declare your Connection variable outside of the try block. So if you catch an error, you will be able to close the connection cleanly in the catch block.
[ December 02, 2002: Message edited by: Michael Zalewski ]
[ December 02, 2002: Message edited by: Michael Zalewski ]

[Fernando Caceres]

Thanks for the help but now tells me 'ORA-06401: NETCMN: invalid driver designator'
what is wrong?

[Michael Zalewski]

OCI is not installed on your webserver. Or it's not properly installed.
Try using the thin client first

   ...
    
   con = DriverManager.getConnection(
        "jdbc :-o	 racle:thin@1.2.3.4:1521 :-o	 RCL","user","pass"    );
    
   ...

[Fernando Caceres]

Thanks It Works

[Fernando Caceres]

It's working, but this was a connection to a Oracle DB that wasn't (SERVER=DEDICATED) in my TNSNAMES.ORA . NOW I want to connect to a Oracle DB with (SERVER=DEDICATED) but throws this message 'Io exception: The Network Adapter could not establish the connection' , always using JDBC and applets

[Fernando Caceres]

I found it:
String url1 = "jdbc racle:thin:@(DESCRIPTION = " +
" (ADDRESS_LIST =" +
" (ADDRESS = (PROTOCOL = TCP)(HOST = 1.2.3.4)(PORT = 1521)))" +
" (CONNECT_DATA = " +
" (SID = ORCL) " +
" (SERVER = DEDICATED) ))";

Connection conn =
DriverManager.getConnection (url1, "uid", "pwd");
.....
This works...