[Building Sakai] Is there a way to get hibernate to manage indices?

[Steve Swinsburg]

Hi Charles,

This is a long standing issue. Hibernate doesn't create indexes properly (on MySQL) and we need a hibernate upgrade to fix it:
http://jira.sakaiproject.org/browse/KNL-515

I've tried the database-object approach and it doesn't seem to work properly, even though that is the published workaround. So you might be stuck with some SQL for the time being.

cheers,
Steve


On 28/07/2010, at 10:51 AM, Hedrick Charles wrote:

> We're developing a new tool. We're using hibernate, partly to get its automatic schema management. 
> 
> Unfortunately I've been unable to get it to create indices. I've seen suggestions in a Spring forum that the way Sakai integrates with Hibernate causes Hibernate to ignore everything in the .HBM.XML files except mapping statements, and it looks to me like it ignores index= even in those.
> 
> Am I missing something?
> 
> For the moment I'm using the .sql file mechanism to create indices, but this is much less than ideal.
> 
> I checked for applications that try to use <database-object> I found at least one where the index seems to be missing in my freshly created database. A lot of tools seem to supply both .HBM files and .sql files. The .sql mechanism isn't bad for an annual release, but it's not so convenient during development when things are changing.
> 
> 
> _______________________________________________
> 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"