Connecting Java with Oracle

[besian hoxha]

Hi,

I'm trying to connect with Oracle but there are some problem..
Can anyone help me please?

There is the code:

private Connection getOracleConnection() throws SQLException {
    Connection connection = null;
    try{
        String url = "jdbc:odbc:connectOracle";
        Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
        connection = DriverManager.getConnection(url,"ubt","shkparadite");
        connection.setAutoCommit(false);
        Statement stmt = connection.createStatement();
        System.out.println("Lidhja me databazen Oracle  krijua ...");
					
        ResultSet rs = stmt.executeQuery("select* from FILIALET ");
        rs.next();
        System.out.println ("________________________");
        System.out.println ("Leximi i Tables FILIALET: " );
        System.out.println ("|-" + rs.getString(1));
        System.out.println ("|-" + rs.getString(2));
        System.out.println ("|-" + rs.getString(3));
        System.out.println ("|-" + rs.getString(4));
        stmt.close();	
		
        connection.setAutoCommit(false);
					
        System.out.println (connection.toString());
    }
    catch(Exception e){
        e.printStackTrace();
    }
    return connection;
		
}

PROBLEM:



ConnectOracle@130c19b databaseoracle
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at ConnectOracle.getOracleConnection(ConnectOracle.java:83)
at ConnectOracle.getConnection(ConnectOracle.java:46)
at ConnectOracle.getModeli(ConnectOracle.java:125)
at ConnectOracle.main(ConnectOracle.java:205)
java.lang.NullPointerException
at ConnectOracle.getModeli(ConnectOracle.java:126)
at ConnectOracle.main(ConnectOracle.java:205)


[Added code tags - see UseCodeTags for details]

[Nicola Garofalo]

Did you get the jar file containing the oracle connection driver and put it in your classpath?
It seems you didn't.

[Campbell Ritchie]

I think this thread would sit better in the databases forum (connections probably fit better there than in the Oracle forum). Moving discussion.

[William P O'Sullivan]

Nicola is correct.

Class.forName() will look in the $CLASSPATH/%CLASSPATH% of the application server at run-time.

Either include the oracle supplied jar in your web-inf/lib or install in the appservers shared lib folders.

WP

[Martin Vashko]

If needed, you can find links to Oracle JDBC drivers, as well as other useful Oracle related advice, in our Oracle FAQ page.