Cannot conect to mySql DB after changing DB from HSQL to mySql in JBOSS 5

[arturo nunez]

I am trying to run the EJB in Action Chapter 2 application.

I want to use mySql database instead of the default hsqldb. 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.
The first error I see in the server log is :

12:40:59,456 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Access is denied)

Although there are many other eros in the log, since this is the first error in the log, I am assuming that subsequent error messages releated to this first error.

The database is : localDB, the userid id : SA the password is : password
I have reviewed 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.
I build the ear file with apache ant.

Any advice would be welcome as I've spent about 9 hours trying tp get this to work.

I have pasted at the bottom of this post the server log. I have pasted immediatedly below this sentence the files :
msSQL-ds.xml
login_config.xml
Messaging-jboss-beans.xml
mysql-persistence-service.xml (I created and use this file instead of hsqldb-persistence-service.xml)
persistence.xml



persistence.xml

<persistence xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd" version="1.0"> <persistence-unit name="actionBazaar"> <jta-data-source>java:/MySqlDS</jta-data-source> <properties> <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect" /> <property name="hibernate.hbm2ddl.auto" value="update" /> </properties> </persistence-unit> </persistence>



msSQL-ds.xml

<?xml version="1.0" encoding="UTF-8"?> <datasources> <local-tx-datasource> <jndi-name>MySqlDS</jndi-name> <connection-url>jdbc:mysql://localhost:3306/localDB</connection-url> <driver-class>com.mysql.jdbc.Driver</driver-class> <user-name>SA</user-name> <password>password</password> <min-pool-size>5</min-pool-size> <max-pool-size>20</max-pool-size> <idle-timeout-minutes>5</idle-timeout-minutes> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name> <metadata> <type-mapping>mySQL</type-mapping> </metadata> </local-tx-datasource> </datasources>


login_config.xml
<?xml version='1.0'?> <policy> <application-policy name="client-login"> <authentication> <login-module code="org.jboss.security.ClientLoginModule" flag="required"> <!-- Any existing security context will be restored on logout --> <module-option name="restore-login-identity">true</module-option> </login-module> </authentication> </application-policy> <!-- Security domains for testing new jca framework --> <application-policy name="HsqlDbRealm"> <authentication> <login-module code="org.jboss.resource.security.ConfiguredIdentityLoginModule" flag="required"> <module-option name="principal">SA</module-option> <module-option name="userName">SA</module-option> <module-option name="password">password</module-option> <module-option name="managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=DefaultDS</module-option> </login-module> </authentication> </application-policy> <!-- to use mySQL database --> <application-policy name = "MySqlDbRealm"> <authentication> <login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule" flag = "required"> <module-option name = "principal">SA</module-option> <module-option name = "userName">SA</module-option> <module-option name ="password">password</module-option> <module-option name = "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=MySqlDS</module-option> </login-module> </authentication> </application-policy> <application-policy name="JmsXARealm"> <authentication> <login-module code="org.jboss.resource.security.ConfiguredIdentityLoginModule" flag="required"> <module-option name="principal">guest</module-option> <module-option name="userName">guest</module-option> <module-option name="password">guest</module-option> <module-option name="managedConnectionFactoryName">jboss.jca:service=TxCM,name=JmsXA</module-option> </login-module> </authentication> </application-policy> <application-policy name="jmx-console"> <authentication> <login-module code="org.jboss.security.auth.spi.UsersRolesLoginModule" flag="required"> <module-option name="usersProperties">props/jmx-console-users.properties</module-option> <module-option name="rolesProperties">props/jmx-console-roles.properties</module-option> </login-module> </authentication> </application-policy> <!-- A template configuration for the web-console web application. This defaults to the UsersRolesLoginModule the same as other and should be changed to a stronger authentication mechanism as required. --> <application-policy name="web-console"> <authentication> <login-module code="org.jboss.security.auth.spi.UsersRolesLoginModule" flag="required"> <module-option name="usersProperties">web-console-users.properties</module-option> <module-option name="rolesProperties">web-console-roles.properties</module-option> </login-module> </authentication> </application-policy> <application-policy name="JBossWS"> <authentication> <login-module code="org.jboss.security.auth.spi.UsersRolesLoginModule" flag="required"> <module-option name="usersProperties">props/jbossws-users.properties</module-option> <module-option name="rolesProperties">props/jbossws-roles.properties</module-option> <module-option name="unauthenticatedIdentity">anonymous</module-option> </login-module> </authentication> </application-policy> <application-policy name="other"> <authentication> <login-module code="org.jboss.security.auth.spi.UsersRolesLoginModule" flag="required"/> </authentication> </application-policy> </policy>

