r3T3k’t

Another JBoss/MySQL Installation Hurdle

June 12, 2008 – 6:00 am

As I was trying to re-install Eclipse/JBoss/MySQL, which is a multi-stepped laborious process, I stumbled into an annoying error that perhaps to me longer to remedy than it should have.

 

when running server w/ EJBs installed, I encountered the following error:

 

<pre>10:21:38,524 ERROR [URLDeploymentScanner] Incomplete Deployment listing:

 

— MBeans waiting for other MBeans —

ObjectName: persistence.units:jar=Intranet.jar,unitName=IntraPU

  State: FAILED

  Reason: javax.persistence.PersistenceException: org.hibernate.HibernateException: Hibernate Dialect must be explicitly set

  I Depend On:

    jboss.jca:service=DataSourceBinding,name=TestDb

    …</pre>

 

 

It was important to note that this was preceded by the exception

<pre>10:21:38,294 WARN  [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null

org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Access denied for user ”@’localhost’ to database ‘frazer_intranetjava’)

at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:179)

at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:577)

at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:262)

at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:500)

at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:341)

at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:315)

at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:396)

at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)

at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)

at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:47)

…</pre>

 

 

The problem was I had not allowed the appropriate permissions for the <strong>test</strong> user in the MySQL database (though I had created the database needed)