java.sql.SQLException: Database 'memory:test' not found.

db-derby-user | Pavel Bortnovskiy | 5 years ago
  1. 0

    RE: Shutting down in-memory Derby gracefully

    db-derby-user | 5 years ago | Pavel Bortnovskiy
    java.sql.SQLException: Database 'memory:test' not found.
  2. 0

    [Ingo - please do not close this issue, it's not resolved - there are 4 crash reports attached from OS/X] Aptana Studio Crashes frequently under OS/X (same release works fine in Ubuntu and Windows). One crash vector appears to be related to either filesystem notifications or source control. When doing an 'svn up' on a directory that Aptana has an open project on, about half the time Aptana Studio will crash. Either immediately or within 10minutes. Aptana Studio also randomly crashes throughout the day. Sometimes I have to restart 10x to get through a day of work. Included are two errors from the tail of my .log. One is an SQLException, the other an IOException from a timed out ping. !ENTRY com.aptana.usage 4 0 2011-11-09 08:48:56.875 !MESSAGE An error occurred while shutting down the database !STACK 0 java.sql.SQLException: Database 'aptanaDB' not found. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleDBNotFound(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source) at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source) at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:207) at com.aptana.usage.AptanaDB.shutdown(AptanaDB.java:172) at com.aptana.usage.UsagePlugin.stop(UsagePlugin.java:74) at org.eclipse.osgi.framework.internal.core.BundleContextImpl$2.run(BundleContextImpl.java:843) at java.security.AccessController.doPrivileged(Native Method) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.stop(BundleContextImpl.java:836) at org.eclipse.osgi.framework.internal.core.BundleHost.stopWorker(BundleHost.java:501) at org.eclipse.osgi.framework.internal.core.AbstractBundle.suspend(AbstractBundle.java:550) at org.eclipse.osgi.framework.internal.core.Framework.suspendBundle(Framework.java:1097) at org.eclipse.osgi.framework.internal.core.StartLevelManager.decFWSL(StartLevelManager.java:597) at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:257) at org.eclipse.osgi.framework.internal.core.StartLevelManager.shutdown(StartLevelManager.java:215) at org.eclipse.osgi.framework.internal.core.InternalSystemBundle.suspend(InternalSystemBundle.java:266) at org.eclipse.osgi.framework.internal.core.Framework.shutdown(Framework.java:690) at org.eclipse.osgi.framework.internal.core.Framework.close(Framework.java:588) at org.eclipse.core.runtime.adaptor.EclipseStarter.shutdown(EclipseStarter.java:415) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:198) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:620) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:575) at org.eclipse.equinox.launcher.Main.run(Main.java:1408) Caused by: java.sql.SQLException: Database 'aptanaDB' not found. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ... 37 more !SESSION 2011-11-09 08:49:56.397 ----------------------------------------------- eclipse.buildId=unknown java.version=1.6.0_29 java.vendor=Apple Inc. BootLoader constants: OS=macosx, ARCH=x86, WS=cocoa, NL=en_US Framework arguments: -keyring /Users/sbarr/.eclipse_keyring -showlocation Command-line arguments: -os macosx -ws cocoa -arch x86 -keyring /Users/sbarr/.eclipse_keyring -consoleLog -showlocation !ENTRY org.eclipse.core.net 1 0 2011-11-09 08:50:04.200 !MESSAGE System property http.nonProxyHosts has been set to local|*.local|169.254/16|*.169.254/16 by an external source. This value will be overwritten using the values from the preferences !ENTRY org.python.pydev.core 4 4 2011-11-09 08:50:06.637 !MESSAGE Server returned HTTP response code: 500 for URL: https://ping.aptana.com/ping.php !STACK 0 java.io.IOException: Server returned HTTP response code: 500 for URL: https://ping.aptana.com/ping.php at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1436) at sun.net.www.protocol.https.HttpsURLConnectionImpl.getInputStream(HttpsURLConnectionImpl.java:234) at org.python.pydev.logging.ping.LogPingSender.sendPing(LogPingSender.java:72) at org.python.pydev.logging.ping.SynchedLogPing.send(SynchedLogPing.java:164) at org.python.pydev.logging.ping.AsyncLogPing.consumeAllCommands(AsyncLogPing.java:131) at org.python.pydev.logging.ping.AsyncLogPing.access$0(AsyncLogPing.java:100) at org.python.pydev.logging.ping.AsyncLogPing$1.run(AsyncLogPing.java:47) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

    Appcelerator JIRA | 5 years ago | San
    java.sql.SQLException: Database 'aptanaDB' not found.
  3. 0

    We've had this error spitting out to our logs _forever_! Can we please get rid of it? {code} !ENTRY com.aptana.usage 2 0 2012-04-26 12:15:06.059 !MESSAGE (Build 3.0.0.1334940636) [WARNING] An error occurred while shutting down the database !STACK 0 java.sql.SQLException: Database 'aptanaDB' not found. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleDBNotFound(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source) at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source) at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:207) at com.aptana.usage.AptanaDB.shutdown(AptanaDB.java:156) at com.aptana.usage.UsagePlugin.stop(UsagePlugin.java:71) at org.eclipse.osgi.framework.internal.core.BundleContextImpl$2.run(BundleContextImpl.java:771) at java.security.AccessController.doPrivileged(Native Method) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.stop(BundleContextImpl.java:764) at org.eclipse.osgi.framework.internal.core.BundleHost.stopWorker(BundleHost.java:510) at org.eclipse.osgi.framework.internal.core.AbstractBundle.suspend(AbstractBundle.java:565) at org.eclipse.osgi.framework.internal.core.Framework.suspendBundle(Framework.java:1161) at org.eclipse.osgi.framework.internal.core.StartLevelManager.decFWSL(StartLevelManager.java:595) at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:257) at org.eclipse.osgi.framework.internal.core.StartLevelManager.shutdown(StartLevelManager.java:215) at org.eclipse.osgi.framework.internal.core.InternalSystemBundle.suspend(InternalSystemBundle.java:284) at org.eclipse.osgi.framework.internal.core.Framework.shutdown(Framework.java:691) at org.eclipse.osgi.framework.internal.core.Framework.close(Framework.java:598) at org.eclipse.core.runtime.adaptor.EclipseStarter.shutdown(EclipseStarter.java:390) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:198) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:577) at org.eclipse.equinox.launcher.Main.run(Main.java:1410) Caused by: java.sql.SQLException: Database 'aptanaDB' not found. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ... 37 more {code}

    Appcelerator JIRA | 5 years ago | Chris Williams
    java.sql.SQLException: Database 'aptanaDB' not found.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Aptana Studio Crashes frequently under OS/X (same release works fine in Ubuntu and Windows). One crash vector appears to be related to either filesystem notifications or source control. When doing an 'svn up' on a directory that Aptana has an open project on, about half the time Aptana Studio will crash. Either immediately or within 10minutes. Aptana Studio also randomly crashes throughout the day. Sometimes I have to restart 10x to get through a day of work. Included are two errors from the tail of my .log. One is an SQLException, the other an IOException from a timed out ping. {code} !ENTRY com.aptana.usage 4 0 2011-11-09 08:48:56.875 !MESSAGE An error occurred while shutting down the database !STACK 0 java.sql.SQLException: Database 'aptanaDB' not found. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleDBNotFound(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source) at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source) at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:207) at com.aptana.usage.AptanaDB.shutdown(AptanaDB.java:172) at com.aptana.usage.UsagePlugin.stop(UsagePlugin.java:74) at org.eclipse.osgi.framework.internal.core.BundleContextImpl$2.run(BundleContextImpl.java:843) at java.security.AccessController.doPrivileged(Native Method) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.stop(BundleContextImpl.java:836) at org.eclipse.osgi.framework.internal.core.BundleHost.stopWorker(BundleHost.java:501) at org.eclipse.osgi.framework.internal.core.AbstractBundle.suspend(AbstractBundle.java:550) at org.eclipse.osgi.framework.internal.core.Framework.suspendBundle(Framework.java:1097) at org.eclipse.osgi.framework.internal.core.StartLevelManager.decFWSL(StartLevelManager.java:597) at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:257) at org.eclipse.osgi.framework.internal.core.StartLevelManager.shutdown(StartLevelManager.java:215) at org.eclipse.osgi.framework.internal.core.InternalSystemBundle.suspend(InternalSystemBundle.java:266) at org.eclipse.osgi.framework.internal.core.Framework.shutdown(Framework.java:690) at org.eclipse.osgi.framework.internal.core.Framework.close(Framework.java:588) at org.eclipse.core.runtime.adaptor.EclipseStarter.shutdown(EclipseStarter.java:415) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:198) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:620) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:575) at org.eclipse.equinox.launcher.Main.run(Main.java:1408) Caused by: java.sql.SQLException: Database 'aptanaDB' not found. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ... 37 more !SESSION 2011-11-09 08:49:56.397 ----------------------------------------------- eclipse.buildId=unknown java.version=1.6.0_29 java.vendor=Apple Inc. BootLoader constants: OS=macosx, ARCH=x86, WS=cocoa, NL=en_US Framework arguments: -keyring /Users/sbarr/.eclipse_keyring -showlocation Command-line arguments: -os macosx -ws cocoa -arch x86 -keyring /Users/sbarr/.eclipse_keyring -consoleLog -showlocation !ENTRY org.eclipse.core.net 1 0 2011-11-09 08:50:04.200 !MESSAGE System property http.nonProxyHosts has been set to local|*.local|169.254/16|*.169.254/16 by an external source. This value will be overwritten using the values from the preferences !ENTRY org.python.pydev.core 4 4 2011-11-09 08:50:06.637 !MESSAGE Server returned HTTP response code: 500 for URL: https://ping.aptana.com/ping.php !STACK 0 java.io.IOException: Server returned HTTP response code: 500 for URL: https://ping.aptana.com/ping.php at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1436) at sun.net.www.protocol.https.HttpsURLConnectionImpl.getInputStream(HttpsURLConnectionImpl.java:234) at org.python.pydev.logging.ping.LogPingSender.sendPing(LogPingSender.java:72) at org.python.pydev.logging.ping.SynchedLogPing.send(SynchedLogPing.java:164) at org.python.pydev.logging.ping.AsyncLogPing.consumeAllCommands(AsyncLogPing.java:131) at org.python.pydev.logging.ping.AsyncLogPing.access$0(AsyncLogPing.java:100) at org.python.pydev.logging.ping.AsyncLogPing$1.run(AsyncLogPing.java:47) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54) {code}

    Appcelerator JIRA | 5 years ago | San
    java.sql.SQLException: Database 'aptanaDB' not found.
  6. 0

    Problem selecting expired sessions java.sql.SQLException: Database 'sessions' not found.

    Eclipse Bugzilla | 5 years ago | gregw
    java.sql.SQLException: Database 'sessions' not found.

  1. muffinmannen 1 times, last 8 months ago
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    Database 'memory:test' not found.

    at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException()
  2. Derby
    AutoloadedDriver.connect
    1. org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
    2. org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
    3. org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
    4. org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
    5. org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
    6. org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
    7. org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
    8. org.apache.derby.impl.jdbc.EmbedConnection.handleDBNotFound(Unknown Source)
    9. org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
    10. org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
    11. org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source)
    12. org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
    13. org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
    14. org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
    14 frames
  3. Java RT
    DriverManager.getConnection
    1. java.sql.DriverManager.getConnection(DriverManager.java:582)
    2. java.sql.DriverManager.getConnection(DriverManager.java:207)
    2 frames