[jboss-user] [JBoss Portal] - Re: WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: 01

[PeterJ]

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