Oracle JDBC Connection Problem

[Debabrata Jana]

Please go through the JAVA code below:

class Main{
public Connection getConnection(){
        Connection l_con = null;
        try {
            String hostname = "172.10.23.1:1527";    //Host IP:port No
            String dbsid = "TESTSID";            //SID Name or Service Name
            String username = "TESTUSER";    //Database user
            String password = "password";        //User password
            String connectingString = "jdbc:oracle:thin:@" + hostname + ":" + dbsid; 
 
            DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
            l_con = DriverManager.getConnection(connectingString,username,password);
 
        } catch (SQLException ex) {
            Logger.getLogger(SQLUtil.class.getName()).log(Level.SEVERE, null, ex);
        }
        return l_con;
    }
 
 
            public static void main(String s[]){
            Main main= new Main();
           Connection l_con = sqlutil.getConnection();              
}
 
}
 
 

When I run the following code we found some error like that:

<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:
172.10.23.1:1527:TESTSID
</ERROR>


Please give me the solution. Thank you.

[JosAH]

@Debabrata Jana
The error message says it all: it can't find the TESTSID service/database. Check the spelling, access rights etc.

kind regards,

Jos