#1079 SQuirrel Hangs and does not response when Derby Server is not on

2.1final
open
nobody
None
5
1 day ago
2013-04-19
Atul
No

I configured SQuirrel for as Derby Client and Postgre Client. The problem is when I start the Squirrel and my Derby Server is not on, it doesn't response at all. This has happened almost all the times. It gets stuck and only way to close is from the Task Manager.

Following are the logs for the same:

2013-04-19 10:14:00,236 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - #############################################################################################################
2013-04-19 10:14:00,239 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - # Starting SQuirreL SQL Client Version 3.4.0 at 4/19/13 10:14 AM
2013-04-19 10:14:00,239 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - #############################################################################################################
2013-04-19 10:14:00,241 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - SQuirreL SQL Client Version 3.4.0 started: Fri Apr 19 10:14:00 SGT 2013
2013-04-19 10:14:00,241 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - Copyright (c) 2001-2011
Colin Bell, Gerd Wagner, Rob Manning and others
2013-04-19 10:14:00,241 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - java.vendor: Sun Microsystems Inc.
2013-04-19 10:14:00,241 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - java.version: 1.6.0_20
2013-04-19 10:14:00,241 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - java.runtime.name: Java(TM) SE Runtime Environment
2013-04-19 10:14:00,241 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - os.name: Windows 7
2013-04-19 10:14:00,242 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - os.version: 6.1
2013-04-19 10:14:00,242 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - os.arch: x86
2013-04-19 10:14:00,242 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - user.dir: E:\squirrel\installation
2013-04-19 10:14:00,242 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - user.home: C:\Users\atulkumara
2013-04-19 10:14:00,242 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - java.home: C:\CrimsonLogic\TradeWeb\jdk1.6.0_20\jre
2013-04-19 10:14:00,242 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - java.class.path: E:\squirrel\installation\squirrel-sql.jar;E:\squirrel\installation\lib\antlr.jar;E:\squirrel\installation\lib\asm-attrs.jar;E:\squirrel\installation\lib\asm.jar;E:\squirrel\installation\lib\autocomplete.jar;E:\squirrel\installation\lib\axis-jaxrpc.jar;E:\squirrel\installation\lib\axis-saaj.jar;E:\squirrel\installation\lib\axis-wsdl4j.jar;E:\squirrel\installation\lib\axis.jar;E:\squirrel\installation\lib\cglib.jar;E:\squirrel\installation\lib\common.jar;E:\squirrel\installation\lib\commons-cli.jar;E:\squirrel\installation\lib\commons-codec.jar;E:\squirrel\installation\lib\commons-collections.jar;E:\squirrel\installation\lib\commons-discovery.jar;E:\squirrel\installation\lib\commons-httpclient.jar;E:\squirrel\installation\lib\commons-lang.jar;E:\squirrel\installation\lib\commons-logging.jar;E:\squirrel\installation\lib\core.jar;E:\squirrel\installation\lib\forms.jar;E:\squirrel\installation\lib\fw.jar;E:\squirrel\installation\lib\hibernate-annotations.jar;E:\squirrel\installation\lib\hibernate-commons-annotations.jar;E:\squirrel\installation\lib\hibernate-entitymanager.jar;E:\squirrel\installation\lib\hibernate.jar;E:\squirrel\installation\lib\icu4j.jar;E:\squirrel\installation\lib\javahelp.jar;E:\squirrel\installation\lib\jide-oss.jar;E:\squirrel\installation\lib\jmeld.jar;E:\squirrel\installation\lib\jxl.jar;E:\squirrel\installation\lib\log4j.jar;E:\squirrel\installation\lib\nanoxml.jar;E:\squirrel\installation\lib\org.eclipse.equinox.common.jar;E:\squirrel\installation\lib\osgi.jar;E:\squirrel\installation\lib\rsyntaxtextarea.jar;E:\squirrel\installation\lib\rtext.jar;E:\squirrel\installation\lib\spring-beans.jar;E:\squirrel\installation\lib\spring-context-support.jar;E:\squirrel\installation\lib\spring-context.jar;E:\squirrel\installation\lib\spring-core.jar;E:\squirrel\installation\lib\stringtemplate.jar;E:\squirrel\installation\lib\swing-worker.jar;E:\squirrel\installation\lib\treetable.jar;E:\squirrel\installation\lib\versioncheck.jar;E:\squirrel\installation\lib\x86.jar;E:\squirrel\installation\lib\xml-apis.jar
2013-04-19 10:14:03,474 [AWT-EventQueue-1] WARN net.sourceforge.squirrel_sql.plugins.laf.LAFPlugin - Failed to create empty required user files
2013-04-19 10:14:09,500 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.plugins.laf.LAFRegister - Setting lookandfeel class: javax.swing.plaf.metal.MetalLookAndFeel
2013-04-19 10:14:10,413 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - Apr 19, 2013 10:14:10 AM java.util.prefs.WindowsPreferences <init>

