can not create connection to mysql

[surajmundada]

Hi,

my config is Jboss As 5.1.0.GA + Eclipse Galilio + Seam 2.2.0.GA + Jboss Tools 3.1.0

I created a Seam Web Project. my registration-ear/registration.ds looks like

<datasources>
 <local-tx-datasource>
 <jndi-name>registrationDatasource</jndi-name>
 <use-java-context>true</use-java-context>
 <connection-url>jdbc:mysql://localhost:3306/test</connection-url>
 <driver-class>com.mysql.jdbc.Driver</driver-class>
 <user-name>root</user-name>
 <password>root</password>
 </local-tx-datasource>
</datasources>

registration-ejb/ejbModule/META-INF/persistence.xml looks like

<persistence-unit name="registration">
 <provider>org.hibernate.ejb.HibernatePersistence</provider>
 <jta-data-source>java:/registrationDatasource</jta-data-source>
 <properties>
 <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5InnoDBDialect"/>
 <property name="hibernate.hbm2ddl.auto" value="update"/>
 <property name="hibernate.show_sql" value="true"/>
 <property name="hibernate.format_sql" value="true"/>
 <property name="hibernate.default_schema" value="test"/>
 <property name="jboss.entity.manager.factory.jndi.name" value="java:/registrationEntityManagerFactory"/>
 </properties>
 </persistence-unit>

and registration-ejb/hibernate-console.properties looks like

hibernate.connection.password=root
hibernate.connection.username=root
hibernate.connection.driver_class=com.mysql.jdbc.Driver
hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
hibernate.connection.url=jdbc:mysql://localhost:3306/test

hibernate.connection.provider_class=org.hibernate.connection.DriverManagerConnectionProvider
hibernate.datasource=
hibernate.transaction.manager_lookup_class=

when deployed, I get following exception:

org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO))

which is causing javax.ejb.EJBTransactionRolledbackException: @In attribute requires non-null value: register.em

em is reference for EntityManager in my action listener.

Any help?

Suraj

[maxandersen]

your mysql db seem to not be configured for local jdbc access.

Can you connect from java apps via jdbc without problems with the same connection info ?

[surajmundada]

tried a plain java app with jdbc connection and it works.

in case of managed connection pool, why it tries to connect without using password?

Access denied for user 'root'@'localhost' (using password: NO))