[Anonymous]

When attempting to view the "Contents" of a table
through squirrel, I recieve a "Protocol Violation".

I am using Oracle's ojdbc14.jar to perform a
thin-client connection.

I have attached a zip containing the Squirrel Log and
the JDBC Debug Log files for this error.

Side Note: This same ojdbc14.jar file and connection
information works just fine under Squirrel Version
1.1final1

JDBC and SQuirreL Log files

Logged In: YES
user_id=1287991

Hello,

Could it be that you are not using at least JDK 1.4 ?

The reason why I ask is because getResultSetHoldability wasn't
instroduced until 1.4:

java.sql.SQLException: Unsupported feature
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at
oracle.jdbc.dbaccess.DBError.throwUnsupportedFeatureSqlException(DBError.java:689)
at
oracle.jdbc.OracleDatabaseMetaData.getResultSetHoldability(OracleDatabaseMetaData.java:4426)

Rob Manning

Logged In: YES
user_id=1287991

No, that cannot be it since your version is 1.5 (Duh!):

java.version: 1.5.0_02

I'm suspecting that it's a driver / server combination
issue, or perhaps a bug in the Oracle JDBC driver:

Take a look here
(http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#30_17)

What does "Protocol Violation" mean?

The Thin driver throws this exception when it reads
something from the RDBMS that it did not expect. This means
that the protocol engine in the Thin driver and the protocol
engine in the RDBMS are out of synch. There is no way to
recover from this error. The connection is dead. You should
try to close it, but that will probably fail too.

If you get a reproducible test case that generates this
error, please file a TAR with Oracle Global Support. Be sure
to specify the exact version numbers of the JDBC driver and
the RDBMS, including any patches.

Rob Manning

Logged In: YES
user_id=1287991

I was able to reproduce this problem using a 1.2 version of
the Oracle JDBC driver (classes12.zip) and JDK 1.4
connecting to an Oracle 9i database server.(I was also
seeing some "Not in streaming mode" error messages from the
driver at the same time) I suspect that there might be some
incompatibility between the driver and the jvm since 1.4
introduces various new JDBC API methods (setSavePoint and
the like) to Connection. I've added code to CVS that will
detect this condition and warn the user when the session is
opened. Hopefully this will
help the user isolate the problem and address it before it
happens in the future.

Logged In: YES
user_id=617186

I'm getting exactly the same kind of error with various
drivers (both ojdbc14.jar and classes12.jar, althought I get
different error messages) trying to connect to an oracle 9i
database over a VPN made with OpenVPN.
Connecting to a local 9i database does not trigger the problem.

On the other hand, DbVisualizer is working fine over the VPN
with the same drivers and java version, and Squirrel 1.1
final1 is working fine as well, whilst Squirrel 1.2 beta5
does not work either -> you are probably triggering an
error, but version 1.1 did not...
I'm attaching the stack trace I get when I try to see the
columns of a table.

Logged In: YES
user_id=617186

Hum... I don't see a way to attach the file, maybe because
I'm not the original reporter. Can I send it to someone?

• milestone: --> 540457
• assigned_to: colbell --> manningr

Stack traces submitted by user aaime

• status: open --> pending-accepted

• milestone: 540457 --> 2.1rc1
• priority: 5 --> 8