Error using Hibernate with H2 in database

Question

I'm working with Hibernate. How can I configure my applicationContext.xml to have an H2 in-memory databaseorg.hibernate.dialect.H2Dialect dont work

Spring configuration

 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd"> <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="org.h2.Driver" /> <property name="url" value="jdbc:h2:tcp://localhost/~/test" /> <property name="username" value="sa" /> <property name="password " value="" /> </bean> <bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean" > <property name="dataSource" ref="dataSource"></property> <property name="hibernateProperties"> <props> <prop key="hibernate.dialect">org.hibernate.dialect.H2Dialect</prop> <prop key="hibernate.hbm2ddl.auto">update</prop> <prop key="hibernate.show_sql">true</prop> <prop key="hibernate.format_sql">true</prop> </props> </property> <property name="packagesToScan"> <list> <value>com.emusicstore</value> </list> </property> </bean> <bean id="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager"> <property name="sessionFactory" ref="sessionFactory" /> </bean>

Please, can you give more information what is the error message? — Level_Up
– Level_Up, Commented Sep 18, 2018 at 11:32

Basil Bourque · Accepted Answer · 2018-12-06 21:24:11Z

2

You are not connecting to an in-memory database. Your JDBC URL is for network connection to localhost:

jdbc:h2:tcp://localhost/~/test

To use the in-memory H2 the URL must look like this, containing mem:

jdbc:h2:mem:testdb

In the manual, see the section on In-Memory Database

edited Dec 6, 2018 at 21:24

Basil Bourque

347k130 gold badges950 silver badges1.3k bronze badges

answered Sep 18, 2018 at 11:41

Simon Martinelli

36.6k6 gold badges62 silver badges92 bronze badges

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

1 Comment

Basil Bourque Over a year ago

Also, a tip: Be aware that the in-memory database is discarded, by default, when the connection closes. You can override this behavior. See: Keep H2 in-memory database between connections and H2 in-memory database. Table not found

Seymur Asadov · Accepted Answer · 2018-09-18 11:47:40Z

Use embedded db datasource (with dbcp connection pool) instead of drivermanager datasource.

 <jdbc:embedded-database id="dataSource" type="H2"> <jdbc:script location="classpath:db/sql/create-db.sql" /> <jdbc:script location="classpath:db/sql/insert-data.sql" /> </jdbc:embedded-database> <bean id="dbcpDataSource" class="org.apache.commons.dbcp2.BasicDataSource"> <property name="driverClassName" value="org.h2.Driver" /> <property name="url" value="jdbc:hsqldb:mem:dataSource" /> <property name="username" value="username" /> <property name="password" value="password" /> </bean> <bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean" > <property name="dataSource" ref="dbcpDataSource"></property> <property name="hibernateProperties"> <props> <prop key="hibernate.dialect">org.hibernate.dialect.H2Dialect</prop> <prop key="hibernate.hbm2ddl.auto">update</prop> <prop key="hibernate.show_sql">true</prop> <prop key="hibernate.format_sql">true</prop> </props> </property> <property name="packagesToScan"> <list> <value>com.emusicstore</value> </list> </property> </bean> <bean id="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager"> <property name="sessionFactory" ref="sessionFactory" /> </bean>

Collectives™ on Stack Overflow

Error using Hibernate with H2 in database

2 Answers 2

1 Comment

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Linked

Related