Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Connecting to Oracle thru thin

2 views
Skip to first unread message

RL Jameson

unread,
Aug 12, 1999, 3:00:00 AM8/12/99
to
Hello,

I'm having problems connecting to an Oracle database thru
JDBC:Thin.

I'm getting the following exception:

java.sql.SQLException: End of TNS data channel
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:406)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:169)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:231)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:208)
at java.sql.DriverManager.getConnection(DriverManager.java:457)
at java.sql.DriverManager.getConnection(DriverManager.java:137)

Got any pointers what this means?

regards,

Randall Jameson
Jameson Software Dev. Lab. Inc.
email: rjam...@io.com
web : www.io.com/~rjameson

Eric

unread,
Aug 13, 1999, 3:00:00 AM8/13/99
to
post your code also

On Thu, 12 Aug 1999 09:36:26 -0500, RL Jameson <rjam...@io.com>
wrote:

RL Jameson

unread,
Aug 13, 1999, 3:00:00 AM8/13/99
to Eric

Eric,

Here it is:
I downloaded the latest driver from Oracle. I'm running
JDK 1.2 and the classes12.zip from Oracle.

static final String driver_class = "oracle.jdbc.driver.OracleDriver";
static final String connect_string =
//<host>:<port>:<sid>
"jdbc:oracle:thin:@bikeserver:1521:BIKE";
try
{
Class.forName (driver_class);
// Connect to the databse
conn = DriverManager.getConnection (connect_string, "bike",
"bike");
}
catch (SQLException ex)
{
// Oops
ex.printStackTrace();
output.append("\n\tException :");
while ( ex != null )
{
output.append("\n\tSQL State : "+ex.getSQLState() );
output.append("\n\tMessage : "+ex.getMessage() );
output.append("\n\tVendor Code : "+ex.getErrorCode() );
ex = ex.getNextException();
}

}
catch(Exception exc)
{
output.append("Exception "+exc.getMessage () + "\n");
}


regards,

Randall Jameson
Jameson Software Dev. Lab. Inc.
email: rjam...@io.com
web : www.io.com/~rjameson

0 new messages