[Building Sakai] Sakai 2.7 with mysql 5.5 and SAKAI_PERSON_T?

[Earle Nietzel]

I believe the type on those needs to be set to text for it to work
appropriately.

i.e.
This is wrong:
<property name="notes" column="NOTES" type="string" length="75000" />

This is correct:
<property name="notes" column="NOTES" type="text" length="75000" />

As John commented, the number 75000 was just a number I came up with.
I think any number should work within the range 1 - Integer.MAX_VALUE.

Earle


On Wed, May 18, 2011 at 10:11 PM, John Bush <john.bush at rsmart.com> wrote:
> increasing the length while using type of string breaks oracle, increasing
> length while using type of text works universally.  current settings break
> mysql when using the innodb5 dialect. im suggesting type=text length=75000
> or more, which requires oracle start using clobs but works for mysql all
> dialects, db2 , and oracle
>
> Not sent with my iphone.
>
> On May 18, 2011 4:33 PM, "Steve Swinsburg" <steve.swinsburg at gmail.com>
> wrote:
>
> Hi John,
>
>> This does not work for Oracle, the tries to create everything like longs,
>> hibernate generates this...
>
> Which part doesn't work? The current settings (4000) or the new ones
> (75000)?
>
> The HBM for SAKAI_PERSON_T already specifies both type and length:
> https://source.sakaiproject.org/svn//common/trunk/impl/src/java/org/sakaiproject/component/common/edu/person/SakaiPersonImpl.hbm.xml
> Currently, for the large fields, it is something like:
>
> <property name="notes" column="NOTES" type="string" length="4000" />
>
> So can you confirm that increasing the length to something like 75000 makes
> Hibernate behave on both Oracle and MySQL?
> thanks,
> Steve
>
>
> On 19/05/2011, at 6:40 AM, John Bush wrote:
>
>> This does not work for Oracle, the tries to create everything like longs,
>> hibernate generates this...
>
> <sakai_person.patch>
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org
> with a subject of "unsubscribe"
>