import.sql and hsqldb

[suryad]

In the Seam hotel booking example, there is the import.sql file. I am wondering how that is getting run. I looked if there is an ant target for example running the SQL into HSQLDB database when the project gets built but there is nothing of the sort. Could someone with considerbaly more experience explain to me how that is working?

Thanks. Much appreciated.

[stu2]

It's a hibernate thing, not seam-related. Check out http://www.hibernate.org/381.html

[matt.drees]

It's part of hibernate.

http://www.google.com/search?hl=en&q=import.sql+hibernate&btnG=Google+Search

[suryad]

Thanks very much for explaining that to me. It makes sense now. I am still new to the whole Seam stack including Hibernate and EJB3 and JSF so I am learning while I go through the tutorials.

I got another question. If one were to not want to use HSQLDB and wanted to use MySQL what would be the configuration xml files that one would have to change to make that happen? I realize of course the driver will change, the dialect for Hibernate will change as well.

I see in the booking example there is an xml file called persistence.xml. In there there is a line:

<jta-data-source>java:/bookingDatasource</jta-data-source>

It seems to me that line needs to be changed but where is that datasource being loaded up from in the first place?

[suryad]

Wait I think I found it. There is a file called booking-ds.xml where it contains the database information etc. So scratch my previous post.