Re: [Squirrel-sql-users] Oracle: Protocol violation/Bigger type length than Maximum error

[gwg <gw...@co...>]

Hi Andrew,

Since the error seems to be generated by the Oracle driver this may not 
help us, but what does the Squirrel log file say?  It is not clear from 
your message what OS you are running on so I can't tell you exactly 
where the Squirrel log file is, but if you do a search on your system 
for "squirrel" you should be able to find it.

Glenn

Andrew Inggs wrote:
> Setup is:
> 
> SQuirreL SQL 1.2beta6
> Oracle Plugin 0.13
> Oracle JDBC thin driver 9.2.0.3.0
> Oracle Database 9.2.0.4.0 (HP-UX)
> J2SE 1.4.2_04
> 
> The first time a run Squirrel and connect to this database, click on a schema
> (CRMCC, not the same as the username I log in with), open the list of tables, select
> a table (AGENT), click on the Contents tab, I get the following errors:
> 
> java.sql.SQLException: Protocol violation
> java.sql.SQLException: Bigger type length than Maximum
> 
> If I click on the top-level database connection and then back on the table name I
> get:
> 
> java.sql.SQLException: Refcursor value is invalid
> 
> Close database connection, reconnect, go to the first table again, click Contents
> tab:
> 
> java.sql.SQLException: Io exception: invalid arguments in call
> java.sql.SQLException: Io exception: invalid arguments in call
> 
> If I then open up a connection to a database that has a similar schema but runs on a
> Windows server (Oracle Database 9.2.0.1.0), close this connection, then reopen the
> connection to the database on HP-UX I get no errors.
> 
> A trace leading up to the first exception is given at the end of this message.  The
> trace was generated using OracleLog (ojdbc14_g.jar with oracle.jdbc.Trace and
> oracle.jdbc.LogFile Java system properties set).  The full trace is available if
> anyone is interested (2.2 MB uncompressed).
> 
> Any ideas?
> 
> -- Andrew