Re: [Squirrel-sql-users] Oracle: Protocol violation/Bigger type length than Maximum error
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: <am...@ya...> - 2004-08-13 21:24:05
|
Hi Glenn --- gwg wrote: > 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. I'm on Windows 2000, sorry I should have included that. I found the logs, below I have included the log statements for a simple session connecting to the troublesome DB, trying to view data in one table and then shutting down. Looks like the problem is relating to obtaining stored procedures. The user I log in with probably doesn't have permission to read stored procedures from the schema in which the tables are. Still wouldn't expect a protocol violation. -- Andrew 0 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - ======================================================= 0 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - ======================================================= 0 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - ======================================================= 0 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - SQuirreL SQL Client Version 1.2beta6 started: Fri Aug 13 23:13:06 GMT+02:00 2004 0 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - Copyright (c) 2001-2003 Colin Bell and others 0 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - java.vendor: Sun Microsystems Inc. 0 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - java.version: 1.4.2_04 0 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - java.runtime.name: Java(TM) 2 Runtime Environment, Standard Edition 0 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - os.name: Windows 2000 0 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - os.version: 5.0 0 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - os.arch: x86 0 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - user.dir: C:\Program Files\SQuirreL SQL Client 1.2beta6 0 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - user.home: C:\Documents and Settings\inggsa 15 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - java.home: C:\j2sdk1.4.2_04\jre 15 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - java.class.path: C:\Program Files\SQuirreL SQL Client 1.2beta6\squirrel-sql.jar;C:\Program Files\SQuirreL SQL Client 1.2beta6\lib\commons-cli.jar;C:\Program Files\SQuirreL SQL Client 1.2beta6\lib\forms.jar;C:\Program Files\SQuirreL SQL Client 1.2beta6\lib\fw.jar;C:\Program Files\SQuirreL SQL Client 1.2beta6\lib\log4j.jar;C:\Program Files\SQuirreL SQL Client 1.2beta6\lib\nanoxml-2.1.jar; 1734 [main] INFO net.sourceforge.squirrel_sql.client.Application - Plugin oracle created in 0 ms, loaded in 0 ms, initialized in 0 ms, total 0 ms. 38297 [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:591) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894) at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:1199) 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) 75375 [AWT-EventQueue-0] INFO net.sourceforge.squirrel_sql.client.Application - Application shutting down 04/08/13 11:14. 75390 [AWT-EventQueue-0] ERROR net.sourceforge.squirrel_sql.client.session.SessionManager - SQL error closing session java.sql.SQLException: Io exception: invalid arguments in call 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:334) at oracle.jdbc.driver.OracleStatement.freeLine(OracleStatement.java:6483) at oracle.jdbc.driver.OracleConnection.needLine(OracleConnection.java:2400) at oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:689) at oracle.jdbc.driver.OraclePreparedStatement.privateClose(OraclePreparedStatement.java:489) at oracle.jdbc.driver.OraclePreparedStatement.close(OraclePreparedStatement.java:396) at oracle.jdbc.driver.OracleConnection.close_statements(OracleConnection.java:2369) at oracle.jdbc.driver.OracleConnection.close(OracleConnection.java:1448) at net.sourceforge.squirrel_sql.fw.sql.SQLConnection.close(SQLConnection.java:104) at net.sourceforge.squirrel_sql.client.session.Session.closeSQLConnection(Session.java:486) at net.sourceforge.squirrel_sql.client.session.Session.close(Session.java:222) at net.sourceforge.squirrel_sql.client.session.SessionManager.closeSession(SessionManager.java:253) at net.sourceforge.squirrel_sql.client.session.SessionWindowManager.privateCloseSession(SessionWindowManager.java:363) at net.sourceforge.squirrel_sql.client.session.SessionWindowManager.sessionInternalFrameClosed(SessionWindowManager.java:404) at net.sourceforge.squirrel_sql.client.session.SessionWindowManager.access$700(SessionWindowManager.java:43) at net.sourceforge.squirrel_sql.client.session.SessionWindowManager$SessionInternalFrameListener.internalFrameClosed(SessionWindowManager.java:448) at javax.swing.JInternalFrame.fireInternalFrameEvent(JInternalFrame.java:1528) at javax.swing.JInternalFrame.dispose(JInternalFrame.java:1756) at net.sourceforge.squirrel_sql.client.session.SessionWindowManager.closeSession(SessionWindowManager.java:302) at net.sourceforge.squirrel_sql.client.session.SessionWindowManager.closeAllSessions(SessionWindowManager.java:282) at net.sourceforge.squirrel_sql.client.Application.shutdown(Application.java:209) at net.sourceforge.squirrel_sql.client.mainframe.MainFrame.dispose(MainFrame.java:130) at net.sourceforge.squirrel_sql.client.mainframe.action.ExitAction.actionPerformed(ExitAction.java:38) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786) at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at javax.swing.AbstractButton.doClick(AbstractButton.java:289) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1113) at javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(BasicMenuItemUI.java:943) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:231) at java.awt.Component.processMouseEvent(Component.java:5100) at java.awt.Component.processEvent(Component.java:4897) at java.awt.Container.processEvent(Container.java:1569) at java.awt.Component.dispatchEventImpl(Component.java:3615) at java.awt.Container.dispatchEventImpl(Container.java:1627) at java.awt.Component.dispatchEvent(Component.java:3477) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128) at java.awt.Container.dispatchEventImpl(Container.java:1613) at java.awt.Window.dispatchEventImpl(Window.java:1606) at java.awt.Component.dispatchEvent(Component.java:3477) at java.awt.EventQueue.dispatchEvent(EventQueue.java:456) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137) at java.awt.EventDispatchThread.run(EventDispatchThread.java:100) 75656 [AWT-EventQueue-0] INFO net.sourceforge.squirrel_sql.client.Application - Application shutdown complete 04/08/13 11:14. ___________________________________________________________ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com |