-
Here is my short test programm.
import java.sql.*;
import java.math.*;
import java.io.*;
import java.awt.*;
class JDBCVersion
{
public static void main (String args[])
throws SQLException
{
// Load the Oracle JDBC driver
DriverManager.registerDriver
(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection
("jdbc:oracle:oci8:@10.2.1.31:1521:SIMTEST","VRSC","DANAHER");
// Create Oracle DatabaseMetaData object
DatabaseMetaData meta = conn.getMetaData();
// gets driver info:
System.out.println("JDBC driver version is " + meta.getDriverVersion());
}
}
I am getting following error:
Test.java [13:1] package oracle.jdbc.driver does not exist
(new oracle.jdbc.driver.OracleDriver());
Does anybody can point me in right directions?
Thanks!
-
you should import this and make sure path is set
import oracle.jdbc.driver.*;
-
public class blackjack_sql implements Serializable
{
public static Connection connect()
{
String url = "jdbc:oracle:thin:@127.0.0.1:1521:DEVELOP";
Connection blackjack_connect = null;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
} /* End try */
catch(java.lang.ClassNotFoundException e)
{
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
return null;
} /* End catch */
try
{
blackjack_connect = DriverManager.getConnection(url,"blackjack", "mobliss");
return(blackjack_connect);
} /* End try */
catch(SQLException sqlerr)
{
System.err.println("SQLException: " + sqlerr.getMessage());
return null;
}
} /* End connect */
public static void disconnect(Connection blackjack_connect)
{
if(blackjack_connect != null)
{
try
{
blackjack_connect.close();
blackjack_connect=null;
}
catch(SQLException sqlerr)
{
System.err.println("SQLException: " + sqlerr.getMessage());
}
} /* End if */
} /* End disconnect */