JDBC Oracle connection error

[kris iyer]

Hi all
I was trying to connect to my oracle database with Type 4 driver....also added classes111.zip in my class path then
ran the following java script to check my connection
it gave me the following error
Testing: jdbc:oracle:thin:somelogin/[email protected]:1521:jive
An exception occurred while connecting and performing our test query.
Refused:ROR=<CODE=12505><EMFI=4>>>>

I can't figure out the reason...can someone help me
Thanks
Kris Iyer

import java.sql.*;
 
public class dbTest
{
 
public static void main (String[] args)
{
String DBURL="jdbc:oracle:thin"; //You should never need to change this
String USER="somelogin"; //Oracle Login name
String PASS="somepass"; //Oracle Login Password
String SERVER="some.db.server.com"; //DB Server IP or DNS
String PORT="1521"; //DB Listener port
String DB="jive"; //ORACLE_SID of the db you want to test
 
String connectURL=DBURL+":"+USER+"/"+PASS+"@"+SERVER+":"+PORT+":"+DB;
 
System.out.println("\nTesting: " + connectURL);
 
// Step 1: Get the jdbc Driver class.
 
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch (ClassNotFoundException e)
{
System.err.println("An exception occurred while opening the Driver Class.");
System.err.println(e) ;
System.exit(-1) ;
}
 
        // Step 2: Establish the connection to the database.
 
try
{
Connection conn = DriverManager.getConnection(connectURL);
 
// Step 3: Test the connection to the database.
 
            Statement stmt = conn.createStatement();
ResultSet rset = stmt.executeQuery("select * from DUAL");
 
System.out.println("The database returned: "+rset.next()+"\n");
 
//Step 4: Be kind to garbage collection
 
stmt.close(); //Close our statement obj
rset.close(); //Close our result set
conn.close(); //Close our connection
}
catch (Exception e)
{
System.err.println("An exception occurred while connecting and performing our test query.");
System.err.println(e.getMessage());
}
}
}
  <a href="mailto:[e-mail]" rel="nofollow">[e-mail]</a>  

:roll: :roll:
[ Edited bt Dave to format code and fix smilies ]
[ March 27, 2002: Message edited by: David O'Meara ]

[Mahesh Mamani]

Hi,
Here is the code for the connection part which may help u ,

import java.io.*;
import java.util.*;
import java.sql.*;
class DbOraTest 
{
    public static void main(String[] args)
    {
        Properties x = new Properties();
        x.put("user","custview"); 
        x.put("password","custview");
        try
        {
            String url= "jdbc:oracle:thin:@8.95.0.234:1521:IFXT"; 
            Class.forName("oracle.jdbc.driver.OracleDriver"); 
            Connection conn = DriverManager.getConnection(url, x);
            Statement st=conn.createStatement();
            ResultSet rs=st.executeQuery("select * from news");
 
            while(rs.next())
            {
                System.out.println(rs.getString(1));
                System.out.println(rs.getString(2));
            }
        }
        catch(Exception e)
        {
            System.out.println(e);
        }
    }
}

Bye,

Mahesh
[ Edited by Dave to format code and fix smilies ]
[ March 27, 2002: Message edited by: David O'Meara ]

[David O'Meara]

"kris_iyer",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp.
We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please edit your profile and select a new name which meets the requirements.
Thanks.
Dave

[kris iyer]

Hi Mahesh
Big thanks....:-)I made some changes in my script ...earlier i was reffering to SERVICE NAME from my tnsnames and also added classes12.zip to classpath and now it's working fine
thanks
kris