error at startup: 'jbossportal.jbp_users' doesn't exist

[neoprem]

I just installed the following on a new machine (Windows XP):
JBoss AS 4.0.4
MySQL 5.0.22
JbossPortal 2.2

I created a database called jbossportal, user=portal, password=****
Granted all privileges to the portal user.

I edited the mysql-ds and portal-mysql-ds appropriately.

When I start the server, I get an exception reported as follows:
java.sql.SQLException: Table 'jbossportal.jbp_users' doesn't exist

However, when I log into mysql -uportal -p****, the table has been successfully created, but there are 0 records.

Is there anything I am missing here? I seem to have followed the instructions correctly.

Thanks
Prem

[theute]

Those errors are correct, at first deployment if the tables don't exist it throws that error and create the table, this is expected.

If you start a new development, you should go with JBossPortal 2.4

[neoprem]

okay, but then the table never gets populated with any user data.
So when I run the portal and try to log in with user/user, or admin/admin, it fails.

When I try to create a new user, it again fails to insert a record in the table.

Thanks
Prem

[theute]

Why do you have 2 datasource decriptors ? I mysql-ds and portal-mysql-ds ?

Watch out the problem with MySQL 5 (see other forum threads and Wiki)

[alesj]

Watch out the problem with MySQL 5 (see other forum threads and Wiki)

What problems?

[neoprem]

Why do you have 2 datasource decriptors ? I mysql-ds and portal-mysql-ds ?

I also use mysql as the db for another application deployed in jboss. The mysql-ds is for that.

Prem

[neoprem]

This issue is resolved. I found the following workaround in the wiki:
http://wiki.jboss.org/wiki/Wiki.jsp?page=AvoidMySQL5DataTruncationErrors

I rechecked my log files and found that the Data truncation: Data too long for column 'jbp_viewrealemail' at row 1 error had shown up at installation time. I had not noticed it earlier.

The steps I followed to resolve this are:
1. Applied the workaround
2. Restarted mysql instance, since the my.ini was changed.
3. I wiped out all the tables in the jbossportal database.
4. I restarted the appserver, the tables got re-created and populated correctly.

Thank you
Prem