[jboss-user] [JBoss Portal] - Re: SQLGrammarException in JBP 2.4

[roy.russo@jboss.com]

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