Help with JDBC/Listener Error

Hi,

We are experiencing an unusual problem using the Oracle type 4 JDBC driver. When attempting to make a connection to the database we get a "java.sql.SQLException: No more data to read from socket". The listener is running, we can do a successful TNSPING, the username password, SID etc are all correct. We can log in via SQLPlus, Oracle Navigator etc. We have tried all the above and running the java code locally and remotely to the database server. What works locally works remotely and what doesn't doesn't!

The JDBC URL being used is:

jdbc:oracle:thin:@software:1521:SOL

Where software is our hostname, 1521 is the listener port and SOL is the SID. Any suggestions on what the problem and resolution might be? It's almost like the listener times out before a response can be made but we have done a number of similar configurations with no problem.

Many thanks in advance,

Jeremy Aston - jeremy.aston_at_futuremedia.co.uk Futuremedia PLC
http://www.futuremedia.co.uk
http://www.solstra.com Received on Wed May 26 1999 - 11:22:50 CDT