connect to oracle

[leila94]

کد زیر

package Test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Scanner;

public class ConnectOracleDB {

public static void main(String[] args) {

Scanner scanner = new Scanner(System.in);
System.out
.println("Please provide below details to connect Oracle Database");
System.out.println("Enter Database");
String dbName = scanner.next();
System.out.println("Enter UserName");
String userName = scanner.next();
System.out.println("Enter Password");
String password = scanner.next();

try {

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

} catch (ClassNotFoundException e) {
e.printStackTrace();
}

Connection connection = null;

try {

connection = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:" + dbName, userName,
password);

} catch (SQLException e) {

e.printStackTrace();
}

if (connection != null) {
System.out.println("nSuccessfullly connected to Oracle DB");
} else {
System.out.println("nFailed to connect to Oracle DB");
}
}

}


خطا:


Please provide below details to connect Oracle Database
Enter Database
Leila
Enter UserName
pmis
Enter Password
pmis
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.j ava:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:3 07)
at sun.misc.Launcher$AppClassLoader.loadClass(Launche r.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:2 52)
at java.lang.ClassLoader.loadClassInternal(ClassLoade r.java:320)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at Test.ConnectOracleDB.main(ConnectOracleDB.java:26)
java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@localhost:1521:Leila
at java.sql.DriverManager.getConnection(DriverManager .java:602)
at java.sql.DriverManager.getConnection(DriverManager .java:185)
at Test.ConnectOracleDB.main(ConnectOracleDB.java:36)
nFailed to connect to Oracle DB


مشکل از کجاست لطفا ؟

[ahmad.mo74]

سلام

java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

درایور اوراکل رو باید به classpath برنامتون اضافه کنید.

http://www.mkyong.com/jdbc/connect-to-oracle-db-via-jdbc-driver-java/
http://www.oracle.com/technetwork/database/features/jdbc/default-2280470.html

اینارو دانلود کنید کافیه :

ojdbc7
ojdbc7dms