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.Schema Info - failed to
load stroed procedures
java.sql.SQLException: Protocol violation
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:179)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.j ava: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.j ava:1250)
at oracle.jdbc.driver.OracleResultSetImpl.next(Oracle ResultSetImpl.java:295)
at net.sourceforge.squirrel_sql.fw.sql.ResultSetReade r.readRow(ResultSetReader.java:118)
at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMet aData.getProcedures(SQLDatabaseMetaData.java:700)
at net.sourceforge.squirrel_sql.client.session.Schema Info.loadStoredProcedures(SchemaInfo.java:189)
at net.sourceforge.squirrel_sql.client.session.Schema Info.load(SchemaInfo.java:169)
at net.sourceforge.squirrel_sql.client.session.Schema Info.load(SchemaInfo.java:76)
at net.sourceforge.squirrel_sql.client.session.Sessio n.loadTableInfo(Session.java:690)
at net.sourceforge.squirrel_sql.client.session.Sessio n.access$000(Session.java:66)
at net.sourceforge.squirrel_sql.client.session.Sessio n$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.