|
From: claudio d. <cla...@gm...> - 2018-09-26 10:04:54
|
I, use squirrel 3.7.1 on win 10 and jdk1.8.0_101 64bit. Try to connect (with a vpn ) to Oracle 12c db, with driver ojdbc.jar ( this driver work fine with primitve eclipse db client ). Squirrel freeze, if disconnect from vpn, squirrel unfreeze and get only schema names not table, not view, not seq, etc.. Thank you. Log from squirrel: 2018-09-26 11:19:53,435 [Thread-2] ERROR net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - failed to load table names java.sql.SQLRecoverableException: IO Error: Software caused connection abort: recv failed at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:790) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:926) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1112) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4846) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501) at oracle.jdbc.OracleDatabaseMetaData.getTables(OracleDatabaseMetaData.java:3716) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTables(SQLDatabaseMetaData.java:990) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadTables(SchemaInfo.java:1212) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadTables(SchemaInfo.java:447) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:348) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:187) at net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:229) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) at java.lang.Thread.run(Thread.java:745) Caused by: java.net.SocketException: Software caused connection abort: recv failed at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.socketRead(SocketInputStream.java:116) at java.net.SocketInputStream.read(SocketInputStream.java:170) at java.net.SocketInputStream.read(SocketInputStream.java:141) at oracle.net.ns.DataPacket.receive(DataPacket.java:105) at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:305) at oracle.net.ns.NetInputStream.read(NetInputStream.java:249) at oracle.net.ns.NetInputStream.read(NetInputStream.java:171) at oracle.net.ns.NetInputStream.read(NetInputStream.java:89) at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:123) at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:79) at oracle.jdbc.driver.T4CMAREngineStream.unmarshalUB1(T4CMAREngineStream.java:429) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:397) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774) ... 14 more 2018-09-26 11:19:53,435 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.plugins.oracle.OraclePlugin - Unexpected exception while attempting to get the database version java.sql.SQLRecoverableException: Closed Connection at oracle.jdbc.driver.PhysicalConnection.getMetaData(PhysicalConnection.java:3123) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.privateGetJDBCMetaData(SQLDatabaseMetaData.java:1933) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getDatabaseMajorVersion(SQLDatabaseMetaData.java:181) at net.sourceforge.squirrel_sql.plugins.oracle.OraclePlugin.isOracleWithFlashBack(OraclePlugin.java:639) at net.sourceforge.squirrel_sql.plugins.oracle.OraclePlugin.getDefaultNodeExpander(OraclePlugin.java:614) at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTreeModel$1$1.run(ObjectTreeModel.java:113) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756) at java.awt.EventQueue.access$500(EventQueue.java:97) at java.awt.EventQueue$3.run(EventQueue.java:709) at java.awt.EventQueue$3.run(EventQueue.java:703) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76) at java.awt.EventQueue.dispatchEvent(EventQueue.java:726) at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93) at java.awt.EventDispatchThread.run(EventDispatchThread.java:82) 2018-09-26 11:19:53,451 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.plugins.oracle.OraclePlugin - Unexpected exception while attempting to get the database version java.sql.SQLRecoverableException: Closed Connection at oracle.jdbc.driver.PhysicalConnection.getMetaData(PhysicalConnection.java:3123) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.privateGetJDBCMetaData(SQLDatabaseMetaData.java:1933) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getDatabaseMajorVersion(SQLDatabaseMetaData.java:181) at net.sourceforge.squirrel_sql.plugins.oracle.OraclePlugin.isOracleWithFlashBack(OraclePlugin.java:639) at net.sourceforge.squirrel_sql.plugins.oracle.OraclePlugin.getDefaultNodeExpander(OraclePlugin.java:614) at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTreeModel$1$1.run(ObjectTreeModel.java:119) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756) at java.awt.EventQueue.access$500(EventQueue.java:97) at java.awt.EventQueue$3.run(EventQueue.java:709) at java.awt.EventQueue$3.run(EventQueue.java:703) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76) at java.awt.EventQueue.dispatchEvent(EventQueue.java:726) at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93) at java.awt.EventDispatchThread.run(EventDispatchThread.java:82) 2018-09-26 11:19:53,451 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.plugins.oracle.OraclePlugin - Unexpected exception while attempting to get the database version java.sql.SQLRecoverableException: Closed Connection at oracle.jdbc.driver.PhysicalConnection.getMetaData(PhysicalConnection.java:3123) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.privateGetJDBCMetaData(SQLDatabaseMetaData.java:1933) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getDatabaseMajorVersion(SQLDatabaseMetaData.java:181) at net.sourceforge.squirrel_sql.plugins.oracle.OraclePlugin.isOracleWithFlashBack(OraclePlugin.java:639) at net.sourceforge.squirrel_sql.plugins.oracle.OraclePlugin.getDefaultNodeExpander(OraclePlugin.java:614) at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTreeModel$1$1.run(ObjectTreeModel.java:125) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756) at java.awt.EventQueue.access$500(EventQueue.java:97) at java.awt.EventQueue$3.run(EventQueue.java:709) at java.awt.EventQueue$3.run(EventQueue.java:703) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76) at java.awt.EventQueue.dispatchEvent(EventQueue.java:726) at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93) at java.awt.EventDispatchThread.run(EventDispatchThread.java:82) 2018-09-26 11:19:53,451 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.plugins.oracle.OraclePlugin - Unexpected exception while attempting to get the database version java.sql.SQLRecoverableException: Closed Connection at oracle.jdbc.driver.PhysicalConnection.getMetaData(PhysicalConnection.java:3123) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.privateGetJDBCMetaData(SQLDatabaseMetaData.java:1933) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getDatabaseMajorVersion(SQLDatabaseMetaData.java:181) at net.sourceforge.squirrel_sql.plugins.oracle.OraclePlugin.isOracleWithFlashBack(OraclePlugin.java:639) at net.sourceforge.squirrel_sql.plugins.oracle.OraclePlugin.getDefaultNodeExpander(OraclePlugin.java:614) at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTreeModel$1$1.run(ObjectTreeModel.java:131) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756) at java.awt.EventQueue.access$500(EventQueue.java:97) at java.awt.EventQueue$3.run(EventQueue.java:709) at java.awt.EventQueue$3.run(EventQueue.java:703) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76) at java.awt.EventQueue.dispatchEvent(EventQueue.java:726) at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93) at java.awt.EventDispatchThread.run(EventDispatchThread.java:82) 2018-09-26 11:19:56,623 [Thread-3] INFO net.sourceforge.squirrel_sql.plugins.sqlparam.SQLParamPlugin - Initializing plugin 2018-09-26 11:19:56,647 [Thread-2] ERROR net.sourceforge.squirrel_sql.client.session.SessionManager - Failed to check allowed Schemas java.sql.SQLRecoverableException: Closed Connection at oracle.jdbc.driver.PhysicalConnection.getMetaData(PhysicalConnection.java:3123) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.privateGetJDBCMetaData(SQLDatabaseMetaData.java:1933) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:276) at net.sourceforge.squirrel_sql.client.session.SessionManager.areAllSchemasAllowed(SessionManager.java:623) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getAllSchemaLoadInfos(SchemaInfoCache.java:126) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getMatchingSchemaLoadInfos(SchemaInfoCache.java:161) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getMatchingSchemaLoadInfos(SchemaInfoCache.java:154) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadStoredProcedures(SchemaInfo.java:592) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadStoredProcedures(SchemaInfo.java:413) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:352) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:187) at net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:229) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) at java.lang.Thread.run(Thread.java:745) 2018-09-26 11:19:56,647 [Thread-2] ERROR net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - Failed to load stored procedures java.sql.SQLRecoverableException: Closed Connection at oracle.jdbc.driver.PhysicalConnection.getMetaData(PhysicalConnection.java:3123) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.privateGetJDBCMetaData(SQLDatabaseMetaData.java:1933) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getProcedures(SQLDatabaseMetaData.java:753) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadStoredProcedures(SchemaInfo.java:598) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadStoredProcedures(SchemaInfo.java:413) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:352) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:187) at net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:229) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) at java.lang.Thread.run(Thread.java:745) 2018-09-26 11:19:56,659 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.plugins.sqlparam.SQLParamPlugin - Adding SQL execution listener. 2018-09-26 11:19:56,659 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.plugins.sqlreplace.SQLReplacePlugin - Adding SQL execution listener. 2018-09-26 11:19:56,847 [Thread-2] ERROR net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab - java.sql.SQLRecoverableException: Closed Connection at oracle.jdbc.driver.PhysicalConnection.getMetaData(PhysicalConnection.java:3123) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.privateGetJDBCMetaData(SQLDatabaseMetaData.java:1933) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getJDBCMetaData(SQLDatabaseMetaData.java:664) at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.database.MetaDataTab.createDataSet(MetaDataTab.java:73) at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:131) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) at java.lang.Thread.run(Thread.java:745) |
