Dear,
I am this problem to connect oracle database in JAVA. I am using Eclipse Mars, below is my code:
package db;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class ConnectionFactory {
public static Connection getConnection() {
try {
Class.forName("oracle.jdbc.OracleDriver");
return DriverManager.getConnection("jdbc:oracle:thin:@myhost:1521:orcl", "scott", "tiger");
} catch (ClassNotFoundException | SQLException e) {
throw new RuntimeException(e);
}
}
public static void main(String[] args) {
Connection connection = ConnectionFactory.getConnection();
System.out.println("Conexão criada com sucesso.");
try {
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
Belown the error:
Exception in thread "main" java.lang.RuntimeException: java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
at db.ConnectionFactory.getConnection(ConnectionFactory.java:14)
at db.ConnectionFactory.main(ConnectionFactory.java:19)
Caused by: java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at db.ConnectionFactory.getConnection(ConnectionFactory.java:11)
... 1 more
Someone help me, please?
Thanks,
Jurandyr F. Alves