[jboss-user] [JBoss Tools Users] - can not create connection to mysql

[surajmundada@yahoo.com]

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

View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4269988#4269988

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4269988