[Building Sakai] database and new tool

[Aaron Zeckoski]

Disclaimer: These are hibernate specific questions so you may get
better answers on their forums.

There are no hard and fast rules but I would recommend you create a
new hbm.xml file and a new class for each table. If you have never
used hibernate before you will want to check out the documents on
hibernate.org
-AZ


On Wed, Apr 29, 2009 at 3:32 PM, yolima u <yolimita.uribe at gmail.com> wrote:
>
> thanks for your answer, now i have another question about that. :-D
> I have to create some tables from a breakdown in relationship, i mean, the
> components of this tables are foreign keys of primary keys of others tables.
> the question is, have i to do a class for each table of this or i can create
> them in files tool.hbm.xml with the code of the others classes ,
>
> thanks,
>
>
>
> Steve Swinsburg-2 wrote:
>>
>> Hi,
>>
>> Using a project generated by the appbuilder, have a look in the pack/
>> src/webapp/WEB-INF/*.xml
>> The hibernate mapping files (tool.hbm.xml) are registered with the
>> global session factory and when your app comes up with auto.ddl=true
>> the tables are created. You don't need your own hibernate.cfg.xml as
>> you are not using your own connections, you are using connections from
>> the Sakai pool.
>>
>> As for the ddl folder, those are the sql files that are generated from
>> the hibernate mappings. Useful for those that can't use auto.ddl to
>> create the tables so need to run the scripts manually. Also useful for
>> making DB upgrade scripts. Ordinarily you won't need them (yet).
>>
>>
>> cheers,
>> Steve
>>
>>
>> On 27/04/2009, at 11:31 PM, yolima u wrote:
>>
>>>
>>> hi, thanks for the answer.
>>>
>>> well i'm using hibernate but i don't know if i'm using it ok. I
>>> configure my
>>> tool.hbm.xml and my hibernate.cfg.xml like other sakai project but
>>> my tool
>>> didn't create the tables in the database.
>>> i created this tool with sakaiappbuilder and sakaiappbuilder made a
>>> folder
>>> "ddl", in a readme.txt in this folder say that i have to install the
>>> folder
>>> ddl with maven for create *.sql, have i to do this?. why tools like
>>> poll
>>> doesn't have the *.sql and works fine?
>>>
>>>
>>>
>>> Aaron Zeckoski wrote:
>>>>
>>>> We will need a lot more details about your tool in order to help you.
>>>> For example, are you using hibernate or just some JDBC directly (it
>>>> is
>>>> hard to tell since you mention hibernate and also mention a ddl
>>>> file)?
>>>>
>>>> This will probably help in the meantime:
>>>> http://bugs.sakaiproject.org/confluence/display/BOOT/Persistence
>>>>
>>>> -AZ
>>>>
>>>>
>>>> On Mon, Apr 27, 2009 at 6:47 PM, yolima u <yolimita.uribe at gmail.com>
>>>> wrote:
>>>>>
>>>>> hi all, i'm doing a new tool for sakai, but i do'nt know what i
>>>>> have to
>>>>> do
>>>>> for sakai make the tables in the database. The information is all
>>>>> in the
>>>>> hibernate file and in tool/impl/src/sql/mysql/too.sql is the file
>>>>> where
>>>>> it's
>>>>> the create table.
>>>>>
>>>>> i tried with auto dll=true in sakai.properties on tomcat, but it
>>>>> didn't
>>>>> work.
>>>>>
>>>>> thanks
>>>>> --
>>>>> View this message in context:
>>>>> http://www.nabble.com/database-and-new-tool-tp23261466p23261466.html
>>>>> Sent from the Sakai - Development mailing list archive at
>>>>> Nabble.com.
>>>>>
>>>>> _______________________________________________
>>>>> 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"
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Aaron Zeckoski (aaronz at vt.edu)
>>>> Senior Research Engineer - CARET - Cambridge University
>>>> [http://bugs.sakaiproject.org/confluence/display/~aaronz/]
>>>> Sakai Fellow - [http://aaronz-sakai.blogspot.com/]
>>>> _______________________________________________
>>>> 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"
>>>>
>>>>
>>>
>>> --
>>> View this message in context:
>>> http://www.nabble.com/database-and-new-tool-tp23261466p23266649.html
>>> Sent from the Sakai - Development mailing list archive at Nabble.com.
>>>
>>> _______________________________________________
>>> 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"
>>
>>
>>
>> _______________________________________________
>> 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"
>>
>
> --
> View this message in context: http://www.nabble.com/database-and-new-tool-tp23261466p23296090.html
> Sent from the Sakai - Development mailing list archive at Nabble.com.
>
> _______________________________________________
> 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"
>



-- 
Aaron Zeckoski (aaronz at vt.edu)
Senior Research Engineer - CARET - Cambridge University
[http://bugs.sakaiproject.org/confluence/display/~aaronz/]
Sakai Fellow - [http://aaronz-sakai.blogspot.com/]