Java EE (Java Enterprise Edition) General Discussion

try this :
Project --> Properties ---> Java Build Path ---> Libraries , in the list , add your jar to JRE node.

hey thanx .. now i m being able to connect ... but getting a different error .. its nt being able to identify the SID...
i get the following error


java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
192.168.2.222:1521:DBSNP

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at Finisher.MarkerFinishing.con(MarkerFinishing.java:17)
at Finisher.MarkerFinishing.main(MarkerFinishing.java:41)


after this error... i have changed the port n is using the isqlplus port bt still its giving me the following erroe

java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at Finisher.MarkerFinishing.con(MarkerFinishing.java:17)
at Finisher.MarkerFinishing.main(MarkerFinishing.java:41)

are you sure that DBSNP is the correct server instance id?

here an oracle typical connection code:

    Connection connection = null;
    try {
        // Load the JDBC driver
        String driverName = "oracle.jdbc.driver.OracleDriver";
        Class.forName(driverName);
    
        // Create a connection to the database
        String serverName = "127.0.0.1";
        String portNumber = "1521";
        String sid = "mydatabase";
        String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":" + sid;
        String username = "username";
        String password = "password";
        connection = DriverManager.getConnection(url, username, password);
    } catch (ClassNotFoundException e) {
        // Could not find the database driver
    } catch (SQLException e) {
        // Could not connect to the database
    }

ya u r right my sid is snpdb and not dbsnp..
i ve corrected tht. and other things are same as u ve mentioned bt still i get the following error


java.lang.ClassCastException: oracle.jdbc.driver.T4CConnection
at Finisher.MarkerFinishing.con(MarkerFinishing.java:15)
at Finisher.MarkerFinishing.main(MarkerFinishing.java:32)

post the MarkerFinishing.java line # 15 or all the code plz

hi
i am posting the code as such..
i ve tried from eclipse as well as command line ..
and i get the following error

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


import java.sql.DriverManager;
import java.sql.SQLException;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;

public class MarkerFinishing
{
String m_Trigger="dbSNP build 126";
Connection m_markerCon;
public void con() throws SQLException, java.lang.ClassNotFoundException{
Class.forName("oracle.jdbc.driver.OracleDriver"); // oracle driver
m_markerCon = (Connection)DriverManager.getConnection("jdbc:oracle:thin:@192.168.2.222:1521:SNPDB","g2p","g2p");

}
public void A() throws Exception{
//
Statement my_AStmt=(Statement) m_markerCon.createStatement();
System.out.println("Step A: Creating backup of replacedmarker");
// A.executeUpdate("DROP TABLE replacedmarker_temp");
my_AStmt.executeUpdate("create table replacedmarker_temp as(select * from replacedmarker)");
System.out.println("Step A: done");
my_AStmt.close();
}

public static void main(String[] args) {
try{
java.util.Date now=new java.util.Date();
MarkerFinishing mf=new MarkerFinishing();
mf.con();

now=new java.util.Date();
System.out.println("markerFinishing---- Step A" + now);
mf.A();
}catch(Exception e){
e.printStackTrace();
}
}
}

You have problems in the imports part.
You should have imported java.sql.* instead of the mysql jdbc API related imports

Here the correct code:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;


public class MarkerFinishing {
	String m_Trigger = "dbSNP build 126";

	Connection m_markerCon;

	public void con() throws SQLException, java.lang.ClassNotFoundException {
		Class.forName("oracle.jdbc.driver.OracleDriver"); // oracle driver
		m_markerCon = (Connection) DriverManager.getConnection("jdbc:oracle:thin:@192.168.2.222:1521:SNPDB", "g2p", "g2p");

	}

	public void A() throws Exception {
		//
		Statement my_AStmt = (Statement) m_markerCon.createStatement();
		System.out.println("Step A: Creating backup of replacedmarker");
		// A.executeUpdate("DROP TABLE replacedmarker_temp");
		my_AStmt.executeUpdate("create table replacedmarker_temp as(select * from replacedmarker)");
		System.out.println("Step A: done");
		my_AStmt.close();
	}

	public static void main(String[] args) {
		try {
			java.util.Date now = new java.util.Date();
			MarkerFinishing mf = new MarkerFinishing();
			mf.con();

			now = new java.util.Date();
			System.out.println("markerFinishing---- Step A" + now);
			mf.A();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}

Hope That Helps