[esb-issues] [JBoss JIRA] Commented: (JBESB-1777) helloworld_tx_sql_action 'Database already closed' error

[Darrin Mison (JIRA)]

    [ https://jira.jboss.org/jira/browse/JBESB-1777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12422509#action_12422509 ] 

Darrin Mison commented on JBESB-1777:
-------------------------------------

Proposed SOA 4.2 TP02 Release Note:
DB_CLOSE_ON_EXIT flag added to helloworld_tx_sql_action/quickstart-ds.xml to prevent premature database closure via shutdown hook

> helloworld_tx_sql_action 'Database already closed' error
> --------------------------------------------------------
>
>                 Key: JBESB-1777
>                 URL: https://jira.jboss.org/jira/browse/JBESB-1777
>             Project: JBoss ESB
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: Examples
>    Affects Versions: 4.2.1 CP2
>            Reporter: Kevin Conner
>            Assignee: Kevin Conner
>             Fix For: 4.2.1 CP3
>
>
> The quickstart ds.xml does not specify the DB_CLOSE_ON_EXIT flag which is needed on the first connection in order to prevent the h2 shutdown hook from prematurely closing the DB.
> org.h2.jdbc.JdbcSQLException: Database is already closed (to disable automatic closing at VM shutdown, add ";DB_CLOSE_ON_EXIT=FALSE" to the db URL) [90121-68]

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira