The latest error you are getting is because the password in the *-ds.xml file does not match the password you used when creating the user.
Here are the statements I use to create the database user and database: CREATE DATABASE portaldb; | GRANT ALL PRIVILEGES ON portaldb.* TO 'username'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION; | And the corresponding portal-ds.xml file contains: <datasources> | <local-tx-datasource> | <jndi-name>PortalDS</jndi-name> | <connection-url>jdbc:mysql://localhost:3306/portaldb?useServerPrepStmts=false&jdbcCompliantTruncation=false</connection-url> | <driver-class>com.mysql.jdbc.Driver</driver-class> | <user-name>username</user-name> | <password>password</password> | <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> | For the first exception you posted, there should have been a "caused by" clause following it. I need to see that clause, and it's stack dump. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4088920#4088920 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4088920 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
