[
https://issues.apache.org/jira/browse/JS2-1025?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12910429#action_12910429
]
Mansour Al Akeel commented on JS2-1025:
---------------------------------------
Ate:
I am having the same issue. And I just created a portal application from the
artifact. When it didn't work I had to follow the tutorial.
This issue makes the process of deploying jetspeed with mysql impossible. While
tweaking the database for a specific environment is an administrative task and
not to be carried by jetspeed deployment process, this issue is not related to
tweaking the database for specific environment. I would not call getting
jetspeed to work with a default MySQL installation a "specific environment".
MySQL is one of the most popular DBMS.
> Mysql maven2 build error - UNIQUE INDEX key too long
> ----------------------------------------------------
>
> Key: JS2-1025
> URL: https://issues.apache.org/jira/browse/JS2-1025
> Project: Jetspeed 2
> Issue Type: Bug
> Components: Project Build
> Affects Versions: 2.2.2
> Environment: WinXP, jdk 1.6, mysql 5.0.45 community-nt
> Reporter: Evangelos Vlachogiannis
> Priority: Minor
>
> While building a custom j2.2 portal I got the following error:
> Embedded error: Failed to execute: CREATE UNIQUE INDEX
> UIX_PORTLET_PREFERENCE
> ON PORTLET_PREFERENCE (DTYPE, APPLICATION_NAME, PORTLET_NAME, ENTITY_ID,
> USER_NA
> ME, NAME)
> Specified key was too long; max key length is 1000 bytes
> [INFO]
> ------------------------------------------------------------------------
> [INFO] Trace
> org.apache.maven.lifecycle.LifecycleExecutionException: Unexpected error
> I think that the:
> CREATE UNIQUE INDEX UIX_PORTLET_PREFERENCE ON
> PORTLET_PREFERENCE (DTYPE, APPLICATION_NAME, PORTLET_NAME, ENTITY_ID,
> USER_NAME, NAME)
> query needs to be replaced with a shorter index e.g. (DTYPE,
> APPLICATION_NAME, PORTLET_NAME) but I do not know about side effects.
> Please provide fix and deploy also to jars as people cannot build custom
> portals with j2.2 / mysql
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