mysql-persistence-service.xml (replaced hsql-persistence-service.xml
<?xml version="1.0" encoding="UTF-8"?> <!-- Hypersonic persistence deployment descriptor. DO NOT USE HYPERSONIC IN PRODUCTION or in a clustered environment- Hypersonic does not have transaction isolation $Id: hsqldb-persistence-service.xml 3339 2007-11-16 20:48:08Z [e-mail] $ --> <server> <!-- Persistence Manager MBean configuration ======================================= --> <mbean code="org.jboss.messaging.core.jmx.JDBCPersistenceManagerService" name="jboss.messaging:service=PersistenceManager" xmbean-dd="xmdesc/JDBCPersistenceManager-xmbean.xml"> <depends>jboss.jca:service=DataSourceBinding,name=MySqlDS</depends> <depends optional-attribute-name="TransactionManager">jboss:service=TransactionManager</depends> <!-- The datasource to use for the persistence manager --> <attribute name="DataSource">java:/MySqlDS</attribute> <!-- If true will attempt to create tables and indexes on every start-up --> <attribute name="CreateTablesOnStartup">false</attribute> <!-- If true then will use JDBC batch updates --> <attribute name="UsingBatchUpdates">false</attribute> <!-- The maximum number of parameters to include in a prepared statement --> <attribute name="MaxParams">500</attribute> </mbean> <!-- Messaging Post Office MBean configuration ========================================= --> <mbean code="org.jboss.messaging.core.jmx.MessagingPostOfficeService" name="jboss.messaging:service=PostOffice" xmbean-dd="xmdesc/MessagingPostOffice-xmbean.xml"> <depends optional-attribute-name="ServerPeer">jboss.messaging:service=ServerPeer</depends> <depends>jboss.jca:service=DataSourceBinding,name=MySqlDS</depends> <depends optional-attribute-name="TransactionManager">jboss:service=TransactionManager</depends> <!-- The name of the post office --> <attribute name="PostOfficeName">JMS post office</attribute> <!-- The datasource used by the post office to access it's binding information --> <attribute name="DataSource">java:/MySqlDS</attribute> <!-- If true will attempt to create tables and indexes on every start-up --> <attribute name="CreateTablesOnStartup">true</attribute> <!-- This post office is NON CLUSTERED - do not use clustering with Hypersonic!! --> <attribute name="Clustered">false</attribute> </mbean> <!-- Messaging JMS User Manager MBean config ======================================= --> <mbean code="org.jboss.jms.server.plugin.JDBCJMSUserManagerService" name="jboss.messaging:service=JMSUserManager" xmbean-dd="xmdesc/JMSUserManager-xmbean.xml"> <depends>jboss.jca:service=DataSourceBinding,name=MySqlDS</depends> <depends optional-attribute-name="TransactionManager">jboss:service=TransactionManager</depends> <attribute name="DataSource">java:/MySqlDS</attribute> <attribute name="CreateTablesOnStartup">false</attribute> <attribute name="SqlProperties"><![CDATA[ POPULATE.TABLES.1 = INSERT INTO JBM_USER (USER_ID, PASSWD) VALUES ('guest', 'guest'); POPULATE.TABLES.2 = INSERT INTO JBM_USER (USER_ID, PASSWD) VALUES ('j2ee', 'j2ee'); POPULATE.TABLES.3 = INSERT INTO JBM_USER (USER_ID, PASSWD, CLIENTID) VALUES ('john', 'needle', 'DurableSubscriberExample'); POPULATE.TABLES.4 = INSERT INTO JBM_USER (USER_ID, PASSWD) VALUES ('nobody', 'nobody'); POPULATE.TABLES.5 = INSERT INTO JBM_USER (USER_ID, PASSWD) VALUES ('dynsub', 'dynsub'); POPULATE.TABLES.6 = INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES ('guest','guest'); POPULATE.TABLES.7 = INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES ('j2ee','guest'); POPULATE.TABLES.8 = INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES ('john','guest'); POPULATE.TABLES.9 = INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES ('subscriber','john'); POPULATE.TABLES.10 = INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES ('publisher','john'); POPULATE.TABLES.11 = INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES ('publisher','dynsub'); POPULATE.TABLES.12 = INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES ('durpublisher','john'); POPULATE.TABLES.13 = INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES ('durpublisher','dynsub'); POPULATE.TABLES.14 = INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES ('noacc','nobody'); ]]></attribute> </mbean> </server>

messaging-jboss-beans.xml
<?xml version="1.0" encoding="UTF-8"?> <!-- Messaging beans $Id: messaging-beans.xml 68282 2007-12-14 13:43:52Z [e-mail] $ --> <deployment xmlns="urn:jboss:bean-deployer:2.0"> <!-- messaging application-policy definition --> <application-policy xmlns="urn:jboss:security-beans:1.0" name="messaging"> <authentication> <login-module code="org.jboss.security.auth.spi.DatabaseServerLoginModule" flag="required"> <module-option name="unauthenticatedIdentity">guest</module-option> <module-option name="dsJndiName">java:/DefaultDS</module-option> <module-option name="principalsQuery">SELECT PASSWD FROM JBM_USER WHERE USER_ID=?</module-option> <module-option name="rolesQuery">SELECT ROLE_ID, 'Roles' FROM JBM_ROLE WHERE USER_ID=?</module-option> </login-module> </authentication> </application-policy> <bean name="SecurityStore" class="org.jboss.jms.server.jbosssx.JBossASSecurityMetadataStore"> <!-- default security configuration --> <property name="defaultSecurityConfig"> <![CDATA[ <security> <role name="guest" read="true" write="true" create="true"/> </security> ]]> </property> <property name="suckerPassword">CHANGE ME!!</property> <property name="securityDomain">messaging</property> <property name="securityManagement"><inject bean="JNDIBasedSecurityManagement"/></property> <!-- @JMX annotation to export the management view of this bean --> <annotation>@org.jboss.aop.microcontainer.aspects.jmx.JMX(name="jboss.messaging:service=SecurityStore",exposedInterface=org.jboss.jms.server.jbosssx.JBossASSecurityMetadataStoreMBean.class)</annotation> </bean> <bean name="QueueTemplate" class="org.jboss.profileservice.management.templates.JmsDestinationTemplate"> <property name="info"><inject bean="QueueTemplateInfo"/></property> </bean> <bean name="QueueTemplateInfo" class="org.jboss.profileservice.management.templates.JmsDestinationTemplateInfo"> <constructor> <parameter>QueueTemplate</parameter> <parameter>A template for JMS queue *-service.xml deployments</parameter> <parameter>queue</parameter> </constructor> </bean> <bean name="TopicTemplate" class="org.jboss.profileservice.management.templates.JmsDestinationTemplate"> <property name="info"><inject bean="TopicTemplateInfo"/></property> </bean> <bean name="TopicTemplateInfo" class="org.jboss.profileservice.management.templates.JmsDestinationTemplateInfo"> <constructor> <parameter>TopicTemplate</parameter> <parameter>A template for JMS topic *-service.xml deployments</parameter> <parameter>topic</parameter> </constructor> </bean> <bean name="QueueMODefinition" class="org.jboss.jms.server.destination.QueueMODefinition"> <constructor> <parameter><inject bean="ManagedObjectFactory" /></parameter> </constructor> </bean> <bean name="TopicMODefinition" class="org.jboss.jms.server.destination.TopicMODefinition"> <constructor> <parameter><inject bean="ManagedObjectFactory" /></parameter> </constructor> </bean> </deployment>


THE JBOSS LOG (part of log not posted)

C:\jboss-5.0.1.GA\bin>run
===============================================================================
JBoss Bootstrap Environment
JBOSS_HOME: c:\jboss-5.0.1.GA
JAVA: c:\jdk1.6.0_30\bin\java
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
CLASSPATH: c:\jboss-5.0.1.GA\bin\run.jar
===============================================================================
12:40:43,695 INFO [ServerImpl] Starting JBoss (Microcontainer)...
12:40:43,695 INFO [ServerImpl] Release ID: JBoss [Morpheus] 5.0.1.GA (build: SVNTag=JBoss_5_0_1_GA date=200902231221)
12:40:43,695 INFO [ServerImpl] Bootstrap URL: null
12:40:43,710 INFO [ServerImpl] Home Dir: C:\jboss-5.0.1.GA
12:40:43,710 INFO [ServerImpl] Home URL: file:/C:/jboss-5.0.1.GA/
12:40:43,710 INFO [ServerImpl] Library URL: file:/C:/jboss-5.0.1.GA/lib/
12:40:43,710 INFO [ServerImpl] Patch URL: null
12:40:43,710 INFO [ServerImpl] Common Base URL: file:/C:/jboss-5.0.1.GA/common/
12:40:43,710 INFO [ServerImpl] Common Library URL: file:/C:/jboss-5.0.1.GA/common/lib/
12:40:43,710 INFO [ServerImpl] Server Name: default
12:40:43,710 INFO [ServerImpl] Server Base Dir: C:\jboss-5.0.1.GA\server
12:40:43,710 INFO [ServerImpl] Server Base URL: file:/C:/jboss-5.0.1.GA/server/
12:40:43,726 INFO [ServerImpl] Server Config URL: file:/C:/jboss-5.0.1.GA/server/default/conf/
12:40:43,726 INFO [ServerImpl] Server Home Dir: C:\jboss-5.0.1.GA\server\default
12:40:43,741 INFO [ServerImpl] Server Home URL: file:/C:/jboss-5.0.1.GA/server/default/
12:40:43,741 INFO [ServerImpl] Server Data Dir: C:\jboss-5.0.1.GA\server\default\data
12:40:43,757 INFO [ServerImpl] Server Library URL: file:/C:/jboss-5.0.1.GA/server/default/lib/
12:40:43,757 INFO [ServerImpl] Server Log Dir: C:\jboss-5.0.1.GA\server\default\log
12:40:43,757 INFO [ServerImpl] Server Native Dir: C:\jboss-5.0.1.GA\server\default\tmp\native
12:40:43,773 INFO [ServerImpl] Server Temp Dir: C:\jboss-5.0.1.GA\server\default\tmp
12:40:43,773 INFO [ServerImpl] Server Temp Deploy Dir: C:\jboss-5.0.1.GA\server\default\tmp\deploy
12:40:44,209 INFO [ServerImpl] Starting Microcontainer, bootstrapURL=file:/C:/jboss-5.0.1.GA/server/default/conf/bootstrap.xml
12:40:44,506 INFO [VFSCacheFactory] Initializing VFSCache [org.jboss.virtual.plugins.cache.CombinedVFSCache]
12:40:44,506 INFO [VFSCacheFactory] Using VFSCache [CombinedVFSCache[real-cache: null]]
12:40:44,662 INFO [CopyMechanism] VFS temp dir: C:\jboss-5.0.1.GA\server\default\tmp
12:40:44,677 INFO [ZipEntryContext] VFS force nested jars copy-mode is enabled.
12:40:45,359 INFO [ServerInfo] Java version: 1.6.0_30,Sun Microsystems Inc.
12:40:45,359 INFO [ServerInfo] Java Runtime: Java(TM) SE Runtime Environment (build 1.6.0_30-b12)
12:40:45,369 INFO [ServerInfo] Java VM: Java HotSpot(TM) 64-Bit Server VM 20.5-b03,Sun Microsystems Inc.
12:40:45,379 INFO [ServerInfo] OS-System: Windows 7 6.1,amd64
12:40:45,409 INFO [JMXKernel] Legacy JMX core initialized
12:40:46,751 INFO [ProfileServiceImpl] Loading profile: default from: org.jboss.system.server.profileservice.repository.SerializableDeploymentRepository@1dc2dad7(root=C:\jboss-5.0.1.GA\server, key=or
g.jboss.profileservice.spi.ProfileKey@143b82c3[domain=default,server=default,name=default])
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
e.spi.ProfileKey@143b82c3[domain=default,server=default,name=default])
12:40:46,791 INFO [ProfileServiceImpl] Loaded profile: ProfileImpl@1e35ecd{key=org.jboss.profileservice.spi.ProfileKey@143b82c3[domain=default,server=default,name=default]}
12:40:47,781 INFO [WebService] Using RMI server codebase: http://127.0.0.1:8083/
12:40:51,044 INFO [NativeServerConfig] JBoss Web Services - Stack Native Core
12:40:51,044 INFO [NativeServerConfig] 3.0.5.GA
12:40:54,522 INFO [ContainerDependencyMetaData] addJndiDependency, JndiDependencyMetaData@7d582674{jms/OrderBillingQueue}
12:40:54,553 INFO [Ejb3DependenciesDeployer] Encountered deployment AbstractVFSDeploymentContext@848954470{vfszip:/C:/jboss-5.0.1.GA/server/default/deploy/chapter2.ear/chapter2-ejb.jar/}
12:40:54,553 INFO [Ejb3DependenciesDeployer] Encountered deployment AbstractVFSDeploymentContext@848954470{vfszip:/C:/jboss-5.0.1.GA/server/default/deploy/chapter2.ear/chapter2-ejb.jar/}
12:40:56,636 INFO [JMXConnectorServerService] JMX Connector server: service:jmx:rmi://127.0.0.1/jndi/rmi://127.0.0.1:1090/jmxconnector
12:40:56,756 INFO [MailService] Mail Service bound to java:/Mail
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
password changed from the installation default. Please see the JBoss Messaging user guide for instructions on how to do this.
12:40:57,556 WARN [AnnotationCreator] No ClassLoader provided, using TCCL: org.jboss.managed.api.annotation.ManagementComponent
12:40:57,656 INFO [TransactionManagerService] JBossTS Transaction Service (JTA version) - JBoss Inc.
12:40:57,666 INFO [TransactionManagerService] Setting up property manager MBean and JMX layer
12:40:57,806 INFO [TransactionManagerService] Initializing recovery manager
12:40:57,886 INFO [TransactionManagerService] Recovery manager configured
12:40:57,886 INFO [TransactionManagerService] Binding TransactionManager JNDI Reference
12:40:57,906 INFO [TransactionManagerService] Starting transaction recovery manager
12:40:58,186 INFO [Http11Protocol] Initializing Coyote HTTP/1.1 on http-127.0.0.1-8080
12:40:58,196 INFO [AjpProtocol] Initializing Coyote AJP/1.3 on ajp-127.0.0.1-8009
12:40:58,196 INFO [StandardService] Starting service jboss.web
12:40:58,206 INFO [StandardEngine] Starting Servlet Engine: JBoss Web/2.1.2.GA
12:40:58,246 INFO [Catalina] Server startup in 101 ms
12:40:58,266 INFO [TomcatDeployment] deploy, ctxPath=/jbossws
12:40:58,606 INFO [TomcatDeployment] deploy, ctxPath=/web-console
12:40:58,796 INFO [TomcatDeployment] deploy, ctxPath=/invoker
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
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
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
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
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
12:40:59,016 INFO [SimpleThreadPool] Job execution threads will use class loader of thread: main
12:40:59,036 INFO [QuartzScheduler] Quartz Scheduler v.1.5.2 created.
12:40:59,046 INFO [RAMJobStore] RAMJobStore initialized.
12:40:59,066 INFO [StdSchedulerFactory] Quartz scheduler 'DefaultQuartzScheduler' initialized from default resource file in Quartz package: 'quartz.properties'
12:40:59,076 INFO [StdSchedulerFactory] Quartz scheduler version: 1.5.2
12:40:59,086 INFO [QuartzScheduler] Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started.
12:40:59,416 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 'java:DefaultDS'
12:40:59,456 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Access is denied)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:225)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:195)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:611)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:257)
at org.jboss.resource.coe.connectnnectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:607)
at org.jboss.resourcionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:381)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.tableExists(SQLUtil.java:1037)
at org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory.createTableIfNotExists(HiLoKeyGeneratorFactory.java:363)
at org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory.initSequence(HiLoKeyGeneratorFactory.java:304)
at org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory.startService(HiLoKeyGeneratorFactory.java:278)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:376)
at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:322)
at sun.reflect.GeneratedMethodAccessor107.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)
at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:189)
at $Proxy36.start(Unknown Source)
at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)
at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)
at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:286)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
at org.jboss.system.ServiceController.doChange(ServiceController.java:688)
at org.jboss.system.ServiceController.start(ServiceController.java:460)
at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163)
at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99)
at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)
at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)
at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1178)
at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781)
at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:698)
at org.jboss.system.server.profileservice.ProfileServiceBootstrap.loadProfile(ProfileServiceBootstrap.java:304)
at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:205)
at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:405)
at org.jboss.Main.boot(Main.java:209)
at org.jboss.Main$1.run(Main.java:547)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: Access is denied
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:207)
... 65 more
12:40:59,996 ERROR [AbstractKernelController] Error installing to Start: name=jboss:service=KeyGeneratorFactory,type=HiLo state=Create mode=Manual requiredState=Installed
org.jboss.deployment.DeploymentException: Error while checking if table aleady exists HILOSEQUENCES
at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.tableExists(SQLUtil.java:1082)
at org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory.createTableIfNotExists(HiLoKeyGeneratorFactory.java:363)
at org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory.initSequence(HiLoKeyGeneratorFactory.java:304)
at org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory.startService(HiLoKeyGeneratorFactory.java:278)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:376)
at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:322)
at sun.reflect.GeneratedMethodAccessor107.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)
at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:189)
at $Proxy36.start(Unknown Source)
at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)
at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)
at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:286)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
at org.jboss.system.ServiceController.doChange(ServiceController.java:688)
at org.jboss.system.ServiceController.start(ServiceController.java:460)
at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163)
at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99)
at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)
at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)
at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1178)
at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781)
at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:698)
at org.jboss.system.server.profileservice.ProfileServiceBootstrap.loadProfile(ProfileServiceBootstrap.java:304)
at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:205)
at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:405)
at org.jboss.Main.boot(Main.java:209)
at org.jboss.Main$1.run(Main.java:547)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: Access is denied); - nested throwable: (org.jboss.resource.JBossResourceException
: Could not create connection; - nested throwable: (java.sql.SQLException: Access is denied))
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)
at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.tableExists(SQLUtil.java:1037)
... 55 more
Caused by: org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Access is denied)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:225)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:195)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:611)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:257)
at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:607)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:381)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
... 56 more
Caused by: java.sql.SQLException: Access is denied
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:207)
... 65 more
12:41:00,436 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=MySqlDS' to JNDI name 'java:MySqlDS'
12:41:00,606 WARN [JDBCPersistenceManager]
JBoss Messaging Warning: DataSource connection transaction isolation should be READ_COMMITTED, but it is currently REPEATABLE_READ.
Using an isolation level less strict than READ_COMMITTED may lead to data consistency problems.
Using an isolation level more strict than READ_COMMITTED may lead to deadlock.
12:41:00,756 INFO [ServerPeer] JBoss Messaging 1.4.1.GA server [0] started
12:41:00,786 WARN [JDBCSupport] SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:1
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
ION, SELECTOR, CHANNEL_ID, CLUSTERED, ALL_NODES FROM JBM_POSTOFFICE WHERE ' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2293)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)
at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice$1LoadBindings.doTransaction(MessagingPostOffice.java:2487)
at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice$1LoadBindings.doTransaction(MessagingPostOffice.java:2470)
at org.jboss.messaging.core.impl.JDBCSupport$JDBCTxRunner.execute(JDBCSupport.java:394)
at org.jboss.messaging.core.impl.JDBCSupport$JDBCTxRunner.executeWithRetry(JDBCSupport.java:416)
at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.getBindingsFromStorage(MessagingPostOffice.java:2538)
at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.start(MessagingPostOffice.java:353)
at org.jboss.messaging.core.jmx.MessagingPostOfficeService.startService(MessagingPostOfficeService.java:456)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:376)
at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:269)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:138)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:90)
at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:140)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:90)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)
at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:206)
at $Proxy36.start(Unknown Source)
at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)
at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)
at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:286)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
at org.jboss.system.ServiceController.doChange(ServiceController.java:688)
at org.jboss.system.ServiceController.start(ServiceController.java:460)
at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163)
at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99)
at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)
at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)
at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1178)
at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781)
at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:698)
at org.jboss.system.server.profileservice.ProfileServiceBootstrap.loadProfile(ProfileServiceBootstrap.java:304)
at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:205)
at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:405)
at org.jboss.Main.boot(Main.java:209)
at org.jboss.Main$1.run(Main.java:547)
at java.lang.Thread.run(Thread.java:662)
****************** deleted some log output from here ******************
12:41:09,670 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name 'java:JmsXA'
12:41:09,710 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=manningDS' to JNDI name 'java:manningDS'
12:41:09,750 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=OracleDS' to JNDI name 'java:OracleDS'
12:41:09,770 INFO [TomcatDeployment] deploy, ctxPath=/
12:41:09,820 INFO [TomcatDeployment] deploy, ctxPath=/jmx-console
12:41:09,940 INFO [TomcatDeployment] deploy, ctxPath=/murachch14email
12:41:10,640 INFO [JBossASKernel] Created KernelDeployment for: chapter2-ejb.jar
12:41:10,640 INFO [JBossASKernel] installing bean: jboss.j2ee:ear=chapter2.ear,jar=chapter2-ejb.jar,name=OrderBillingMDB,service=EJB3
12:41:10,640 INFO [JBossASKernel] with dependencies:
12:41:10,640 INFO [JBossASKernel] and demands:
12:41:10,640 INFO [JBossASKernel] jboss.ejb:service=EJBTimerService
12:41:10,640 INFO [JBossASKernel] persistence.unit:unitName=chapter2.ear/chapter2-ejb.jar#actionBazaar
12:41:10,640 INFO [JBossASKernel] and supplies:
12:41:10,640 INFO [JBossASKernel] jndi:null
12:41:10,650 INFO [JBossASKernel] Class:javax.jms.MessageListener
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
12:41:10,650 INFO [JBossASKernel] installing bean: jboss.j2ee:ear=chapter2.ear,jar=chapter2-ejb.jar,name=PlaceBid,service=EJB3
12:41:10,650 INFO [JBossASKernel] with dependencies:
12:41:10,650 INFO [JBossASKernel] and demands:
12:41:10,650 INFO [JBossASKernel] jboss.ejb:service=EJBTimerService
12:41:10,650 INFO [JBossASKernel] persistence.unit:unitName=chapter2.ear/chapter2-ejb.jar#actionBazaar
12:41:10,650 INFO [JBossASKernel] and supplies:
12:41:10,650 INFO [JBossASKernel] jndi:chapter2/PlaceBid/remote-com.ejb3inaction.actionbazaar.buslogic.PlaceBid
12:41:10,650 INFO [JBossASKernel] jndi:chapter2/PlaceBid/remote
12:41:10,650 INFO [JBossASKernel] Class:com.ejb3inaction.actionbazaar.buslogic.PlaceBid
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
12:41:10,650 INFO [JBossASKernel] installing bean: jboss.j2ee:ear=chapter2.ear,jar=chapter2-ejb.jar,name=PlaceOrderBean,service=EJB3
12:41:10,660 INFO [JBossASKernel] with dependencies:
12:41:10,660 INFO [JBossASKernel] and demands:
12:41:10,660 INFO [JBossASKernel] jboss.ejb:service=EJBTimerService
12:41:10,660 INFO [JBossASKernel] persistence.unit:unitName=chapter2.ear/chapter2-ejb.jar#actionBazaar
12:41:10,660 INFO [JBossASKernel] and supplies:
12:41:10,660 INFO [JBossASKernel] jndi:chapter2/PlaceOrderBean/remote
12:41:10,660 INFO [JBossASKernel] jndi:chapter2/PlaceOrderBean/remote-com.ejb3inaction.actionbazaar.buslogic.PlaceOrder
12:41:10,660 INFO [JBossASKernel] Class:com.ejb3inaction.actionbazaar.buslogic.PlaceOrder
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
12:41:10,710 INFO [PersistenceUnitDeployment] Starting persistence unit persistence.unit:unitName=chapter2.ear/chapter2-ejb.jar#actionBazaar
12:41:10,756 INFO [Version] Hibernate Annotations 3.4.0.GA
12:41:10,772 INFO [Environment] Hibernate 3.3.1.GA
12:41:10,788 INFO [Environment] hibernate.properties not found
12:41:10,788 INFO [Environment] Bytecode provider name : javassist
12:41:10,788 INFO [Environment] using JDK 1.4 java.sql.Timestamp handling
12:41:10,850 INFO [Version] Hibernate Commons Annotations 3.1.0.GA
12:41:10,850 INFO [Version] Hibernate EntityManager 3.4.0.GA
12:41:10,897 WARN [Ejb3Configuration] Persistence provider caller does not implement the EJB3 spec correctly. PersistenceUnitInfo.getNewTempClassLoader() is null.
12:41:10,959 INFO [AnnotationBinder] Binding entity from annotated class: com.ejb3inaction.actionbazaar.persistence.Bid
12:41:11,022 INFO [EntityBinder] Bind entity com.ejb3inaction.actionbazaar.persistence.Bid on table BIDS
12:41:11,068 INFO [AnnotationBinder] Binding entity from annotated class: com.ejb3inaction.actionbazaar.persistence.Order
12:41:11,068 INFO [EntityBinder] Bind entity com.ejb3inaction.actionbazaar.persistence.Order on table ORDERS
12:41:11,084 INFO [Version] Hibernate Validator 3.1.0.GA
12:41:11,115 INFO [HibernateSearchEventListenerRegister] Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled.
12:41:11,193 INFO [ConnectionProviderFactory] Initializing connection provider: org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider
12:41:11,209 INFO [InjectedDataSourceConnectionProvider] Using provided datasource
12:41:11,209 INFO [SettingsFactory] RDBMS: MySQL, version: 5.5.19
12:41:11,209 INFO [SettingsFactory] JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.1.18 ( Revision: [e-mail]-20110930151701-jfj14ddfq48ifkfq )
12:41:11,224 INFO [Dialect] Using dialect: org.hibernate.dialect.MySQLDialect
12:41:11,240 INFO [TransactionFactoryFactory] Transaction strategy: org.hibernate.ejb.transaction.JoinableCMTTransactionFactory
12:41:11,240 INFO [TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup
12:41:11,240 INFO [TransactionManagerLookupFactory] instantiated TransactionManagerLookup
12:41:11,240 INFO [SettingsFactory] Automatic flush during beforeCompletion(): disabled
12:41:11,240 INFO [SettingsFactory] Automatic session close at end of transaction: disabled
12:41:11,240 INFO [SettingsFactory] JDBC batch size: 15
12:41:11,240 INFO [SettingsFactory] JDBC batch updates for versioned data: disabled
12:41:11,240 INFO [SettingsFactory] Scrollable result sets: enabled
12:41:11,256 INFO [SettingsFactory] JDBC3 getGeneratedKeys(): enabled
12:41:11,256 INFO [SettingsFactory] Connection release mode: auto
12:41:11,256 INFO [SettingsFactory] Maximum outer join fetch depth: 2
12:41:11,256 INFO [SettingsFactory] Default batch fetch size: 1
12:41:11,256 INFO [SettingsFactory] Generate SQL with comments: disabled
12:41:11,256 INFO [SettingsFactory] Order SQL updates by primary key: disabled
12:41:11,256 INFO [SettingsFactory] Order SQL inserts for batching: disabled
12:41:11,256 INFO [SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
12:41:11,256 INFO [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory
12:41:11,256 INFO [SettingsFactory] Query language substitutions: {}
12:41:11,256 INFO [SettingsFactory] JPA-QL strict compliance: enabled
12:41:11,256 INFO [SettingsFactory] Second-level cache: enabled
12:41:11,256 INFO [SettingsFactory] Query cache: disabled
12:41:11,271 INFO [SettingsFactory] Cache region factory : org.hibernate.cache.impl.bridge.RegionFactoryCacheProviderBridge
12:41:11,271 INFO [RegionFactoryCacheProviderBridge] Cache provider: org.hibernate.cache.HashtableCacheProvider
12:41:11,271 INFO [SettingsFactory] Optimize cache for minimal puts: disabled
12:41:11,271 INFO [SettingsFactory] Cache region prefix: persistence.unit:unitName=chapter2.ear/chapter2-ejb.jar#actionBazaar
12:41:11,271 INFO [SettingsFactory] Structured second-level cache entries: disabled
12:41:11,287 INFO [SettingsFactory] Statistics: disabled
12:41:11,287 INFO [SettingsFactory] Deleted entity synthetic identifier rollback: disabled
12:41:11,287 INFO [SettingsFactory] Default entity-mode: pojo
12:41:11,287 INFO [SettingsFactory] Named query checking : enabled
12:41:11,334 INFO [SessionFactoryImpl] building session factory
12:41:11,443 INFO [SessionFactoryObjectFactory] Factory name: persistence.unit:unitName=chapter2.ear/chapter2-ejb.jar#actionBazaar
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}
12:41:11,458 INFO [NamingHelper] Creating subcontext: persistence.unit:unitName=chapter2.ear
12:41:11,458 INFO [SessionFactoryObjectFactory] Bound factory to JNDI name: persistence.unit:unitName=chapter2.ear/chapter2-ejb.jar#actionBazaar
12:41:11,458 WARN [SessionFactoryObjectFactory] InitialContext did not implement EventContext
12:41:11,474 INFO [SchemaUpdate] Running hbm2ddl schema update
12:41:11,474 INFO [SchemaUpdate] fetching database metadata
12:41:11,474 INFO [SchemaUpdate] updating schema
12:41:11,490 INFO [TableMetadata] table found: localDB.bids
12:41:11,490 INFO [TableMetadata] columns: [bid_id, bidder_id, bid_price, item_id, bid_date]
12:41:11,505 INFO [TableMetadata] foreign keys: []
12:41:11,505 INFO [TableMetadata] indexes: [primary]
12:41:11,521 INFO [TableMetadata] table found: localDB.orders
12:41:11,521 INFO [TableMetadata] columns: [bidder_id, account_number, status, street, state, expiry_date, order_id, city, credit_card_type]
12:41:11,521 INFO [TableMetadata] foreign keys: []
12:41:11,521 INFO [TableMetadata] indexes: [primary]
12:41:11,521 INFO [SchemaUpdate] schema update complete
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}
12:41:11,692 INFO [EJBContainer] STARTED EJB: com.ejb3inaction.actionbazaar.buslogic.OrderBillingMDB ejbName: OrderBillingMDB
12:41:11,739 INFO [SessionSpecContainer] Starting jboss.j2ee:ear=chapter2.ear,jar=chapter2-ejb.jar,name=PlaceOrderBean,service=EJB3
12:41:11,770 WARN [JmsActivation] Failure in jms activation org.jboss.resource.adapter.jms.inflow.JmsActivationSpec@530c1ac9(ra=org.jboss.resource.adapter.jms.JmsResourceAdapter@65368aae destination=
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
e DLQHandler=org.jboss.resource.adapter.jms.inflow.dlq.GenericDLQHandler DLQJndiName=queue/DLQ DLQUser=null DLQMaxResent=5)
javax.naming.NameNotFoundException: DLQ not bound
at org.jnp.server.NamingServer.getBinding(NamingServer.java:771)
at org.jnp.server.NamingServer.getBinding(NamingServer.java:779)
at org.jnp.server.NamingServer.getObject(NamingServer.java:785)
at org.jnp.server.NamingServer.lookup(NamingServer.java:443)
at org.jnp.server.NamingServer.lookup(NamingServer.java:399)
at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:722)
at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:682)
at javax.naming.InitialContext.lookup(InitialContext.java:392)
at org.jboss.util.naming.Util.lookup(Util.java:222)
at org.jboss.resource.adapter.jms.inflow.dlq.AbstractDLQHandler.setupDLQDestination(AbstractDLQHandler.java:106)
at org.jboss.resource.adapter.jms.inflow.dlq.AbstractDLQHandler.setup(AbstractDLQHandler.java:82)
at org.jboss.resource.adapter.jms.inflow.dlq.JBossMQDLQHandler.setup(JBossMQDLQHandler.java:48)
at org.jboss.resource.adapter.jms.inflow.JmsActivation.setupDLQ(JmsActivation.java:413)
at org.jboss.resource.adapter.jms.inflow.JmsActivation.setup(JmsActivation.java:351)
at org.jboss.resource.adapter.jms.inflow.JmsActivation$SetupActivation.run(JmsActivation.java:729)
at org.jboss.resource.work.WorkWrapper.execute(WorkWrapper.java:213)
at org.jboss.util.threadpool.BasicTaskWrapper.run(BasicTaskWrapper.java:260)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
12:41:11,786 INFO [EJBContainer] STARTED EJB: com.ejb3inaction.actionbazaar.buslogic.PlaceOrderBean ejbName: PlaceOrderBean
12:41:11,802 INFO [SessionSpecContainer] Starting jboss.j2ee:ear=chapter2.ear,jar=chapter2-ejb.jar,name=PlaceBid,service=EJB3
12:41:11,802 INFO [EJBContainer] STARTED EJB: com.ejb3inaction.actionbazaar.buslogic.PlaceBidBean ejbName: PlaceBid
12:41:11,817 INFO [JndiSessionRegistrarBase] Binding the following Entries in Global JNDI:
chapter2/PlaceBid/remote - EJB3.x Default Remote Business Interface
chapter2/PlaceBid/remote-com.ejb3inaction.actionbazaar.buslogic.PlaceBid - EJB3.x Remote Business Interface
12:41:11,833 INFO [JndiSessionRegistrarBase] Binding the following Entries in Global JNDI:
chapter2/PlaceOrderBean/remote - EJB3.x Default Remote Business Interface
chapter2/PlaceOrderBean/remote-com.ejb3inaction.actionbazaar.buslogic.PlaceOrder - EJB3.x Remote Business Interface
12:41:11,895 ERROR [ProfileServiceBootstrap] Failed to load profile: Summary of incomplete deployments (SEE PREVIOUS ERRORS FOR DETAILS):
DEPLOYMENTS MISSING DEPENDENCIES:
Deployment "jboss.messaging.connectionfactory:service=ClusterPullConnectionFactory" is missing the following dependencies:
Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "**ERROR**")
Deployment "jboss.messaging.connectionfactory:service=ClusteredConnectionFactory" is missing the following dependencies:
Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "**ERROR**")
Deployment "jboss.messaging.connectionfactory:service=ConnectionFactory" is missing the following dependencies:
Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "**ERROR**")
Deployment "jboss.messaging.destination:name=DLQ,service=Queue" is missing the following dependencies:
Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "**ERROR**")
Deployment "jboss.messaging.destination:name=ExpiryQueue,service=Queue" is missing the following dependencies:
Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "**ERROR**")
DEPLOYMENTS IN ERROR:
Deployment "jboss.mq.destination:name=ShippingRequestQueue,service=Queue" is in error due to the following reason(s): java.lang.NullPointerException
Deployment "jboss.messaging:service=PostOffice" is in error due to the following reason(s): java.lang.IllegalStateException: Failed to excecute transaction, **ERROR**
Deployment "jboss.mq.destination:name=OrderBillingQueue,service=Queue" is in error due to the following reason(s): java.lang.NullPointerException
Deployment "jboss:service=KeyGeneratorFactory,type=HiLo" is in error due to the following reason(s): java.sql.SQLException: Access is denied
12:41:11,911 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-127.0.0.1-8080
12:41:11,942 INFO [AjpProtocol] Starting Coyote AJP/1.3 on ajp-127.0.0.1-8009
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
12:41:21,786 INFO [JmsActivation] Attempting to reconnect org.jboss.resource.adapter.jms.inflow.JmsActivationSpec@530c1ac9(ra=org.jboss.resource.adapter.jms.JmsResourceAdapter@65368aae destination=jm
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
DLQHandler=org.jboss.resource.adapter.jms.inflow.dlq.GenericDLQHandler DLQJndiName=queue/DLQ DLQUser=null DLQMaxResent=5)
12:41:21,818 ERROR [JmsActivation] Unable to reconnect org.jboss.resource.adapter.jms.inflow.JmsActivationSpec@530c1ac9(ra=org.jboss.resource.adapter.jms.JmsResourceAdapter@65368aae destination=jms/Or
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
andler=org.jboss.resource.adapter.jms.inflow.dlq.GenericDLQHandler DLQJndiName=queue/DLQ DLQUser=null DLQMaxResent=5)
javax.naming.NameNotFoundException: DLQ not bound
at org.jnp.server.NamingServer.getBinding(NamingServer.java:771)
at org.jnp.server.NamingServer.getBinding(NamingServer.java:779)
at org.jnp.server.NamingServer.getObject(NamingServer.java:785)
at org.jnp.server.NamingServer.lookup(NamingServer.java:443)
at org.jnp.server.NamingServer.lookup(NamingServer.java:399)
at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:722)
at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:682)
at javax.naming.InitialContext.lookup(InitialContext.java:392)
at org.jboss.util.naming.Util.lookup(Util.java:222)
at org.jboss.resource.adapter.jms.inflow.dlq.AbstractDLQHandler.setupDLQDestination(AbstractDLQHandler.java:106)
at org.jboss.resource.adapter.jms.inflow.dlq.AbstractDLQHandler.setup(AbstractDLQHandler.java:82)
at org.jboss.resource.adapter.jms.inflow.dlq.JBossMQDLQHandler.setup(JBossMQDLQHandler.java:48)
at org.jboss.resource.adapter.jms.inflow.JmsActivation.setupDLQ(JmsActivation.java:413)
at org.jboss.resource.adapter.jms.inflow.JmsActivation.setup(JmsActivation.java:351)
at org.jboss.resource.adapter.jms.inflow.JmsActivation.handleFailure(JmsActivation.java:292)
at org.jboss.resource.adapter.jms.inflow.JmsActivation$SetupActivation.run(JmsActivation.java:733)
at org.jboss.resource.work.WorkWrapper.execute(WorkWrapper.java:213)
at org.jboss.util.threadpool.BasicTaskWrapper.run(BasicTaskWrapper.java:260)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
12:41:31,958 INFO [JmsActivation] Attempting to reconnect org.jboss.resource.adapter.jms.inflow.JmsActivationSpec@530c1ac9(ra=org.jboss.resource.adapter.jms.JmsResourceAdapter@65368aae destination=jm
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
DLQHandler=org.jboss.resource.adapter.jms.inflow.dlq.GenericDLQHandler DLQJndiName=queue/DLQ DLQUser=null DLQMaxResent=5)
12:41:31,958 ERROR [JmsActivation] Unable to reconnect org.jboss.resource.adapter.jms.inflow.JmsActivationSpec@530c1ac9(ra=org.jboss.resource.adapter.jms.JmsResourceAdapter@65368aae destination=jms/Or
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
andler=org.jboss.resource.adapter.jms.inflow.dlq.GenericDLQHandler DLQJndiName=queue/DLQ DLQUser=null DLQMaxResent=5)
javax.naming.NameNotFoundException: DLQ not bound
at org.jnp.server.NamingServer.getBinding(NamingServer.java:771)
at org.jnp.server.NamingServer.getBinding(NamingServer.java:779)
at org.jnp.server.NamingServer.getObject(NamingServer.java:785)
at org.jnp.server.NamingServer.lookup(NamingServer.java:443)
at org.jnp.server.NamingServer.lookup(NamingServer.java:399)
at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:722)
at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:682)
at javax.naming.InitialContext.lookup(InitialContext.java:392)
at org.jboss.util.naming.Util.lookup(Util.java:222)
at org.jboss.resource.adapter.jms.inflow.dlq.AbstractDLQHandler.setupDLQDestination(AbstractDLQHandler.java:106)
at org.jboss.resource.adapter.jms.inflow.dlq.AbstractDLQHandler.setup(AbstractDLQHandler.java:82)
at org.jboss.resource.adapter.jms.inflow.dlq.JBossMQDLQHandler.setup(JBossMQDLQHandler.java:48)
at org.jboss.resource.adapter.jms.inflow.JmsActivation.setupDLQ(JmsActivation.java:413)
at org.jboss.resource.adapter.jms.inflow.JmsActivation.setup(JmsActivation.java:351)
at org.jboss.resource.adapter.jms.inflow.JmsActivation.handleFailure(JmsActivation.java:292)
at org.jboss.resource.adapter.jms.inflow.JmsActivation$SetupActivation.run(JmsActivation.java:733)
at org.jboss.resource.work.WorkWrapper.execute(WorkWrapper.java:213)
at org.jboss.util.threadpool.BasicTaskWrapper.run(BasicTaskWrapper.java:260)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)

[Paul Clapham]

But that message doesn't come from MySQL. It comes from HSQL, as you can tell by the next line in the log:

Caused by: java.sql.SQLException: Access is denied
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

[Sachin Pachari]

there are two possiblities,

1.You must have forgot to remove the hsql instance from your code, its running somewhere.
2.Check your user name ans password, or try it with a new user name and password.