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

[John Bush]

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>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110518/2d21f1f0/attachment.html