[Building Sakai] Create tool with tables

[Steve Swinsburg]

Hi Paul,

In your service startup (init) just run the SQL to create the tables. You can check the vendor used as it is set in sakai.properties, and then just run the appropriate SQL.

The hbm.xml you see are the Hibernate mappings, but in your case you don't need this if you are managing the SQL yourself (hopefully using something like Spring JDBC).

cheers,
Steve


On 13/07/2011, at 7:29 AM, Paul Mungai wrote:

> > Kindly advise on the necessary steps to adding an sql table in a new tool.
> 
> I already have the sql as shown:
> 
> mytool/mytool-impl/impl/src/sql/mysql/sakai_mytool.sql
> mytool/mytool-impl/impl/src/sql/oracle/sakai_mytool.sql
> mytool/mytool-impl/impl/src/sql/hsqldb/sakai_mytool.sql
> 
> What more do I need to do to make this work?
> 
> I realized some modules have *.hdb.xml. Is this necessary?
> 
> Unfortunately none of the documentation on confluence addresses the creation of new tables.
> 
> Regards,
> Paul Mungai
> _______________________________________________
> 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"