How to generate sql script for Spring's embedded database?

Question

I'm using Spring embedded database in my unit tests. From Spring documentantatio:

<jdbc:embedded-database id="dataSource">
    <jdbc:script location="classpath:schema.sql"/>
    <jdbc:script location="classpath:test-data.sql"/>
</jdbc:embedded-database>

There are many examples all over the web which basically tell the same tale. I am able to manually create the sql statements from the production database. I could use mysqldump for example (assuming the SQL produced is accepted by HSQL). But my tables are already defined in .hbm.xml files. Is there a way to generate them automatically into the .sql files?

The purpose of all this is naturally to initialize the database. My immediate intent is to only setup the tables; I'll insert the necessary test data in the unit tests themselves.

You may modify code from my answer about JPA: stackoverflow.com/questions/6856934/… — Slava Semushin
– Slava Semushin, Commented Sep 2, 2012 at 19:34

Rich Cowin · Accepted Answer · 2012-09-02 19:06:12Z

0

You could let Hibernate generate your schema from the mapping file(s). You wouldn't then need to have a script do it for your integration tests. Check out the Hibernate Toolset Guide for how to do this.

Alternatively you could Retag this question for the database you are working with and see the best way of creating a schema generation script.

edited Sep 2, 2012 at 19:06

answered Sep 2, 2012 at 16:51

Rich Cowin

6781 gold badge8 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

denarced Over a year ago

I believe I should go with hibernate as far as I can. I don't want to create unnecessary dependencies with any certain database. How would I create the schema with hibernate?

Rich Cowin Over a year ago

Check out the Hibernate Toolset Guide - docs.jboss.org/hibernate/orm/3.3/reference/en/html/….

Collectives™ on Stack Overflow

How to generate sql script for Spring's embedded database?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related