cannot connect to oracle DB

[freddy000]

I'm trying to connect to an oracle data base from my netbean's application ,
I've already added the jdbc to the library
I've wrote the appropriate code but it's not working
here's the code

package connection;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.*;
public class connection {
                public static void main(String[] args) throws SQLException{
		try{
			Class.forName("oracle.jdbc.OracleDriver");

	              	System.out.println("Chargement du driver jdbc ds la JVM réussie");
	
          	        Connection con = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:GLOBAL","SYSTEM", "manager");
	
        		System.out.println("Connexion réussite");
		
                 	Statement stmtCode = con.createStatement();
           
                        ResultSet rs = stmtCode.executeQuery("select note1,note2 from T2");

			while(rs.next())
                      
                        System.out.println(rs.getFloat(1) + "  " +    rs.getFloat(2));
      
                        rs.close();
			}
                        catch(Exception e)
	{
				e.printStackTrace();
			}
	}
}

and here's the output message

run:
Chargement du driver jdbc ds la JVM réussie
java.lang.ArrayIndexOutOfBoundsException: 4
        at oracle.jdbc.driver.T4C8TTIdty.<init>(T4C8TTIdty.java:479)
        at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1113)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:308)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:185)
        at connection.connection.main(connection.java:12)
BUILD SUCCESSFUL (total time: 3 seconds)

Any help would be appreciated, thanks.

[mine0926]

try

Class.forName("oracle.jdbc.driver.OracleDriver");

instead of

    Class.forName("oracle.jdbc.OracleDriver");

[freddy000]

hi mine
thank you for answering ,
I've added "driver" in class.forname like you mentioned and it's still generating the SAME output message , no changes

[mine0926]

Seem that the error you are getting is about drivers or/and library.

Where did you get the library that you add?

I am not sure with this, I have'nt try to install oracle before but just want to ask:
Are you sure that the port 1521 is the port that you enter when you install oracle thin?

[Tolls]

What version of Oracle do you have?
What version of the driver are you using?
What version of Java are you using?

[freddy000]

hi
I was using oracle 8.1.7 , and I've downloaded ojdbc5.jar from the oracle official site ,

Yes I'm sure of the port 1521 this is the default one , and i've created my table after being connected with the system account

ok, which is really strange that I've installed oracle 10 express after, added to my library's application a jdbc that I've found in that oracle 10 directory
now it works !!!

so does the oracle 8.1.7 version having problem's connection ?
thanks

[Tolls]

Yes.
Oracle 8i is no longer supported, and hasn't been for a while, so I wouldn't be surprised to find that a JDBC driver designed for Oracle 10 doesn't work with it.

If you need to use Oracle 8i then you'll want to get hold of the classes12 zip.

[freddy000]

hi Tolls
thank you for your answer , I downloaded classes12.zip and I didn't understand what to do with the classes within :)
I'm used to .jars files so I prefer to continue manipulating oracle 10, the connection succeeded simply :)


thanks

[Tolls]

Don't unzip it.
It is a jar file...it's just called a zip for some unknown reason.
Use it like any other jar file.

[freddy000]

hi

Don't unzip it.
It is a jar file...it's just called a zip for some unknown reason.

may it was that my fault , i was expecting to find a .jar file , and it was a zip one ,
I'll add it like it is to my library's application ,
thanks