<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
        <table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
                <tbody>
                        <tr>
                                <td>
                                        <table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
                                                <tbody>
                                                        <tr>
                                                                <td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
                                                                        <h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
                                                                        <!-- To have a header image/logo replace the name below with your img tag -->
                                                                        <!-- Email clients will render the images when the message is read so any image -->
                                                                        <!-- must be made available on a public server, so that all recipients can load the image. -->
                                                                        <a href="https://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
                                                                </td>
                                                        </tr>
                                                        <tr>
                                                                <td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Cannot connect to mySql in Jboss 5 after changing from hsqldb to mysql
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/arturo_corona">arturo corona</a> in <i>Datasource Configuration</i> - <a href="https://community.jboss.org/message/723638#723638">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>I am trying to run the EJB in action  Chapter 2 application. </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I want to use <strong>mySql</strong> database instead of the default <strong>hsqldb.  </strong>I have changed the JBOSS 5 configuration to use mySql.  I have not succeed in getting the ear file deployed.  I can't connect to the database.</p><p>The first error I see in the server log is : </p><p>     </p><p>     12:40:59,456 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null</p><p>     org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Access is denied)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>The database is : <strong>localDB</strong>, the userid id :<strong> SA</strong>  the password is : <strong>password</strong></p><p>I have riewed the login and password I submit and it looks fine. I have tweaked the files I thought I needed to changed but I can't progress.</p><p>I build the ear file with apache ant.  </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Any advice would be welcome as I've spent about 9 hours trying tp get this to work.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I have pasted at the bottom of this post the server log.  I have pasted immediatedly below this sentence the files I modified:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><strong style="color: #333333;">     msSQL-ds.xml</strong></p><p><strong style="color: #333333;">     login_config.xml</strong></p><p><strong style="color: #333333;">     Messaging-jboss-beans.xml</strong></p><p><strong style="color: #333333;">     mysql-persistence-service.xml  (I created and use this file instead of  hsqldb-persistence-service.xml)</strong></p><p><strong style="color: #333333;">     persistence.xml</strong></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="color: #ff0000;"><strong>persistence.xml</strong></span></p><p><persistence xmlns="<a class="jive-link-external-small" href="http://java.sun.com/xml/ns/persistence">http://java.sun.com/xml/ns/persistence</a>"</p><p> xmlns:xsi="<a class="jive-link-external-small" href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>"</p><p> xsi:schemaLocation="<a class="jive-link-external-small" href="http://java.sun.com/xml/ns/persistence">http://java.sun.com/xml/ns/persistence</a> <a class="jive-link-external-small" href="http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd</a>"</p><p> version="1.0"></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p> <persistence-unit name="actionBazaar"></p><p>  <jta-data-source>java:/MySqlDS</jta-data-source></p><p>  <properties></p><p>   <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect" /></p><p>   <property name="hibernate.hbm2ddl.auto" value="update" /></p><p>  </properties></p><p> </persistence-unit></p><p></persistence></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="color: #ff0000;"><strong>msSQL-ds.xml</strong></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><?xml version="1.0" encoding="UTF-8"?></p><p><br/><datasources><br/> <local-tx-datasource><br/>  <jndi-name>MySqlDS</jndi-name><br/>   <br/>   <connection-url>jdbc:mysql://localhost:3306/localDB</connection-url><br/>    <driver-class>com.mysql.jdbc.Driver</driver-class><br/>  <user-name>SA</user-name><br/>  <password>password</password><br/>  <min-pool-size>5</min-pool-size><br/>  <max-pool-size>20</max-pool-size><br/>  <idle-timeout-minutes>5</idle-timeout-minutes></p><p> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name><br/> <metadata><br/>  <type-mapping>mySQL</type-mapping><br/> </metadata><br/> </local-tx-datasource><br/></datasources></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="color: #ff0000;"><strong>login_config.xml</strong></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><?xml version='1.0'?></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><policy><br/>  <application-policy name="client-login"><br/>    <authentication><br/>      <login-module code="org.jboss.security.ClientLoginModule"<br/>        flag="required"><br/>         <!-- Any existing security context will be restored on logout --><br/>         <module-option name="restore-login-identity">true</module-option><br/>      </login-module><br/>    </authentication><br/>  </application-policy></p><p>  <!-- Security domains for testing new jca framework --><br/>  <application-policy name="HsqlDbRealm"><br/>    <authentication><br/>      <login-module code="org.jboss.resource.security.ConfiguredIdentityLoginModule"<br/>        flag="required"><br/>        <module-option name="principal">SA</module-option><br/>        <module-option name="userName">SA</module-option><br/>        <module-option name="password">password</module-option><br/>        <module-option name="managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=DefaultDS</module-option><br/>      </login-module><br/>    </authentication><br/>  </application-policy></p><p><span style="color: #ff0000;"><strong><!-- to use mySQL database  --></strong></span><br/><span style="color: #ff0000;"><strong> <application-policy name = "MySqlDbRealm"></strong></span><br/><span style="color: #ff0000;"><strong>  <authentication></strong></span><br/><span style="color: #ff0000;"><strong>  <login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule" flag = "required"></strong></span><br/><span style="color: #ff0000;"><strong>   <module-option name = "principal">SA</module-option></strong></span><br/><span style="color: #ff0000;"><strong>   <module-option name = "userName">SA</module-option></strong></span><br/><span style="color: #ff0000;"><strong>   <module-option name ="password">password</module-option></strong></span><br/><span style="color: #ff0000;"><strong>   <module-option name = "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=MySqlDS</module-option></strong></span><br/><span style="color: #ff0000;"><strong>  </login-module></strong></span><br/><span style="color: #ff0000;"><strong>  </authentication></strong></span><br/><span style="color: #ff0000;"><strong> </application-policy></strong></span></p><p>  <application-policy name="JmsXARealm"><br/>    <authentication><br/>      <login-module code="org.jboss.resource.security.ConfiguredIdentityLoginModule"<br/>        flag="required"><br/>        <module-option name="principal">guest</module-option><br/>        <module-option name="userName">guest</module-option><br/>        <module-option name="password">guest</module-option><br/>        <module-option name="managedConnectionFactoryName">jboss.jca:service=TxCM,name=JmsXA</module-option><br/>      </login-module><br/>    </authentication><br/>  </application-policy></p><p>  <application-policy name="jmx-console"><br/>    <authentication><br/>      <login-module code="org.jboss.security.auth.spi.UsersRolesLoginModule"<br/>        flag="required"><br/>        <module-option name="usersProperties">props/jmx-console-users.properties</module-option><br/>        <module-option name="rolesProperties">props/jmx-console-roles.properties</module-option><br/>      </login-module><br/>    </authentication><br/>  </application-policy></p><p>  <!-- A template configuration for the web-console web application. This<br/>    defaults to the UsersRolesLoginModule the same as other and should be<br/>    changed to a stronger authentication mechanism as required.<br/>  --><br/>  <application-policy name="web-console"><br/>    <authentication><br/>      <login-module code="org.jboss.security.auth.spi.UsersRolesLoginModule"<br/>        flag="required"><br/>        <module-option name="usersProperties">web-console-users.properties</module-option><br/>        <module-option name="rolesProperties">web-console-roles.properties</module-option><br/>      </login-module><br/>    </authentication><br/>  </application-policy></p><p>  <application-policy name="JBossWS"><br/>    <authentication><br/>      <login-module code="org.jboss.security.auth.spi.UsersRolesLoginModule"<br/>        flag="required"><br/>        <module-option name="usersProperties">props/jbossws-users.properties</module-option><br/>        <module-option name="rolesProperties">props/jbossws-roles.properties</module-option><br/>        <module-option name="unauthenticatedIdentity">anonymous</module-option><br/>      </login-module><br/>    </authentication><br/>  </application-policy></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><br/>  <application-policy name="other"><br/>    <authentication><br/>      <login-module code="org.jboss.security.auth.spi.UsersRolesLoginModule"<br/>        flag="required"/><br/>    </authentication><br/>  </application-policy></p><p></policy></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><strong style="color: red;">mysql-persistence-service.xml</strong>  </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><?xml version="1.0" encoding="UTF-8"?></p><p><!--<br/>     Hypersonic persistence deployment descriptor.<br/>     <br/>     DO NOT USE HYPERSONIC IN PRODUCTION or in a clustered environment- Hypersonic does not have transaction isolation</p><p>     $Id: hsqldb-persistence-service.xml 3339 2007-11-16 20:48:08Z <a class="jive-link-email-small" href="mailto:clebert.suconic@jboss.com">clebert.suconic@jboss.com</a> $<br/> --></p><p><server></p><p>   <!-- Persistence Manager MBean configuration<br/>       ======================================= --><br/>   <br/>   <mbean code="org.jboss.messaging.core.jmx.JDBCPersistenceManagerService"<br/>      name="jboss.messaging:service=PersistenceManager"<br/>      xmbean-dd="xmdesc/JDBCPersistenceManager-xmbean.xml"><br/>      <br/>      <depends>jboss.jca:service=DataSourceBinding,name=MySqlDS</depends><br/>      <br/>      <depends optional-attribute-name="TransactionManager">jboss:service=TransactionManager</depends><br/>            <br/>      <!-- The datasource to use for the persistence manager --><br/>                                <br/>   <span style="color: #ff0000;"><strong>   <attribute name="DataSource">java:/MySqlDS</attribute></strong></span><br/>      <br/>      <!-- If true will attempt to create tables and indexes on every start-up --><br/>                  <br/>      <attribute name="CreateTablesOnStartup">false</attribute><br/>      <br/>      <!-- If true then will use JDBC batch updates --><br/>                 <br/>      <attribute name="UsingBatchUpdates">false</attribute><br/>      <br/>      <!-- The maximum number of parameters to include in a prepared statement -->            <br/>      <br/>      <attribute name="MaxParams">500</attribute><br/>   </mbean></p><p>   <!-- Messaging Post Office MBean configuration<br/>        ========================================= --><br/>   <br/>   <mbean code="org.jboss.messaging.core.jmx.MessagingPostOfficeService"<br/>      name="jboss.messaging:service=PostOffice"      <br/>      xmbean-dd="xmdesc/MessagingPostOffice-xmbean.xml"><br/>            <br/>      <depends optional-attribute-name="ServerPeer">jboss.messaging:service=ServerPeer</depends><br/>      <br/>      <depends>jboss.jca:service=DataSourceBinding,name=MySqlDS</depends><br/>      <br/>      <depends optional-attribute-name="TransactionManager">jboss:service=TransactionManager</depends><br/>      <br/>      <!-- The name of the post office -->      <br/>                 <br/>      <attribute name="PostOfficeName">JMS post office</attribute><br/>      <br/>      <!-- The datasource used by the post office to access it's binding information -->                       <br/>      <br/>      <attribute name="DataSource">java:/MySqlDS</attribute><br/>      <br/>      <!-- If true will attempt to create tables and indexes on every start-up --><br/>                        <br/>      <attribute name="CreateTablesOnStartup">true</attribute><br/>      <br/>      <!-- This post office is NON CLUSTERED - do not use clustering with Hypersonic!! --><br/>      <br/>      <attribute name="Clustered">false</attribute><br/>   </mbean></p><p>   <!-- Messaging JMS User Manager MBean config<br/>        ======================================= --><br/>   <br/>   <mbean code="org.jboss.jms.server.plugin.JDBCJMSUserManagerService"<br/>      name="jboss.messaging:service=JMSUserManager"<br/>      xmbean-dd="xmdesc/JMSUserManager-xmbean.xml"><br/>      <br/>      <depends>jboss.jca:service=DataSourceBinding,name=MySqlDS</depends><br/>      <br/>      <depends optional-attribute-name="TransactionManager">jboss:service=TransactionManager</depends><br/>      <br/>      <attribute name="DataSource">java:/MySqlDS</attribute><br/>      <br/>      <attribute name="CreateTablesOnStartup">false</attribute><br/>      <br/>      <attribute name="SqlProperties"><![CDATA[<br/>POPULATE.TABLES.1  = INSERT INTO JBM_USER (USER_ID, PASSWD) VALUES ('guest', 'guest');<br/>POPULATE.TABLES.2  = INSERT INTO JBM_USER (USER_ID, PASSWD) VALUES ('j2ee', 'j2ee');<br/>POPULATE.TABLES.3  = INSERT INTO JBM_USER (USER_ID, PASSWD, CLIENTID) VALUES ('john', 'needle', 'DurableSubscriberExample');<br/>POPULATE.TABLES.4  = INSERT INTO JBM_USER (USER_ID, PASSWD) VALUES ('nobody', 'nobody');<br/>POPULATE.TABLES.5  = INSERT INTO JBM_USER (USER_ID, PASSWD) VALUES ('dynsub', 'dynsub');<br/>POPULATE.TABLES.6  = INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES ('guest','guest');<br/>POPULATE.TABLES.7  = INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES ('j2ee','guest');<br/>POPULATE.TABLES.8  = INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES ('john','guest');<br/>POPULATE.TABLES.9  = INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES ('subscriber','john');<br/>POPULATE.TABLES.10 = INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES ('publisher','john');<br/>POPULATE.TABLES.11 = INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES ('publisher','dynsub');<br/>POPULATE.TABLES.12 = INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES ('durpublisher','john');<br/>POPULATE.TABLES.13 = INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES ('durpublisher','dynsub');<br/>POPULATE.TABLES.14 = INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES ('noacc','nobody');<br/>      ]]></attribute><br/>   </mbean></p><p></server></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="color: #ff0000;"><strong>messaging-jboss-beans.xml</strong></span></p><p><?xml version="1.0" encoding="UTF-8"?></p><p><!--<br/>    Messaging beans<br/>    $Id: messaging-beans.xml 68282 2007-12-14 13:43:52Z <a class="jive-link-email-small" href="mailto:alex.loubyansky@jboss.com">alex.loubyansky@jboss.com</a> $<br/>--><br/><deployment xmlns="urn:jboss:bean-deployer:2.0"></p><p>   <!-- messaging application-policy definition --><br/>   <application-policy xmlns="urn:jboss:security-beans:1.0" name="messaging"><br/>      <authentication><br/>         <login-module code="org.jboss.security.auth.spi.DatabaseServerLoginModule" flag="required"><br/>            <module-option name="unauthenticatedIdentity">guest</module-option><br/>            <module-option name="dsJndiName">java:/DefaultDS</module-option><br/>            <module-option name="principalsQuery">SELECT PASSWD FROM JBM_USER WHERE USER_ID=?</module-option><br/>            <module-option name="rolesQuery">SELECT ROLE_ID, 'Roles' FROM JBM_ROLE WHERE USER_ID=?</module-option><br/>         </login-module><br/>      </authentication><br/>   </application-policy></p><p>   <bean name="SecurityStore" class="org.jboss.jms.server.jbosssx.JBossASSecurityMetadataStore"><br/>      <!-- default security configuration --><br/>      <property name="defaultSecurityConfig"><br/>         <![CDATA[<br/>            <security><br/>               <role name="guest" read="true" write="true" create="true"/><br/>            </security><br/>         ]]><br/>      </property><br/>      <property name="suckerPassword">CHANGE ME!!</property><br/>      <property name="securityDomain">messaging</property><br/>      <property name="securityManagement"><inject bean="JNDIBasedSecurityManagement"/></property><br/>      <!-- @JMX annotation to export the management view of this bean --><br/>      <annotation>@org.jboss.aop.microcontainer.aspects.jmx.JMX(name="jboss.messaging:service=SecurityStore",exposedInterface=org.jboss.jms.server.jbosssx.JBossASSecurityMetadataStoreMBean.class)</annotation><br/>   </bean></p><p>   <bean name="QueueTemplate" class="org.jboss.profileservice.management.templates.JmsDestinationTemplate"><br/>      <property name="info"><inject bean="QueueTemplateInfo"/></property><br/>   </bean><br/>   <bean name="QueueTemplateInfo"<br/>      class="org.jboss.profileservice.management.templates.JmsDestinationTemplateInfo"><br/>      <constructor><br/>         <parameter>QueueTemplate</parameter><br/>         <parameter>A template for JMS queue *-service.xml deployments</parameter><br/>         <parameter>queue</parameter><br/>      </constructor><br/>   </bean></p><p>   <bean name="TopicTemplate" class="org.jboss.profileservice.management.templates.JmsDestinationTemplate"><br/>      <property name="info"><inject bean="TopicTemplateInfo"/></property><br/>   </bean><br/>   <bean name="TopicTemplateInfo"<br/>      class="org.jboss.profileservice.management.templates.JmsDestinationTemplateInfo"><br/>      <constructor><br/>         <parameter>TopicTemplate</parameter><br/>         <parameter>A template for JMS topic *-service.xml deployments</parameter><br/>         <parameter>topic</parameter><br/>      </constructor><br/>   </bean></p><p>  <bean name="QueueMODefinition" class="org.jboss.jms.server.destination.QueueMODefinition"><br/>    <constructor><br/>      <parameter><inject bean="ManagedObjectFactory" /></parameter><br/>    </constructor><br/>  </bean></p><p>  <bean name="TopicMODefinition" class="org.jboss.jms.server.destination.TopicMODefinition"><br/>    <constructor><br/>      <parameter><inject bean="ManagedObjectFactory" /></parameter><br/>    </constructor><br/>  </bean></p><p></deployment></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>C:\jboss-5.0.1.GA\bin>run<br/>===============================================================================</p><p>  JBoss Bootstrap Environment</p><p>  JBOSS_HOME: c:\jboss-5.0.1.GA</p><p>  JAVA: c:\jdk1.6.0_30\bin\java</p><p>  JAVA_OPTS: -Dprogram.name=run.bat -server -Xms128m -Xmx512m -XX:MaxPermSize=256m -Dorg.jboss.resolver.warning=true -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000</p><p>  CLASSPATH: c:\jboss-5.0.1.GA\bin\run.jar</p><p>===============================================================================</p><p>12:40:43,695 INFO  [ServerImpl] Starting JBoss (Microcontainer)...<br/>12:40:43,695 INFO  [ServerImpl] Release ID: JBoss [Morpheus] 5.0.1.GA (build: SVNTag=JBoss_5_0_1_GA date=200902231221)<br/>12:40:43,695 INFO  [ServerImpl] Bootstrap URL: null<br/>12:40:43,710 INFO  [ServerImpl] Home Dir: C:\jboss-5.0.1.GA<br/>12:40:43,710 INFO  [ServerImpl] Home URL: file:/C:/jboss-5.0.1.GA/<br/>12:40:43,710 INFO  [ServerImpl] Library URL: file:/C:/jboss-5.0.1.GA/lib/<br/>12:40:43,710 INFO  [ServerImpl] Patch URL: null<br/>12:40:43,710 INFO  [ServerImpl] Common Base URL: file:/C:/jboss-5.0.1.GA/common/<br/>12:40:43,710 INFO  [ServerImpl] Common Library URL: file:/C:/jboss-5.0.1.GA/common/lib/<br/>12:40:43,710 INFO  [ServerImpl] Server Name: default<br/>12:40:43,710 INFO  [ServerImpl] Server Base Dir: C:\jboss-5.0.1.GA\server<br/>12:40:43,710 INFO  [ServerImpl] Server Base URL: file:/C:/jboss-5.0.1.GA/server/<br/>12:40:43,726 INFO  [ServerImpl] Server Config URL: file:/C:/jboss-5.0.1.GA/server/default/conf/<br/>12:40:43,726 INFO  [ServerImpl] Server Home Dir: C:\jboss-5.0.1.GA\server\default<br/>12:40:43,741 INFO  [ServerImpl] Server Home URL: file:/C:/jboss-5.0.1.GA/server/default/<br/>12:40:43,741 INFO  [ServerImpl] Server Data Dir: C:\jboss-5.0.1.GA\server\default\data<br/>12:40:43,757 INFO  [ServerImpl] Server Library URL: file:/C:/jboss-5.0.1.GA/server/default/lib/<br/>12:40:43,757 INFO  [ServerImpl] Server Log Dir: C:\jboss-5.0.1.GA\server\default\log<br/>12:40:43,757 INFO  [ServerImpl] Server Native Dir: C:\jboss-5.0.1.GA\server\default\tmp\native<br/>12:40:43,773 INFO  [ServerImpl] Server Temp Dir: C:\jboss-5.0.1.GA\server\default\tmp<br/>12:40:43,773 INFO  [ServerImpl] Server Temp Deploy Dir: C:\jboss-5.0.1.GA\server\default\tmp\deploy<br/>12:40:44,209 INFO  [ServerImpl] Starting Microcontainer, bootstrapURL=file:/C:/jboss-5.0.1.GA/server/default/conf/bootstrap.xml<br/>12:40:44,506 INFO  [VFSCacheFactory] Initializing VFSCache [org.jboss.virtual.plugins.cache.CombinedVFSCache]<br/>12:40:44,506 INFO  [VFSCacheFactory] Using VFSCache [CombinedVFSCache[real-cache: null]]<br/>12:40:44,662 INFO  [CopyMechanism] VFS temp dir: C:\jboss-5.0.1.GA\server\default\tmp<br/>12:40:44,677 INFO  [ZipEntryContext] VFS force nested jars copy-mode is enabled.<br/>12:40:45,359 INFO  [ServerInfo] Java version: 1.6.0_30,Sun Microsystems Inc.<br/>12:40:45,359 INFO  [ServerInfo] Java Runtime: Java(TM) SE Runtime Environment (build 1.6.0_30-b12)<br/>12:40:45,369 INFO  [ServerInfo] Java VM: Java HotSpot(TM) 64-Bit Server VM 20.5-b03,Sun Microsystems Inc.<br/>12:40:45,379 INFO  [ServerInfo] OS-System: Windows 7 6.1,amd64<br/>12:40:45,409 INFO  [JMXKernel] Legacy JMX core initialized<br/>12:40:46,751 INFO  [ProfileServiceImpl] Loading profile: default from: <a class="jive-link-external-small" href="mailto:org.jboss.system.server.profileservice.repository.SerializableDeploymentRepository@1dc2dad7(root=C:\jboss-5.0.1.GA\server">org.jboss.system.server.profileservice.repository.SerializableDeploymentRepository@1dc2dad7(root=C:\jboss-5.0.1.GA\server</a>, key=or<br/><a class="jive-link-external-small" href="mailto:g.jboss.profileservice.spi.ProfileKey@143b82c3[domain=default,server=default,name=default">g.jboss.profileservice.spi.ProfileKey@143b82c3[domain=default,server=default,name=default</a>])<br/>12:40:46,761 INFO  [ProfileImpl] Using repository:org.jboss.system.server.profileservice.repository.SerializableDeploymentRepository@1dc2dad7(root=C:\jboss-5.0.1.GA\server, key=org.jboss.profileservic<br/><a class="jive-link-external-small" href="mailto:e.spi.ProfileKey@143b82c3[domain=default,server=default,name=default">e.spi.ProfileKey@143b82c3[domain=default,server=default,name=default</a>])<br/>12:40:46,791 INFO  [ProfileServiceImpl] Loaded profile: <a class="jive-link-external-small" href="mailto:ProfileImpl@1e35ecd{key=org.jboss.profileservice.spi.ProfileKey@143b82c3[domain=default,server=default,name=default">ProfileImpl@1e35ecd{key=org.jboss.profileservice.spi.ProfileKey@143b82c3[domain=default,server=default,name=default</a>]}<br/>12:40:47,781 INFO  [WebService] Using RMI server codebase: <a class="jive-link-external-small" href="http://127.0.0.1:8083/">http://127.0.0.1:8083/</a><br/>12:40:51,044 INFO  [NativeServerConfig] JBoss Web Services - Stack Native Core<br/>12:40:51,044 INFO  [NativeServerConfig] 3.0.5.GA<br/>12:40:54,522 INFO  [ContainerDependencyMetaData] addJndiDependency, <a class="" href="https://community.jboss.org/mailto:JndiDependencyMetaData@7d582674{jms/OrderBillingQueue">JndiDependencyMetaData@7d582674{jms/OrderBillingQueue</a>}<br/>12:40:54,553 INFO  [Ejb3DependenciesDeployer] Encountered deployment <a class="jive-link-external-small" href="mailto:AbstractVFSDeploymentContext@848954470{vfszip:/C:/jboss-5.0.1.GA/server/default/deploy/chapter2.ear/chapter2-ejb.jar/">AbstractVFSDeploymentContext@848954470{vfszip:/C:/jboss-5.0.1.GA/server/default/deploy/chapter2.ear/chapter2-ejb.jar/</a>}<br/>12:40:54,553 INFO  [Ejb3DependenciesDeployer] Encountered deployment <a class="jive-link-external-small" href="mailto:AbstractVFSDeploymentContext@848954470{vfszip:/C:/jboss-5.0.1.GA/server/default/deploy/chapter2.ear/chapter2-ejb.jar/">AbstractVFSDeploymentContext@848954470{vfszip:/C:/jboss-5.0.1.GA/server/default/deploy/chapter2.ear/chapter2-ejb.jar/</a>}<br/>12:40:56,636 INFO  [JMXConnectorServerService] JMX Connector server: service:jmx:rmi://127.0.0.1/jndi/rmi://127.0.0.1:1090/jmxconnector<br/>12:40:56,756 INFO  [MailService] Mail Service bound to java:/Mail<br/>12:40:57,546 WARN  [JBossASSecurityMetadataStore] WARNING! POTENTIAL SECURITY RISK. It has been detected that the MessageSucker component which sucks messages from one node to another has not had its<br/>password changed from the installation default. Please see the JBoss Messaging user guide for instructions on how to do this.<br/>12:40:57,556 WARN  [AnnotationCreator] No ClassLoader provided, using TCCL: org.jboss.managed.api.annotation.ManagementComponent<br/>12:40:57,656 INFO  [TransactionManagerService] JBossTS Transaction Service (JTA version) - JBoss Inc.<br/>12:40:57,666 INFO  [TransactionManagerService] Setting up property manager MBean and JMX layer<br/>12:40:57,806 INFO  [TransactionManagerService] Initializing recovery manager<br/>12:40:57,886 INFO  [TransactionManagerService] Recovery manager configured<br/>12:40:57,886 INFO  [TransactionManagerService] Binding TransactionManager JNDI Reference<br/>12:40:57,906 INFO  [TransactionManagerService] Starting transaction recovery manager<br/>12:40:58,186 INFO  [Http11Protocol] Initializing Coyote HTTP/1.1 on http-127.0.0.1-8080<br/>12:40:58,196 INFO  [AjpProtocol] Initializing Coyote AJP/1.3 on ajp-127.0.0.1-8009<br/>12:40:58,196 INFO  [StandardService] Starting service jboss.web<br/>12:40:58,206 INFO  [StandardEngine] Starting Servlet Engine: JBoss Web/2.1.2.GA<br/>12:40:58,246 INFO  [Catalina] Server startup in 101 ms<br/>12:40:58,266 INFO  [TomcatDeployment] deploy, ctxPath=/jbossws<br/>12:40:58,606 INFO  [TomcatDeployment] deploy, ctxPath=/web-console<br/>12:40:58,796 INFO  [TomcatDeployment] deploy, ctxPath=/invoker<br/>12:40:58,886 INFO  [RARDeployment] Required license terms exist, view vfszip:/C:/jboss-5.0.1.GA/server/default/deploy/jboss-local-jdbc.rar/META-INF/ra.xml<br/>12:40:58,906 INFO  [RARDeployment] Required license terms exist, view vfszip:/C:/jboss-5.0.1.GA/server/default/deploy/jboss-xa-jdbc.rar/META-INF/ra.xml<br/>12:40:58,926 INFO  [RARDeployment] Required license terms exist, view vfszip:/C:/jboss-5.0.1.GA/server/default/deploy/jms-ra.rar/META-INF/ra.xml<br/>12:40:58,936 INFO  [RARDeployment] Required license terms exist, view vfszip:/C:/jboss-5.0.1.GA/server/default/deploy/mail-ra.rar/META-INF/ra.xml<br/>12:40:58,956 INFO  [RARDeployment] Required license terms exist, view vfszip:/C:/jboss-5.0.1.GA/server/default/deploy/quartz-ra.rar/META-INF/ra.xml<br/>12:40:59,016 INFO  [SimpleThreadPool] Job execution threads will use class loader of thread: main<br/>12:40:59,036 INFO  [QuartzScheduler] Quartz Scheduler v.1.5.2 created.<br/>12:40:59,046 INFO  [RAMJobStore] RAMJobStore initialized.<br/>12:40:59,066 INFO  [StdSchedulerFactory] Quartz scheduler 'DefaultQuartzScheduler' initialized from default resource file in Quartz package: 'quartz.properties'<br/>12:40:59,076 INFO  [StdSchedulerFactory] Quartz scheduler version: 1.5.2<br/>12:40:59,086 INFO  [QuartzScheduler] Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started.<br/>12:40:59,416 INFO  [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 'java:DefaultDS'<br/>12:40:59,456 WARN  [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null<br/>org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Access is denied)<br/>        at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:225)<br/>        at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:195)<br/>        at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:611)<br/>        at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:257)<br/>        at org.jboss.resource.coe.connectnnectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:607)<br/>        at org.jboss.resourcionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)<br/>        at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:381)<br/>        at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)<br/>        at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)<br/>        at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)<br/>        at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.tableExists(SQLUtil.java:1037)<br/>        at org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory.createTableIfNotExists(HiLoKeyGeneratorFactory.java:363)<br/>        at org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory.initSequence(HiLoKeyGeneratorFactory.java:304)<br/>        at org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory.startService(HiLoKeyGeneratorFactory.java:278)<br/>        at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:376)<br/>        at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:322)<br/>        at sun.reflect.GeneratedMethodAccessor107.invoke(Unknown Source)<br/>        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br/>        at java.lang.reflect.Method.invoke(Method.java:597)<br/>        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)<br/>        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)<br/>        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)<br/>        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)<br/>        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)<br/>        at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:189)<br/>        at $Proxy36.start(Unknown Source)<br/>        at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)<br/>        at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)<br/>        at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)<br/>        at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)<br/>        at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)<br/>        at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)<br/>        at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:286)<br/>        at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)<br/>        at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)<br/>        at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)<br/>        at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)<br/>        at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)<br/>        at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)<br/>        at org.jboss.system.ServiceController.doChange(ServiceController.java:688)<br/>        at org.jboss.system.ServiceController.start(ServiceController.java:460)<br/>        at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163)<br/>        at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99)<br/>        at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)<br/>        at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)<br/>        at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)<br/>        at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)<br/>        at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)<br/>        at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)<br/>        at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1178)<br/>        at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)<br/>        at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)<br/>        at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)<br/>        at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)<br/>        at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)<br/>        at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)<br/>        at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)<br/>        at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)<br/>        at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781)<br/>        at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:698)<br/>        at org.jboss.system.server.profileservice.ProfileServiceBootstrap.loadProfile(ProfileServiceBootstrap.java:304)<br/>        at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:205)<br/>        at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:405)<br/>        at org.jboss.Main.boot(Main.java:209)<br/>        at org.jboss.Main$1.run(Main.java:547)<br/>        at java.lang.Thread.run(Thread.java:662)<br/>Caused by: java.sql.SQLException: Access is denied<br/>        at org.hsqldb.jdbc.Util.sqlException(Unknown Source)<br/>        at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)<br/>        at org.hsqldb.jdbcDriver.getConnection(Unknown Source)<br/>        at org.hsqldb.jdbcDriver.connect(Unknown Source)<br/>        at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:207)<br/>        ... 65 more<br/>12:40:59,996 ERROR [AbstractKernelController] Error installing to Start: name=jboss:service=KeyGeneratorFactory,type=HiLo state=Create mode=Manual requiredState=Installed<br/>org.jboss.deployment.DeploymentException: Error while checking if table aleady exists HILOSEQUENCES<br/>        at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.tableExists(SQLUtil.java:1082)<br/>        at org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory.createTableIfNotExists(HiLoKeyGeneratorFactory.java:363)<br/>        at org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory.initSequence(HiLoKeyGeneratorFactory.java:304)<br/>        at org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory.startService(HiLoKeyGeneratorFactory.java:278)<br/>        at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:376)<br/>        at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:322)<br/>        at sun.reflect.GeneratedMethodAccessor107.invoke(Unknown Source)<br/>        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br/>        at java.lang.reflect.Method.invoke(Method.java:597)<br/>        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)<br/>        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)<br/>        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)<br/>        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)<br/>        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)<br/>        at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:189)<br/>        at $Proxy36.start(Unknown Source)<br/>        at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)<br/>        at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)<br/>        at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)<br/>        at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)<br/>        at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)<br/>        at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)<br/>        at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:286)<br/>        at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)<br/>        at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)<br/>        at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)<br/>        at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)<br/>        at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)<br/>        at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)<br/>        at org.jboss.system.ServiceController.doChange(ServiceController.java:688)<br/>        at org.jboss.system.ServiceController.start(ServiceController.java:460)<br/>        at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163)<br/>        at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99)<br/>        at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)<br/>        at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)<br/>        at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)<br/>        at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)<br/>        at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)<br/>        at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)<br/>        at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1178)<br/>        at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)<br/>        at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)<br/>        at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)<br/>        at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)<br/>        at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)<br/>        at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)<br/>        at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)<br/>        at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)<br/>        at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781)<br/>        at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:698)<br/>        at org.jboss.system.server.profileservice.ProfileServiceBootstrap.loadProfile(ProfileServiceBootstrap.java:304)<br/>        at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:205)<br/>        at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:405)<br/>        at org.jboss.Main.boot(Main.java:209)<br/>        at org.jboss.Main$1.run(Main.java:547)<br/>        at java.lang.Thread.run(Thread.java:662)<br/>Caused by: org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: Access is denied); - nested throwable: (org.jboss.resource.JBossResourceException<br/>: Could not create connection; - nested throwable: (java.sql.SQLException: Access is denied))<br/>        at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)<br/>        at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.tableExists(SQLUtil.java:1037)<br/>        ... 55 more<br/>Caused by: org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Access is denied)<br/>        at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:225)<br/>        at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:195)<br/>        at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:611)<br/>        at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:257)<br/>        at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:607)<br/>        at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)<br/>        at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:381)<br/>        at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)<br/>        at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)<br/>        at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)<br/>        ... 56 more<br/>Caused by: java.sql.SQLException: Access is denied<br/>        at org.hsqldb.jdbc.Util.sqlException(Unknown Source)<br/>        at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)<br/>        at org.hsqldb.jdbcDriver.getConnection(Unknown Source)<br/>        at org.hsqldb.jdbcDriver.connect(Unknown Source)<br/>        at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:207)<br/>        ... 65 more<br/>12:41:00,436 INFO  [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=MySqlDS' to JNDI name 'java:MySqlDS'<br/>12:41:00,606 WARN  [JDBCPersistenceManager]</p><p>JBoss Messaging Warning: DataSource connection transaction isolation should be READ_COMMITTED, but it is currently REPEATABLE_READ.<br/>                         Using an isolation level less strict than READ_COMMITTED may lead to data consistency problems.<br/>                         Using an isolation level more strict than READ_COMMITTED may lead to deadlock.</p><p>12:41:00,756 INFO  [ServerPeer] JBoss Messaging 1.4.1.GA server [0] started<br/>12:41:00,786 WARN  [JDBCSupport] SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:1<br/>com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CONDIT<br/>ION, SELECTOR, CHANNEL_ID, CLUSTERED, ALL_NODES FROM JBM_POSTOFFICE WHERE ' at line 1<br/>        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<br/>        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)<br/>        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)<br/>        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)<br/>        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)<br/>        at com.mysql.jdbc.Util.getInstance(Util.java:386)<br/>        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)<br/>        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)<br/>        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)<br/>        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)<br/>        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)<br/>        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)<br/>        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)<br/>        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2293)<br/>        at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)<br/>        at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice$1LoadBindings.doTransaction(MessagingPostOffice.java:2487)<br/>        at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice$1LoadBindings.doTransaction(MessagingPostOffice.java:2470)<br/>        at org.jboss.messaging.core.impl.JDBCSupport$JDBCTxRunner.execute(JDBCSupport.java:394)<br/>        at org.jboss.messaging.core.impl.JDBCSupport$JDBCTxRunner.executeWithRetry(JDBCSupport.java:416)<br/>        at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.getBindingsFromStorage(MessagingPostOffice.java:2538)<br/>        at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.start(MessagingPostOffice.java:353)<br/>        at org.jboss.messaging.core.jmx.MessagingPostOfficeService.startService(MessagingPostOfficeService.java:456)<br/>        at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:376)<br/>        at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:269)<br/>        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br/>        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br/>        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br/>        at java.lang.reflect.Method.invoke(Method.java:597)<br/>        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)<br/>        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)<br/>        at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:138)<br/>        at org.jboss.mx.server.Invocation.invoke(Invocation.java:90)<br/>        at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:140)<br/>        at org.jboss.mx.server.Invocation.invoke(Invocation.java:90)<br/>        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)<br/>        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)<br/>        at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:206)<br/>        at $Proxy36.start(Unknown Source)<br/>        at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)<br/>        at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)<br/>        at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)<br/>        at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)<br/>        at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)<br/>        at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)<br/>        at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:286)<br/>        at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)<br/>        at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)<br/>        at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)<br/>        at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)<br/>        at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)<br/>        at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)<br/>        at org.jboss.system.ServiceController.doChange(ServiceController.java:688)<br/>        at org.jboss.system.ServiceController.start(ServiceController.java:460)<br/>        at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163)<br/>        at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99)<br/>        at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)<br/>        at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)<br/>        at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)<br/>        at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)<br/>        at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)<br/>        at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)<br/>        at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1178)<br/>        at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)<br/>        at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)<br/>        at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)<br/>        at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)<br/>        at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)<br/>        at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)<br/>        at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)<br/>        at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)<br/>        at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781)<br/>        at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:698)<br/>        at org.jboss.system.server.profileservice.ProfileServiceBootstrap.loadProfile(ProfileServiceBootstrap.java:304)<br/>        at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:205)<br/>        at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:405)<br/>        at org.jboss.Main.boot(Main.java:209)<br/>        at org.jboss.Main$1.run(Main.java:547)<br/>        at java.lang.Thread.run(Thread.java:662)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><strong style="color: #ff0000;">****************** deleted some log output from here ******************</strong></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>12:41:09,670 INFO  [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name 'java:JmsXA'<br/>12:41:09,710 INFO  [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=manningDS' to JNDI name 'java:manningDS'<br/>12:41:09,750 INFO  [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=OracleDS' to JNDI name 'java:OracleDS'<br/>12:41:09,770 INFO  [TomcatDeployment] deploy, ctxPath=/<br/>12:41:09,820 INFO  [TomcatDeployment] deploy, ctxPath=/jmx-console<br/>12:41:09,940 INFO  [TomcatDeployment] deploy, ctxPath=/murachch14email<br/>12:41:10,640 INFO  [JBossASKernel] Created KernelDeployment for: chapter2-ejb.jar<br/>12:41:10,640 INFO  [JBossASKernel] installing bean: jboss.j2ee:ear=chapter2.ear,jar=chapter2-ejb.jar,name=OrderBillingMDB,service=EJB3<br/>12:41:10,640 INFO  [JBossASKernel]   with dependencies:<br/>12:41:10,640 INFO  [JBossASKernel]   and demands:<br/>12:41:10,640 INFO  [JBossASKernel]      jboss.ejb:service=EJBTimerService<br/>12:41:10,640 INFO  [JBossASKernel]      persistence.unit:unitName=chapter2.ear/chapter2-ejb.jar#actionBazaar<br/>12:41:10,640 INFO  [JBossASKernel]   and supplies:<br/>12:41:10,640 INFO  [JBossASKernel]      jndi:null<br/>12:41:10,650 INFO  [JBossASKernel]      Class:javax.jms.MessageListener<br/>12:41:10,650 INFO  [JBossASKernel] Added bean(jboss.j2ee:ear=chapter2.ear,jar=chapter2-ejb.jar,name=OrderBillingMDB,service=EJB3) to KernelDeployment of: chapter2-ejb.jar<br/>12:41:10,650 INFO  [JBossASKernel] installing bean: jboss.j2ee:ear=chapter2.ear,jar=chapter2-ejb.jar,name=PlaceBid,service=EJB3<br/>12:41:10,650 INFO  [JBossASKernel]   with dependencies:<br/>12:41:10,650 INFO  [JBossASKernel]   and demands:<br/>12:41:10,650 INFO  [JBossASKernel]      jboss.ejb:service=EJBTimerService<br/>12:41:10,650 INFO  [JBossASKernel]      persistence.unit:unitName=chapter2.ear/chapter2-ejb.jar#actionBazaar<br/>12:41:10,650 INFO  [JBossASKernel]   and supplies:<br/>12:41:10,650 INFO  [JBossASKernel]      jndi:chapter2/PlaceBid/remote-com.ejb3inaction.actionbazaar.buslogic.PlaceBid<br/>12:41:10,650 INFO  [JBossASKernel]      jndi:chapter2/PlaceBid/remote<br/>12:41:10,650 INFO  [JBossASKernel]      Class:com.ejb3inaction.actionbazaar.buslogic.PlaceBid<br/>12:41:10,650 INFO  [JBossASKernel] Added bean(jboss.j2ee:ear=chapter2.ear,jar=chapter2-ejb.jar,name=PlaceBid,service=EJB3) to KernelDeployment of: chapter2-ejb.jar<br/>12:41:10,650 INFO  [JBossASKernel] installing bean: jboss.j2ee:ear=chapter2.ear,jar=chapter2-ejb.jar,name=PlaceOrderBean,service=EJB3<br/>12:41:10,660 INFO  [JBossASKernel]   with dependencies:<br/>12:41:10,660 INFO  [JBossASKernel]   and demands:<br/>12:41:10,660 INFO  [JBossASKernel]      jboss.ejb:service=EJBTimerService<br/>12:41:10,660 INFO  [JBossASKernel]      persistence.unit:unitName=chapter2.ear/chapter2-ejb.jar#actionBazaar<br/>12:41:10,660 INFO  [JBossASKernel]   and supplies:<br/>12:41:10,660 INFO  [JBossASKernel]      jndi:chapter2/PlaceOrderBean/remote<br/>12:41:10,660 INFO  [JBossASKernel]      jndi:chapter2/PlaceOrderBean/remote-com.ejb3inaction.actionbazaar.buslogic.PlaceOrder<br/>12:41:10,660 INFO  [JBossASKernel]      Class:com.ejb3inaction.actionbazaar.buslogic.PlaceOrder<br/>12:41:10,660 INFO  [JBossASKernel] Added bean(jboss.j2ee:ear=chapter2.ear,jar=chapter2-ejb.jar,name=PlaceOrderBean,service=EJB3) to KernelDeployment of: chapter2-ejb.jar<br/>12:41:10,710 INFO  [PersistenceUnitDeployment] Starting persistence unit persistence.unit:unitName=chapter2.ear/chapter2-ejb.jar#actionBazaar<br/>12:41:10,756 INFO  [Version] Hibernate Annotations 3.4.0.GA<br/>12:41:10,772 INFO  [Environment] Hibernate 3.3.1.GA<br/>12:41:10,788 INFO  [Environment] hibernate.properties not found<br/>12:41:10,788 INFO  [Environment] Bytecode provider name : javassist<br/>12:41:10,788 INFO  [Environment] using JDK 1.4 java.sql.Timestamp handling<br/>12:41:10,850 INFO  [Version] Hibernate Commons Annotations 3.1.0.GA<br/>12:41:10,850 INFO  [Version] Hibernate EntityManager 3.4.0.GA<br/>12:41:10,897 WARN  [Ejb3Configuration] Persistence provider caller does not implement the EJB3 spec correctly. PersistenceUnitInfo.getNewTempClassLoader() is null.<br/>12:41:10,959 INFO  [AnnotationBinder] Binding entity from annotated class: com.ejb3inaction.actionbazaar.persistence.Bid<br/>12:41:11,022 INFO  [EntityBinder] Bind entity com.ejb3inaction.actionbazaar.persistence.Bid on table BIDS<br/>12:41:11,068 INFO  [AnnotationBinder] Binding entity from annotated class: com.ejb3inaction.actionbazaar.persistence.Order<br/>12:41:11,068 INFO  [EntityBinder] Bind entity com.ejb3inaction.actionbazaar.persistence.Order on table ORDERS<br/>12:41:11,084 INFO  [Version] Hibernate Validator 3.1.0.GA<br/>12:41:11,115 INFO  [HibernateSearchEventListenerRegister] Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled.<br/>12:41:11,193 INFO  [ConnectionProviderFactory] Initializing connection provider: org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider<br/>12:41:11,209 INFO  [InjectedDataSourceConnectionProvider] Using provided datasource<br/>12:41:11,209 INFO  [SettingsFactory] RDBMS: MySQL, version: 5.5.19<br/>12:41:11,209 INFO  [SettingsFactory] JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.1.18 ( Revision: <a class="jive-link-email-small" href="mailto:tonci.grgin@oracle.com-20110930151701-jfj14ddfq48ifkfq">tonci.grgin@oracle.com-20110930151701-jfj14ddfq48ifkfq</a> )<br/>12:41:11,224 INFO  [Dialect] Using dialect: org.hibernate.dialect.MySQLDialect<br/>12:41:11,240 INFO  [TransactionFactoryFactory] Transaction strategy: org.hibernate.ejb.transaction.JoinableCMTTransactionFactory<br/>12:41:11,240 INFO  [TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup<br/>12:41:11,240 INFO  [TransactionManagerLookupFactory] instantiated TransactionManagerLookup<br/>12:41:11,240 INFO  [SettingsFactory] Automatic flush during beforeCompletion(): disabled<br/>12:41:11,240 INFO  [SettingsFactory] Automatic session close at end of transaction: disabled<br/>12:41:11,240 INFO  [SettingsFactory] JDBC batch size: 15<br/>12:41:11,240 INFO  [SettingsFactory] JDBC batch updates for versioned data: disabled<br/>12:41:11,240 INFO  [SettingsFactory] Scrollable result sets: enabled<br/>12:41:11,256 INFO  [SettingsFactory] JDBC3 getGeneratedKeys(): enabled<br/>12:41:11,256 INFO  [SettingsFactory] Connection release mode: auto<br/>12:41:11,256 INFO  [SettingsFactory] Maximum outer join fetch depth: 2<br/>12:41:11,256 INFO  [SettingsFactory] Default batch fetch size: 1<br/>12:41:11,256 INFO  [SettingsFactory] Generate SQL with comments: disabled<br/>12:41:11,256 INFO  [SettingsFactory] Order SQL updates by primary key: disabled<br/>12:41:11,256 INFO  [SettingsFactory] Order SQL inserts for batching: disabled<br/>12:41:11,256 INFO  [SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory<br/>12:41:11,256 INFO  [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory<br/>12:41:11,256 INFO  [SettingsFactory] Query language substitutions: {}<br/>12:41:11,256 INFO  [SettingsFactory] JPA-QL strict compliance: enabled<br/>12:41:11,256 INFO  [SettingsFactory] Second-level cache: enabled<br/>12:41:11,256 INFO  [SettingsFactory] Query cache: disabled<br/>12:41:11,271 INFO  [SettingsFactory] Cache region factory : org.hibernate.cache.impl.bridge.RegionFactoryCacheProviderBridge<br/>12:41:11,271 INFO  [RegionFactoryCacheProviderBridge] Cache provider: org.hibernate.cache.HashtableCacheProvider<br/>12:41:11,271 INFO  [SettingsFactory] Optimize cache for minimal puts: disabled<br/>12:41:11,271 INFO  [SettingsFactory] Cache region prefix: persistence.unit:unitName=chapter2.ear/chapter2-ejb.jar#actionBazaar<br/>12:41:11,271 INFO  [SettingsFactory] Structured second-level cache entries: disabled<br/>12:41:11,287 INFO  [SettingsFactory] Statistics: disabled<br/>12:41:11,287 INFO  [SettingsFactory] Deleted entity synthetic identifier rollback: disabled<br/>12:41:11,287 INFO  [SettingsFactory] Default entity-mode: pojo<br/>12:41:11,287 INFO  [SettingsFactory] Named query checking : enabled<br/>12:41:11,334 INFO  [SessionFactoryImpl] building session factory<br/>12:41:11,443 INFO  [SessionFactoryObjectFactory] Factory name: persistence.unit:unitName=chapter2.ear/chapter2-ejb.jar#actionBazaar<br/>12:41:11,458 INFO  [NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces}</p><p>12:41:11,458 INFO  [NamingHelper] Creating subcontext: persistence.unit:unitName=chapter2.ear<br/>12:41:11,458 INFO  [SessionFactoryObjectFactory] Bound factory to JNDI name: persistence.unit:unitName=chapter2.ear/chapter2-ejb.jar#actionBazaar<br/>12:41:11,458 WARN  [SessionFactoryObjectFactory] InitialContext did not implement EventContext<br/>12:41:11,474 INFO  [SchemaUpdate] Running hbm2ddl schema update<br/>12:41:11,474 INFO  [SchemaUpdate] fetching database metadata<br/>12:41:11,474 INFO  [SchemaUpdate] updating schema<br/>12:41:11,490 INFO  [TableMetadata] table found: localDB.bids<br/>12:41:11,490 INFO  [TableMetadata] columns: [bid_id, bidder_id, bid_price, item_id, bid_date]<br/>12:41:11,505 INFO  [TableMetadata] foreign keys: []<br/>12:41:11,505 INFO  [TableMetadata] indexes: [primary]<br/>12:41:11,521 INFO  [TableMetadata] table found: localDB.orders<br/>12:41:11,521 INFO  [TableMetadata] columns: [bidder_id, account_number, status, street, state, expiry_date, order_id, city, credit_card_type]<br/>12:41:11,521 INFO  [TableMetadata] foreign keys: []<br/>12:41:11,521 INFO  [TableMetadata] indexes: [primary]<br/>12:41:11,521 INFO  [SchemaUpdate] schema update complete<br/>12:41:11,521 INFO  [NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces}</p><p>12:41:11,692 INFO  [EJBContainer] STARTED EJB: com.ejb3inaction.actionbazaar.buslogic.OrderBillingMDB ejbName: OrderBillingMDB<br/>12:41:11,739 INFO  [SessionSpecContainer] Starting jboss.j2ee:ear=chapter2.ear,jar=chapter2-ejb.jar,name=PlaceOrderBean,service=EJB3<br/>12:41:11,770 WARN  [JmsActivation] Failure in jms activation <a class="jive-link-external-small" href="mailto:org.jboss.resource.adapter.jms.inflow.JmsActivationSpec@530c1ac9(ra=org.jboss.resource.adapter.jms.JmsResourceAdapter@65368aae">org.jboss.resource.adapter.jms.inflow.JmsActivationSpec@530c1ac9(ra=org.jboss.resource.adapter.jms.JmsResourceAdapter@65368aae</a> destination=<br/>jms/OrderBillingQueue destinationType=javax.jms.Queue tx=true durable=false reconnect=10 provider=java:/DefaultJMSProvider user=null maxMessages=1 minSession=1 maxSession=15 keepAlive=60000 useDLQ=tru<br/>e DLQHandler=org.jboss.resource.adapter.jms.inflow.dlq.GenericDLQHandler DLQJndiName=queue/DLQ DLQUser=null DLQMaxResent=5)<br/>javax.naming.NameNotFoundException: DLQ not bound<br/>        at org.jnp.server.NamingServer.getBinding(NamingServer.java:771)<br/>        at org.jnp.server.NamingServer.getBinding(NamingServer.java:779)<br/>        at org.jnp.server.NamingServer.getObject(NamingServer.java:785)<br/>        at org.jnp.server.NamingServer.lookup(NamingServer.java:443)<br/>        at org.jnp.server.NamingServer.lookup(NamingServer.java:399)<br/>        at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:722)<br/>        at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:682)<br/>        at javax.naming.InitialContext.lookup(InitialContext.java:392)<br/>        at org.jboss.util.naming.Util.lookup(Util.java:222)<br/>        at org.jboss.resource.adapter.jms.inflow.dlq.AbstractDLQHandler.setupDLQDestination(AbstractDLQHandler.java:106)<br/>        at org.jboss.resource.adapter.jms.inflow.dlq.AbstractDLQHandler.setup(AbstractDLQHandler.java:82)<br/>        at org.jboss.resource.adapter.jms.inflow.dlq.JBossMQDLQHandler.setup(JBossMQDLQHandler.java:48)<br/>        at org.jboss.resource.adapter.jms.inflow.JmsActivation.setupDLQ(JmsActivation.java:413)<br/>        at org.jboss.resource.adapter.jms.inflow.JmsActivation.setup(JmsActivation.java:351)<br/>        at org.jboss.resource.adapter.jms.inflow.JmsActivation$SetupActivation.run(JmsActivation.java:729)<br/>        at org.jboss.resource.work.WorkWrapper.execute(WorkWrapper.java:213)<br/>        at org.jboss.util.threadpool.BasicTaskWrapper.run(BasicTaskWrapper.java:260)<br/>        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)<br/>        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)<br/>        at java.lang.Thread.run(Thread.java:662)<br/>12:41:11,786 INFO  [EJBContainer] STARTED EJB: com.ejb3inaction.actionbazaar.buslogic.PlaceOrderBean ejbName: PlaceOrderBean<br/>12:41:11,802 INFO  [SessionSpecContainer] Starting jboss.j2ee:ear=chapter2.ear,jar=chapter2-ejb.jar,name=PlaceBid,service=EJB3<br/>12:41:11,802 INFO  [EJBContainer] STARTED EJB: com.ejb3inaction.actionbazaar.buslogic.PlaceBidBean ejbName: PlaceBid<br/>12:41:11,817 INFO  [JndiSessionRegistrarBase] Binding the following Entries in Global JNDI:</p><p>        chapter2/PlaceBid/remote - EJB3.x Default Remote Business Interface<br/>        chapter2/PlaceBid/remote-com.ejb3inaction.actionbazaar.buslogic.PlaceBid - EJB3.x Remote Business Interface</p><p>12:41:11,833 INFO  [JndiSessionRegistrarBase] Binding the following Entries in Global JNDI:</p><p>        chapter2/PlaceOrderBean/remote - EJB3.x Default Remote Business Interface<br/>        chapter2/PlaceOrderBean/remote-com.ejb3inaction.actionbazaar.buslogic.PlaceOrder - EJB3.x Remote Business Interface</p><p>12:41:11,895 ERROR [ProfileServiceBootstrap] Failed to load profile: Summary of incomplete deployments (SEE PREVIOUS ERRORS FOR DETAILS):</p><p>DEPLOYMENTS MISSING DEPENDENCIES:<br/>  Deployment "jboss.messaging.connectionfactory:service=ClusterPullConnectionFactory" is missing the following dependencies:<br/>    Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "**ERROR**")<br/>  Deployment "jboss.messaging.connectionfactory:service=ClusteredConnectionFactory" is missing the following dependencies:<br/>    Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "**ERROR**")<br/>  Deployment "jboss.messaging.connectionfactory:service=ConnectionFactory" is missing the following dependencies:<br/>    Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "**ERROR**")<br/>  Deployment "jboss.messaging.destination:name=DLQ,service=Queue" is missing the following dependencies:<br/>    Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "**ERROR**")<br/>  Deployment "jboss.messaging.destination:name=ExpiryQueue,service=Queue" is missing the following dependencies:<br/>    Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "**ERROR**")</p><p>DEPLOYMENTS IN ERROR:<br/>  Deployment "jboss.mq.destination:name=ShippingRequestQueue,service=Queue" is in error due to the following reason(s): java.lang.NullPointerException<br/>  Deployment "jboss.messaging:service=PostOffice" is in error due to the following reason(s): java.lang.IllegalStateException: Failed to excecute transaction, **ERROR**<br/>  Deployment "jboss.mq.destination:name=OrderBillingQueue,service=Queue" is in error due to the following reason(s): java.lang.NullPointerException<br/>  Deployment "jboss:service=KeyGeneratorFactory,type=HiLo" is in error due to the following reason(s): java.sql.SQLException: Access is denied</p><p>12:41:11,911 INFO  [Http11Protocol] Starting Coyote HTTP/1.1 on http-127.0.0.1-8080<br/>12:41:11,942 INFO  [AjpProtocol] Starting Coyote AJP/1.3 on ajp-127.0.0.1-8009<br/>12:41:11,942 INFO  [ServerImpl] JBoss (Microcontainer) [5.0.1.GA (build: SVNTag=JBoss_5_0_1_GA date=200902231221)] Started in 28s:154ms<br/>12:41:21,786 INFO  [JmsActivation] Attempting to reconnect <a class="jive-link-external-small" href="mailto:org.jboss.resource.adapter.jms.inflow.JmsActivationSpec@530c1ac9(ra=org.jboss.resource.adapter.jms.JmsResourceAdapter@65368aae">org.jboss.resource.adapter.jms.inflow.JmsActivationSpec@530c1ac9(ra=org.jboss.resource.adapter.jms.JmsResourceAdapter@65368aae</a> destination=jm<br/>s/OrderBillingQueue destinationType=javax.jms.Queue tx=true durable=false reconnect=10 provider=java:/DefaultJMSProvider user=null maxMessages=1 minSession=1 maxSession=15 keepAlive=60000 useDLQ=true<br/>DLQHandler=org.jboss.resource.adapter.jms.inflow.dlq.GenericDLQHandler DLQJndiName=queue/DLQ DLQUser=null DLQMaxResent=5)<br/>12:41:21,818 ERROR [JmsActivation] Unable to reconnect <a class="jive-link-external-small" href="mailto:org.jboss.resource.adapter.jms.inflow.JmsActivationSpec@530c1ac9(ra=org.jboss.resource.adapter.jms.JmsResourceAdapter@65368aae">org.jboss.resource.adapter.jms.inflow.JmsActivationSpec@530c1ac9(ra=org.jboss.resource.adapter.jms.JmsResourceAdapter@65368aae</a> destination=jms/Or<br/>derBillingQueue destinationType=javax.jms.Queue tx=true durable=false reconnect=10 provider=java:/DefaultJMSProvider user=null maxMessages=1 minSession=1 maxSession=15 keepAlive=60000 useDLQ=true DLQH<br/>andler=org.jboss.resource.adapter.jms.inflow.dlq.GenericDLQHandler DLQJndiName=queue/DLQ DLQUser=null DLQMaxResent=5)<br/>javax.naming.NameNotFoundException: DLQ not bound<br/>        at org.jnp.server.NamingServer.getBinding(NamingServer.java:771)<br/>        at org.jnp.server.NamingServer.getBinding(NamingServer.java:779)<br/>        at org.jnp.server.NamingServer.getObject(NamingServer.java:785)<br/>        at org.jnp.server.NamingServer.lookup(NamingServer.java:443)<br/>        at org.jnp.server.NamingServer.lookup(NamingServer.java:399)<br/>        at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:722)<br/>        at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:682)<br/>        at javax.naming.InitialContext.lookup(InitialContext.java:392)<br/>        at org.jboss.util.naming.Util.lookup(Util.java:222)<br/>        at org.jboss.resource.adapter.jms.inflow.dlq.AbstractDLQHandler.setupDLQDestination(AbstractDLQHandler.java:106)<br/>        at org.jboss.resource.adapter.jms.inflow.dlq.AbstractDLQHandler.setup(AbstractDLQHandler.java:82)<br/>        at org.jboss.resource.adapter.jms.inflow.dlq.JBossMQDLQHandler.setup(JBossMQDLQHandler.java:48)<br/>        at org.jboss.resource.adapter.jms.inflow.JmsActivation.setupDLQ(JmsActivation.java:413)<br/>        at org.jboss.resource.adapter.jms.inflow.JmsActivation.setup(JmsActivation.java:351)<br/>        at org.jboss.resource.adapter.jms.inflow.JmsActivation.handleFailure(JmsActivation.java:292)<br/>        at org.jboss.resource.adapter.jms.inflow.JmsActivation$SetupActivation.run(JmsActivation.java:733)<br/>        at org.jboss.resource.work.WorkWrapper.execute(WorkWrapper.java:213)<br/>        at org.jboss.util.threadpool.BasicTaskWrapper.run(BasicTaskWrapper.java:260)<br/>        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)<br/>        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)<br/>        at java.lang.Thread.run(Thread.java:662)<br/>12:41:31,958 INFO  [JmsActivation] Attempting to reconnect <a class="jive-link-external-small" href="mailto:org.jboss.resource.adapter.jms.inflow.JmsActivationSpec@530c1ac9(ra=org.jboss.resource.adapter.jms.JmsResourceAdapter@65368aae">org.jboss.resource.adapter.jms.inflow.JmsActivationSpec@530c1ac9(ra=org.jboss.resource.adapter.jms.JmsResourceAdapter@65368aae</a> destination=jm<br/>s/OrderBillingQueue destinationType=javax.jms.Queue tx=true durable=false reconnect=10 provider=java:/DefaultJMSProvider user=null maxMessages=1 minSession=1 maxSession=15 keepAlive=60000 useDLQ=true<br/>DLQHandler=org.jboss.resource.adapter.jms.inflow.dlq.GenericDLQHandler DLQJndiName=queue/DLQ DLQUser=null DLQMaxResent=5)<br/>12:41:31,958 ERROR [JmsActivation] Unable to reconnect <a class="jive-link-external-small" href="mailto:org.jboss.resource.adapter.jms.inflow.JmsActivationSpec@530c1ac9(ra=org.jboss.resource.adapter.jms.JmsResourceAdapter@65368aae">org.jboss.resource.adapter.jms.inflow.JmsActivationSpec@530c1ac9(ra=org.jboss.resource.adapter.jms.JmsResourceAdapter@65368aae</a> destination=jms/Or<br/>derBillingQueue destinationType=javax.jms.Queue tx=true durable=false reconnect=10 provider=java:/DefaultJMSProvider user=null maxMessages=1 minSession=1 maxSession=15 keepAlive=60000 useDLQ=true DLQH<br/>andler=org.jboss.resource.adapter.jms.inflow.dlq.GenericDLQHandler DLQJndiName=queue/DLQ DLQUser=null DLQMaxResent=5)<br/>javax.naming.NameNotFoundException: DLQ not bound<br/>        at org.jnp.server.NamingServer.getBinding(NamingServer.java:771)<br/>        at org.jnp.server.NamingServer.getBinding(NamingServer.java:779)<br/>        at org.jnp.server.NamingServer.getObject(NamingServer.java:785)<br/>        at org.jnp.server.NamingServer.lookup(NamingServer.java:443)<br/>        at org.jnp.server.NamingServer.lookup(NamingServer.java:399)<br/>        at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:722)<br/>        at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:682)<br/>        at javax.naming.InitialContext.lookup(InitialContext.java:392)<br/>        at org.jboss.util.naming.Util.lookup(Util.java:222)<br/>        at org.jboss.resource.adapter.jms.inflow.dlq.AbstractDLQHandler.setupDLQDestination(AbstractDLQHandler.java:106)<br/>        at org.jboss.resource.adapter.jms.inflow.dlq.AbstractDLQHandler.setup(AbstractDLQHandler.java:82)<br/>        at org.jboss.resource.adapter.jms.inflow.dlq.JBossMQDLQHandler.setup(JBossMQDLQHandler.java:48)<br/>        at org.jboss.resource.adapter.jms.inflow.JmsActivation.setupDLQ(JmsActivation.java:413)<br/>        at org.jboss.resource.adapter.jms.inflow.JmsActivation.setup(JmsActivation.java:351)<br/>        at org.jboss.resource.adapter.jms.inflow.JmsActivation.handleFailure(JmsActivation.java:292)<br/>        at org.jboss.resource.adapter.jms.inflow.JmsActivation$SetupActivation.run(JmsActivation.java:733)<br/>        at org.jboss.resource.work.WorkWrapper.execute(WorkWrapper.java:213)<br/>        at org.jboss.util.threadpool.BasicTaskWrapper.run(BasicTaskWrapper.java:260)<br/>        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)<br/>        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)<br/>        at java.lang.Thread.run(Thread.java:662)</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="https://community.jboss.org/message/723638#723638">going to Community</a></p>
        <p style="margin: 0;">Start a new discussion in Datasource Configuration at <a href="https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>