Pessoal,
Ficaria muito grato se alguém pudesse me ajudar.
A situação é a seguinte : Estou compilando normalmente o código abaixo, porém na execução, ele apresenta o erro mostrado abaixo do código.
Código :
package t;
/*
* This sample can be used to check the JDBC installation.
* Just run it and provide the connect information. It will select
* "Hello World" from the database.
*/
// You need to import the java.sql package to use JDBC
import java.sql.*;
// We import java.io to be able to read from the command line
import java.io.*;
class JdbcTest {
public static void main(String args[])
throws SQLException, IOException {
// Load the Oracle JDBC driver
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
// Prompt the user for connect information
System.out.println(
"Please enter information to test connection to the database");
String user;
String password;
user = readEntry("user: ");
int slash_index = user.indexOf('/');
if (slash_index != -1) {
password = user.substring(slash_index + 1);
user = user.substring(0, slash_index);
}
else
password = readEntry("password: ");
System.out.print("Connecting to the database...");
System.out.flush();
System.out.println("Connecting...");
Connection conn =
DriverManager.getConnection(
"jdbc:oracle:thin:@10.67.21.41:1527:netp",
user, password);
System.out.println("connected.");
// Create a statement
Statement stmt = conn.createStatement();
// Do the SQL "Hello World" thing
ResultSet rset = stmt.executeQuery("select 'Hello World' from dual");
while (rset.next())
System.out.println(rset.getString(1));
// close the result set, the statement and connect
rset.close();
stmt.close();
conn.close();
System.out.println("Your JDBC installation is correct.");
}
// Utility function to read a line from standard input
static String readEntry(String prompt) {
try {
StringBuffer buffer = new StringBuffer();
System.out.print(prompt);
System.out.flush();
int c = System.in.read();
while (c != '\n' && c != -1) {
buffer.append( (char) c);
c = System.in.read();
}
return buffer.toString().trim();
}
catch (IOException e) {
return "";
}
}
}
MSG de Erro :
java.lang.NoClassDefFoundError: oracle/dms/console/DMSConsole
at oracle.jdbc.driver.DMSFactory.<clinit>(DMSFactory.java:28)
at oracle.jdbc.driver.OracleConnection.createDMSSensors(OracleConnection.java:662)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:325)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:521)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:325)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at t.JdbcTest.main(JdbcTest.java:42)
Exception in thread "main"