2013-04-19 10:14:10,414 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - WARNING: Could not open/create prefs root node Software\JavaSoft\Prefs at root 0x80000002. Windows RegCreateKeyEx(...) returned error code 5.

2013-04-19 10:14:11,366 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.plugin.PluginQueryTokenizerPreferencesManager - prefs.xml not found - will be created
2013-04-19 10:14:11,565 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.plugins.refactoring.prefs.RefactoringPreferencesManager - prefs.xml not found - will be created
2013-04-19 10:14:11,573 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.plugin.PluginQueryTokenizerPreferencesManager - prefs.xml not found - will be created
2013-04-19 10:14:11,574 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin wiki tables created in 0 ms, loaded in 0 ms, initialized in 30 ms, total 30 ms.
2013-04-19 10:14:11,575 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin sqlparam created in 1 ms, loaded in 0 ms, initialized in 2 ms, total 3 ms.
2013-04-19 10:14:11,576 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin sqlval created in 1 ms, loaded in 0 ms, initialized in 27 ms, total 28 ms.
2013-04-19 10:14:11,576 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin oracle created in 39 ms, loaded in 0 ms, initialized in 123 ms, total 162 ms.
2013-04-19 10:14:11,577 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin postgres created in 1 ms, loaded in 1 ms, initialized in 1 ms, total 3 ms.
2013-04-19 10:14:11,578 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin sqlbookmark created in 1 ms, loaded in 0 ms, initialized in 7 ms, total 8 ms.
2013-04-19 10:14:11,578 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin editextras created in 0 ms, loaded in 0 ms, initialized in 6 ms, total 6 ms.
2013-04-19 10:14:11,579 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin sqlreplace created in 0 ms, loaded in 0 ms, initialized in 2 ms, total 2 ms.
2013-04-19 10:14:11,579 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin laf created in 37 ms, loaded in 6,029 ms, initialized in 0 ms, total 6,066 ms.
2013-04-19 10:14:11,580 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin smarttools created in 0 ms, loaded in 0 ms, initialized in 0 ms, total 0 ms.
2013-04-19 10:14:11,581 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin syntax created in 1 ms, loaded in 0 ms, initialized in 80 ms, total 81 ms.
2013-04-19 10:14:11,581 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin graph created in 1 ms, loaded in 0 ms, initialized in 4 ms, total 5 ms.
2013-04-19 10:14:11,582 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin codecompletion created in 1 ms, loaded in 0 ms, initialized in 3 ms, total 4 ms.
2013-04-19 10:14:11,583 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin dbdiff created in 0 ms, loaded in 0 ms, initialized in 7 ms, total 7 ms.
2013-04-19 10:14:11,583 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin sqlscript created in 0 ms, loaded in 0 ms, initialized in 7 ms, total 7 ms.
2013-04-19 10:14:11,584 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin dbcopy created in 1 ms, loaded in 0 ms, initialized in 27 ms, total 28 ms.
2013-04-19 10:14:11,585 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin refactoring created in 1 ms, loaded in 0 ms, initialized in 8 ms, total 9 ms.
2013-04-19 10:14:11,585 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin mysql created in 7 ms, loaded in 102 ms, initialized in 8 ms, total 117 ms.
2013-04-19 10:14:14,180 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.gui.db.ConnectToAliasCallBack - Unexpected Error occurred attempting to open an SQL connection.
java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLNonTransientConnectionException: java.net.ConnectException : Error connecting to server localhost on port 1527 with message Connection refused: connect.
at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:232)
at java.util.concurrent.FutureTask.get(FutureTask.java:91)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.RuntimeException: java.sql.SQLNonTransientConnectionException: java.net.ConnectException : Error connecting to server localhost on port 1527 with message Connection refused: connect.
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:171)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104)
... 6 more
Caused by: java.sql.SQLNonTransientConnectionException: java.net.ConnectException : Error connecting to server localhost on port 1527 with message Connection refused: connect.
at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
... 8 more
Caused by: org.apache.derby.client.am.DisconnectException: java.net.ConnectException : Error connecting to server localhost on port 1527 with message Connection refused: connect.
at org.apache.derby.client.net.NetAgent.<init>(Unknown Source)
at org.apache.derby.client.net.NetConnection.newAgent_(Unknown Source)
at org.apache.derby.client.am.Connection.<init>(Unknown Source)
at org.apache.derby.client.net.NetConnection.<init>(Unknown Source)
at org.apache.derby.client.net.NetConnection40.<init>(Unknown Source)
at org.apache.derby.client.net.ClientJDBCObjectFactoryImpl40.newNetConnection(Unknown Source)
... 11 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:529)
at java.net.Socket.connect(Socket.java:478)
at java.net.Socket.<init>(Socket.java:375)
at java.net.Socket.<init>(Socket.java:189)
at javax.net.DefaultSocketFactory.createSocket(SocketFactory.java:206)
at org.apache.derby.client.net.OpenSocketAction.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
... 17 more
2013-04-19 10:16:37,101 [Update Check Timer Thread] INFO org.apache.commons.httpclient.HttpMethodDirector - I/O exception (java.net.ConnectException) caught when processing request: Connection timed out: connect
2013-04-19 10:16:37,101 [Update Check Timer Thread] INFO org.apache.commons.httpclient.HttpMethodDirector - Retrying request
2013-04-19 10:16:58,112 [Update Check Timer Thread] INFO org.apache.commons.httpclient.HttpMethodDirector - I/O exception (java.net.ConnectException) caught when processing request: Connection timed out: connect
2013-04-19 10:16:58,112 [Update Check Timer Thread] INFO org.apache.commons.httpclient.HttpMethodDirector - Retrying request
2013-04-19 10:17:19,113 [Update Check Timer Thread] INFO org.apache.commons.httpclient.HttpMethodDirector - I/O exception (java.net.ConnectException) caught when processing request: Connection timed out: connect
2013-04-19 10:17:19,113 [Update Check Timer Thread] INFO org.apache.commons.httpclient.HttpMethodDirector - Retrying request
2013-04-19 10:17:40,111 [Update Check Timer Thread] ERROR net.sourceforge.squirrel_sql.fw.util.IOUtilitiesImpl - downloadHttpFile: Unexpected exception while attempting to open an HTTP connection to url (http://sourceforge.net/projects/squirrel-sql/files/updates/stable/release.xml) to download a file (E:\squirrel\installation\update\downloads\release.xml): Connection timed out: connect
java.net.ConnectException: Connection timed out: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:529)
at java.net.Socket.connect(Socket.java:478)
at java.net.Socket.<init>(Socket.java:375)
at java.net.Socket.<init>(Socket.java:249)
at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:80)
at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:122)
at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:707)
at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:387)
at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:323)
at net.sourceforge.squirrel_sql.fw.util.IOUtilitiesImpl.downloadHttpFile(IOUtilitiesImpl.java:321)
at net.sourceforge.squirrel_sql.client.update.UpdateUtilImpl.downloadHttpUpdateFile(UpdateUtilImpl.java:875)
at net.sourceforge.squirrel_sql.client.update.UpdateUtilImpl.downloadCurrentReleaseHttp(UpdateUtilImpl.java:1055)
at net.sourceforge.squirrel_sql.client.update.UpdateUtilImpl.downloadCurrentRelease(UpdateUtilImpl.java:204)
at net.sourceforge.squirrel_sql.client.update.async.ReleaseFileUpdateCheckTask.getCurrentChannelXmlBean(ReleaseFileUpdateCheckTask.java:161)
at net.sourceforge.squirrel_sql.client.update.async.ReleaseFileUpdateCheckTask.run(ReleaseFileUpdateCheckTask.java:110)
at net.sourceforge.squirrel_sql.client.update.autocheck.UpdateCheckTimerImpl$UpdateCheckRunnable.isUpToDate(UpdateCheckTimerImpl.java:163)
at net.sourceforge.squirrel_sql.client.update.autocheck.UpdateCheckTimerImpl$UpdateCheckRunnable.run(UpdateCheckTimerImpl.java:133)
at java.lang.Thread.run(Thread.java:619)
2013-04-19 10:17:40,112 [Update Check Timer Thread] ERROR net.sourceforge.squirrel_sql.client.update.async.ReleaseFileUpdateCheckTask - Unexpected exception: Connection timed out: connect
java.net.ConnectException: Connection timed out: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:529)
at java.net.Socket.connect(Socket.java:478)
at java.net.Socket.<init>(Socket.java:375)
at java.net.Socket.<init>(Socket.java:249)
at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:80)
at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:122)
at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:707)
at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:387)
at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:323)
at net.sourceforge.squirrel_sql.fw.util.IOUtilitiesImpl.downloadHttpFile(IOUtilitiesImpl.java:321)
at net.sourceforge.squirrel_sql.client.update.UpdateUtilImpl.downloadHttpUpdateFile(UpdateUtilImpl.java:875)
at net.sourceforge.squirrel_sql.client.update.UpdateUtilImpl.downloadCurrentReleaseHttp(UpdateUtilImpl.java:1055)
at net.sourceforge.squirrel_sql.client.update.UpdateUtilImpl.downloadCurrentRelease(UpdateUtilImpl.java:204)
at net.sourceforge.squirrel_sql.client.update.async.ReleaseFileUpdateCheckTask.getCurrentChannelXmlBean(ReleaseFileUpdateCheckTask.java:161)
at net.sourceforge.squirrel_sql.client.update.async.ReleaseFileUpdateCheckTask.run(ReleaseFileUpdateCheckTask.java:110)
at net.sourceforge.squirrel_sql.client.update.autocheck.UpdateCheckTimerImpl$UpdateCheckRunnable.isUpToDate(UpdateCheckTimerImpl.java:163)
at net.sourceforge.squirrel_sql.client.update.autocheck.UpdateCheckTimerImpl$UpdateCheckRunnable.run(UpdateCheckTimerImpl.java:133)
at java.lang.Thread.run(Thread.java:619)
2013-04-19 10:17:40,113 [Update Check Timer Thread] WARN net.sourceforge.squirrel_sql.client.update.async.ReleaseFileUpdateCheckTask - run: currentChannelBean was null - it is inconclusive whether or not the software is current : assuming that it is for now

Discussion

  • Atul
    Atul
    2013-04-19

    sorry. I can't edit but Squirrel version is 3.4.0. And yes when I start the derby server it works fine without any issue.

     
    Last edit: Atul 2013-04-19