Mysql allow 1024 key lengths, but since were in UTF8 db setting, its using bytes per... so 255*3 + 255*3 > 1024.
One workaround Im looking at, is to modify the hibernate cfg: | <class | name="org.jboss.portal.core.impl.model.instance.UserInstance" | table="JBP_INSTANCE_PER_USER"> | <cache usage="@portal.hibernate.cache.usage@"/> | <id | name="key" | column="PK" | access="field"> | <generator class="native"> | <param name="sequence">instance_seq</param> | </generator> | </id> | <many-to-one | name="instance" | column="INSTANCE_PK" | class="org.jboss.portal.core.impl.model.instance.InstanceImpl" | cascade="none" | fetch="select"/> | <property | name="state" | column="SER_STATE" | not-null="false" | unique="false" | length="50000000"/> | <properties | name="user_and_portlet_ref" | unique="true"> | <property | name="userId" | column="USER_ID" | not-null="true" | length="170"/> | <property | name="portletRef" | column="PORTLET_REF" | not-null="true" | length="170"/> | </properties> | </class> | This is a shortterm fix, as it requires testing. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3963867#3963867 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3963867 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
