Announcement

Collapse
No announcement yet.

database shutting down

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • database shutting down

    I am having a problem writing from javascript to my application database (not mirth's internal database) using Mirth 1.3.2.

    The database I am using is derby 10.2.2.0. I am using it in a client-server mode. [I also modified derby's configuration files so that derby's internal database is also client-server].

    Writing to this database using the Mirth-provided Database Writer mechanism is not a problem. However, when I try to connect to the database from inside a transformer javascript step, I get an error message.

    Here is the segment of the script dealing with the connection:
    Code:
    var driver = "org.apache.derby.jdbc.ClientDriver";
    var address = "jdbc:derby://localhost:1527/MYDB";
    var username = "auser";
    var password = "lucky";
     
    var dbConn = DatabaseConnectionFactory.createDatabaseConnection(driver, address, username, password);
    And this is the error message:

    Code:
    ERROR 2007-01-26 12:33:32,203 [2a14c267-f6bb-4d51-8e4e-a57d43453f42_destination_1_connector.dispatcher.1] org.mule.provi
    ders.jdbc.JdbcMessageDispatcher: Error at tranformerorg.mule.umo.transformer.TransformerException: Wrapped java.sql.SQLE
    xception: DERBY SQL error: SQLCODE: -1, SQLSTATE: 08006, SQLERRMC: Database 'MYDB' shutdown. (69d09efa-7c81-4238-be75-2
    a2fb987f23c#17) (org.mozilla.javascript.WrappedException)
    ERROR 2007-01-26 12:33:32,218 [2a14c267-f6bb-4d51-8e4e-a57d43453f42_destination_1_connector.dispatcher.1] org.mule.impl.
    DefaultComponentExceptionStrategy: Caught exception in Exception Strategy for: 2a14c267-f6bb-4d51-8e4e-a57d43453f42: org
    .mule.umo.transformer.TransformerException: Wrapped java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE: 08006
    , SQLERRMC: Database 'MYDB' shutdown. (69d09efa-7c81-4238-be75-2a2fb987f23c#17) (org.mozilla.javascript.WrappedExceptio
    n)
    org.mule.umo.transformer.TransformerException: Wrapped java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE: 08
    006, SQLERRMC: Database 'MYDB' shutdown. (69d09efa-7c81-4238-be75-2a2fb987f23c#17) (org.mozilla.javascript.WrappedExcep
    tion)
            at com.webreach.mirth.server.mule.transformers.JavaScriptTransformer.evaluateInboundTransformerScript(JavaScript
    Transformer.java:275)
            at com.webreach.mirth.server.mule.transformers.JavaScriptTransformer.doTransform(JavaScriptTransformer.java:170)
    
            at org.mule.transformers.AbstractTransformer.transform(AbstractTransformer.java:197)
            at org.mule.impl.MuleEvent.getTransformedMessage(MuleEvent.java:251)
            at org.mule.providers.jdbc.JdbcMessageDispatcher.doDispatch(JdbcMessageDispatcher.java:80)
            at org.mule.providers.AbstractMessageDispatcher$Worker.run(AbstractMessageDispatcher.java:257)
            at org.mule.impl.work.WorkerContext.run(WorkerContext.java:290)
            at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
    
            at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
            at java.lang.Thread.run(Unknown Source)
    Caused by: org.mozilla.javascript.WrappedException: Wrapped java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTAT
    E: 08006, SQLERRMC: Database 'MYDB' shutdown. (69d09efa-7c81-4238-be75-2a2fb987f23c#17)
            at org.mozilla.javascript.Context.throwAsScriptRuntimeEx(Context.java:1693)
            at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:157)
            at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:201)
            at org.mozilla.javascript.optimizer.OptRuntime.callN(OptRuntime.java:84)
            at org.mozilla.javascript.gen.c22._c2(69d09efa-7c81-4238-be75-2a2fb987f23c:17)
            at org.mozilla.javascript.gen.c22.call(69d09efa-7c81-4238-be75-2a2fb987f23c)
            at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:106)
            at org.mozilla.javascript.gen.c22._c0(69d09efa-7c81-4238-be75-2a2fb987f23c:77)
            at org.mozilla.javascript.gen.c22.call(69d09efa-7c81-4238-be75-2a2fb987f23c)
            at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:337)
            at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2755)
            at org.mozilla.javascript.gen.c22.call(69d09efa-7c81-4238-be75-2a2fb987f23c)
            at org.mozilla.javascript.gen.c22.exec(69d09efa-7c81-4238-be75-2a2fb987f23c)
            at com.webreach.mirth.server.mule.transformers.JavaScriptTransformer.evaluateInboundTransformerScript(JavaScript
    Transformer.java:253)
            ... 9 more
    Caused by: java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE: 08006, SQLERRMC: Database 'MYDB' shutdown.
            at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source)
            at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
            at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)
            at java.sql.DriverManager.getConnection(Unknown Source)
            at java.sql.DriverManager.getConnection(Unknown Source)
            at com.webreach.mirth.server.util.DatabaseConnection.<init>(DatabaseConnection.java:64)
            at com.webreach.mirth.server.util.DatabaseConnectionFactory.createDatabaseConnection(DatabaseConnectionFactory.j
    ava:62)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
            at java.lang.reflect.Method.invoke(Unknown Source)
            at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:142)
            ... 21 more
    Caused by: org.apache.derby.client.am.SqlException: DERBY SQL error: SQLCODE: -1, SQLSTATE: 08006, SQLERRMC: Database &#039;MYDB&#039; shutdown.
            at org.apache.derby.client.am.Connection.completeSqlca(Unknown Source)
            at org.apache.derby.client.net.NetConnectionReply.parseRdbAccessFailed(Unknown Source)
            at org.apache.derby.client.net.NetConnectionReply.parseAccessRdbError(Unknown Source)
            at org.apache.derby.client.net.NetConnectionReply.parseACCRDBreply(Unknown Source)
            at org.apache.derby.client.net.NetConnectionReply.readAccessDatabase(Unknown Source)
            at org.apache.derby.client.net.NetConnection.readSecurityCheckAndAccessRdb(Unknown Source)
            at org.apache.derby.client.net.NetConnection.flowSecurityCheckAndAccessRdb(Unknown Source)
            at org.apache.derby.client.net.NetConnection.flowUSRIDPWDconnect(Unknown Source)
            at org.apache.derby.client.net.NetConnection.flowConnect(Unknown Source)
            at org.apache.derby.client.net.NetConnection.<init>(Unknown Source)
            at org.apache.derby.client.net.ClientJDBCObjectFactoryImpl.newNetConnection(Unknown Source)
            ... 31 more
    I have also seen error messages indicating the connection string was "MYDB;shutdown=true". I don&#039;t know how the connection string is getting the shutdown command appended.

    Derby documentation indicates that an exception is thrown whenever the shutdown command is issued.

    The same javascript was working with the same Derby database on mirth 1.2.0.

    Thanks for your help.
    Aziz

  • #2
    Re: database shutting down

    Good find Aziz - can you add this to the JIRA. (www.mirthproject.org/jira).

    1.3.0 uses Ibatis for the DB Connection (to handle pooling, etc). We think the issue lies somewhere in Ibatis. In the meantime, it is possible to use the standard Java database connection methods in your javascript (as opposed to our dbConn object).

    See: http://java.sun.com/docs/books/tutor...iew/index.html

    To use native Java objects in the Javascript you must append class names with Packages.<fully qualified path>

    -Chris
    Chris Lang

    Comment


    • #3
      Re: database shutting down

      Thanks. Will add to jira.

      Comment

      Working...
      X