Bug 778041 (SOA-566)

Link: Added: This issue related SOA-514

To recreate the bug:

ant deploy
ant runtest
ant undeploy
ant deploy

Attachment: Added: server.log

Is this related to this change in:  
     jboss-soa-p.4.2.0/jboss-as/samples/quickstarts/helloworld_tx_sql_action/quickstart-ds.xml

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
   <local-tx-datasource>
         <jndi-name>HelloworldTxSqlDB</jndi-name>
         <connection-url>jdbc:h2:tcp://localhost:9095/;DB_CLOSE_ON_EXIT=FALSE</connection-url>
         <driver-class>org.h2.Driver</driver-class>
         <user-name>sa</user-name>
         <password/>
         <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
         <min-pool-size>5</min-pool-size>
         <max-pool-size>20</max-pool-size>
         <idle-timeout-minutes>0</idle-timeout-minutes>
         <prepared-statement-cache-size>32</prepared-statement-cache-size>
         <depends>jboss:service=HelloworldTxSqlDB</depends>
   </local-tx-datasource>

   <mbean code="org.jboss.internal.soa.esb.dependencies.H2Database" name="jboss:service=HelloworldTxSqlDB">
        <attribute name="Database">HelloworldTxSqlDB</attribute>
        <attribute name="ServerMode">true</attribute>
        <attribute name="Port">9095</attribute>
        <attribute name="InMemoryMode">false</attribute>
   </mbean>
</datasources>
~                                                                                                                 
~                                                                                                                 
~                                     

This is a new problem in CP02. 

The shutdown of the H2 server in H2Database.stopRemoteDatabase() is not shutting down the tcp server.

We only use this type of database for the example so we could choose to document it and fix it later.

Link: Added: This issue depends JBESB-1818

Fixed in CR3.

Still a problem in CP02 CR3 build:

16:07:15,177 INFO  [JDBCDataStore] Generated token 'authToken:F954B680-415F-11DD-A575-9832292E2E8C' for user: 'jbossesb/JBoss ESB User'
16:07:15,216 INFO  [DeleteBindingFunction] Publisher 'jbossesb' deleted BindingTemplate with key: EFE3B880-415F-11DD-A575-D5DD9D3530D3
16:07:15,248 INFO  [ConnectionFactoryBindingService] Unbound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=HelloworldTxSqlDB' from JNDI name 'java:HelloworldTxSqlDB'
16:07:30,559 INFO  [JBoss4ESBDeployer] create esb service, Quickstart_helloworld_TX_SQL_action.esb
16:07:30,619 ERROR [H2Database] Failed to start database
org.h2.jdbc.JdbcSQLException: Exception opening port 9095 (port may be in use), cause: java.net.BindException: Address already in use [90061-68]
        at org.h2.message.Message.getSQLException(Message.java:91)
        at org.h2.util.NetUtils.createServerSocketTry(NetUtils.java:103)
        at org.h2.util.NetUtils.createServerSocket(NetUtils.java:66)
        at org.h2.server.TcpServer.start(TcpServer.java:182)
        at org.h2.tools.Server.start(Server.java:412)
        at org.jboss.internal.soa.esb.dependencies.H2Database$1.run(H2Database.java:434)
Caused by: java.net.BindException: Address already in use
        at java.net.PlainSocketImpl.socketBind(Native Method)
        at java.net.PlainSocketImpl.bind(PlainSocketImpl.java:359)
        at java.net.ServerSocket.bind(ServerSocket.java:319)
        at java.net.ServerSocket.<init>(ServerSocket.java:185)
        at java.net.ServerSocket.<init>(ServerSocket.java:97)
        at org.h2.util.NetUtils.createServerSocketTry(NetUtils.java:97)
        ... 4 more
16:07:30,627 INFO  [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=HelloworldTxSqlDB' to JNDI name 'java:HelloworldTxSqlDB'
16:07:30,634 INFO  [DatabaseInitializer] java:/HelloworldTxSqlDB datasource is already initialized
16:07:30,763 INFO  [JDBCDataStore] Generated token 'authToken:029E7D70-4160-11DD-A575-CD22C89B8CE5' for user: 'jbossesb/JBoss ESB User'
16:07:31,583 INFO  [QuartzScheduler] Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started.

This change was applied

http://viewvc.jboss.org/cgi-bin/viewvc.cgi/labs/labs/jbossesb/workspace/platform/JBESB_4_2_1_SOA_4_2/product/rosetta/src/org/jboss/internal/soa/esb/dependencies/H2Database.java?r1=20698&r2=20697&pathrev=20698

There was a miscommunication between Trev and myself, none of the changes associated with this merge were pulled into the build.

Verified resolved in CP02 CR4 build.