java.sql.SQLException: Protocol violation on Oracle

Hi!

  I am using the Squirrel SQL application to connect to an Oracle instance from my local PC using the thin driver. The problem I have is that at one moment when running the application I get the following exception (from the trace):

71503 [Thread-1] ERROR
net.sourceforge.squirrel_sql.client.session.SchemaInfo - failed to load stroed procedures
java.sql.SQLException: Protocol violation

	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
	at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160)
	at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:594)
	at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1983)
	at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:1250)
	at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:295)
	at net.sourceforge.squirrel_sql.fw.sql.ResultSetReader.readRow(ResultSetReader.java:118)
	at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getProcedures(SQLDatabaseMetaData.java:700)
	at net.sourceforge.squirrel_sql.client.session.SchemaInfo.loadStoredProcedures(SchemaInfo.java:189)
	at net.sourceforge.squirrel_sql.client.session.SchemaInfo.load(SchemaInfo.java:169)
	at net.sourceforge.squirrel_sql.client.session.SchemaInfo.load(SchemaInfo.java:76)
	at net.sourceforge.squirrel_sql.client.session.Session.loadTableInfo(Session.java:690)
	at net.sourceforge.squirrel_sql.client.session.Session.access$000(Session.java:66)
	at net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:192)
	at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
	at java.lang.Thread.run(Thread.java:534)

Environment:
My PC:
Windows XP + jdk1.4 + ojdbc14_g.jar and ocrs12.zip (Oracle drivers) + squirrel sql application.
Please note that the version for the drivers (driverVersion) is 9.2.0.4.0.

The oracle server:
Solaris OS with SPARC64 processors + Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 – Production.

The strange thing is that if I start the application from the server I have no problems with it but from my local machine it does not work. I am sure that I have the right drivers and JDK but I think it is a problem of communication between the two machines (maybe some low-level encoding or charset usage).

Did you encounter this problem before?

If someone from Oracle development takes a look over the stack trace maybe they can find where the problem is.

The question is if you have a workaround for this problem.

Many thanks for help,
  Cristi

PS: I have searched a lot over google for this problem and it appears many times. I have done some tricks (like set NLS_LANG=american_america.UTF8) but it didn't work. Received on Wed Oct 13 2004 - 09:31:13 CDT