Hallo, beim Ausführen des unten stehenden Codes, stosse ich auf die folgende Fehlermeldung:
Oracle JDBC driver loaded ok.
java.sql.SQLException: No suitable driver found for jdbcracle:thin$HOST:$PORT:$SID
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at example.Client.getData(Client.java:31)
at example.Client.main(Client.java:54)
Was kann der Grund sein?
Oracle JDBC driver loaded ok.
java.sql.SQLException: No suitable driver found for jdbcracle:thin$HOST:$PORT:$SID
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at example.Client.getData(Client.java:31)
at example.Client.main(Client.java:54)
Was kann der Grund sein?
Code:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.jws.WebMethod;
import example.stackoverflow.Greeting;
import example.stackoverflow.GreetingImplService;
public class Client {
@WebMethod
{
public static void getData() {
String user="DB";
String pwd = "password";
String url="jdbc:oracle:thin:@xxx.yy.zz.zz:1521:ABC";
String OracleDriver = "oracle.jdbc.OracleDriver";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
DriverManager.registerDriver (new oracle.jdbc.OracleDriver());
System.out.println("Oracle JDBC driver loaded ok.");
conn = DriverManager.getConnection(url, user, pwd);
System.out.println("Connected");
stmt = conn.createStatement();
} catch (SQLException e) {
e.printStackTrace();
}
}