Spring Testing with H2 db configuration

Question

I use Oracle in production environment and I would like to use H2 for testing. I can type;

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

so my tables and scripts are created automatically. But I cannot set URL value of this db. (For H2-Oracle compatibility I should add ;MODE=Oracle to url part)

is there a way to achieve this goal?

Or just an opposite solution;

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="org.h2.Driver"/>
    <property name="url" value="jdbc:h2:file:h2\db"/>
    <property name="username" value="sa"/>
    <property name="password" value=""/>        
</bean>

in this time, I can edit URL part, but how can I load default test scripts (create and data sqls) to this datasource?

asyard · Accepted Answer · 2011-11-18 10:58:55Z

23

This technique solved the problem;

<bean id="dataSource"
        class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="${jdbc.driverClassName}" />
        <property name="url" value="${jdbc.url}" />
        <property name="username" value="${jdbc.username}" />
        <property name="password" value="${jdbc.password}" />
</bean>

and then adding this tag and definition;

<jdbc:initialize-database data-source="dataSource" ignore-failures="DROPS">
    <jdbc:script location="classpath:testdb/schema.sql" />
    <jdbc:script location="classpath:testdb/data.sql" />
</jdbc:initialize-database>

answered Nov 18, 2011 at 10:58

asyard

1,7435 gold badges21 silver badges44 bronze badges

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

2 Comments

wlk Over a year ago

What is the content of those files? schema.sql and data.sql, do they contain something that you have to setup ?

asyard Over a year ago

hi Wojtek, yes, I need some initial test data. Several contents are IP addresses of many servers, some user roles, city names etc.

Thomas Mueller · Accepted Answer · 2011-11-17 19:11:33Z

13

Maybe this will help: H2 supports an INIT script (a SQL script which is executed when opening the connection). The database URL would look like this in the XML file:

<property name="url" value="jdbc:h2:file:h2\db;INIT=
RUNSCRIPT FROM 'classpath:schema.sql'\;
RUNSCRIPT FROM 'classpath:test-data.sql'"/>

(the ; needs to be escaped with a backslash).

answered Nov 17, 2011 at 19:11

Thomas Mueller

50.4k16 gold badges123 silver badges136 bronze badges

1 Comment

asyard Over a year ago

thank you for your response, my best choice was using Spring-provided approach (jdbc:initialize-database.. etc) without extending url with values. This technique is also helpful. Thank you.

Collectives™ on Stack Overflow

Spring Testing with H2 db configuration

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related