[jboss-jira] [JBoss JIRA] Resolved: (JBPORTAL-1880) problem with JBP_REG_PROP_DESC_USAGES table
[ http://jira.jboss.com/jira/browse/JBPORTAL-1880?page=all ]
Thomas Heute resolved JBPORTAL-1880.
------------------------------------
Resolution: Done
Assignee: Thomas Heute (was: Chris Laprun)
The issue is that it tried to do:
create table JBP_REG_PROP_DESC_USAGES (PK bigint not null, USAGE varchar(255) not null,
IDX integer not null, primary key (PK, IDX));
And on mysql, usage is a reserved keyword :-/ (So not related to HA but related to MySQL)
I change that column name to DESC_USAGE
problem with JBP_REG_PROP_DESC_USAGES table
-------------------------------------------
Key: JBPORTAL-1880
URL: http://jira.jboss.com/jira/browse/JBPORTAL-1880
Project: JBoss Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Portal WSRP
Affects Versions: 2.6.4 Final
Reporter: Prabhat Jha
Assigned To: Thomas Heute
Fix For: 2.6.4 Final
Attachments: wsrp-table-error.log
Work Flow:
1. Wiped out portal database in mysql.
2. Started portal with jboss-portal-ha.sar
3. Went to WSRP admin UI.
4. Added bea and after entering consumer registration as "public" , save and
refresh throws
java.sql.BatchUpdateException: Table 'portal.JBP_REG_PROP_DESC_USAGES'
doesn't exist
com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1257)
com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:943)
Attached is the output of "grep JBP_REG_PROP_DESC_USAGES" on server.log. I
would like to see this fixed in 2.6.4 itself.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira