Skip to content

Commit 9b4db0a

Browse files
iluwatariluwatar
committed
iluwatar#55 H2 database taken to use in the example code
1 parent 581ce41 commit 9b4db0a

File tree

6 files changed

+36
-53
lines changed

6 files changed

+36
-53
lines changed

‎repository/pom.xml‎

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -28,5 +28,14 @@
2828
<artifactId>postgresql</artifactId>
2929
<version>9.4-1200-jdbc4</version>
3030
</dependency>
31+
<dependency>
32+
<groupId>commons-dbcp</groupId>
33+
<artifactId>commons-dbcp</artifactId>
34+
<version>1.4</version>
35+
</dependency>
36+
<dependency>
37+
<groupId>com.h2database</groupId>
38+
<artifactId>h2</artifactId>
39+
</dependency>
3140
</dependencies>
3241
</project>

‎repository/src/main/java/com/iluwatar/App.java‎

Lines changed: 0 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -4,11 +4,6 @@
44

55
import org.springframework.context.support.ClassPathXmlApplicationContext;
66

7-
/**
8-
* Standalone application with Spring Data JPA, Hibernate and Maven
9-
*
10-
* @author DevCrumb.com
11-
*/
127
public class App {
138
public static void main(String[] args) {
149
ClassPathXmlApplicationContext context = new ClassPathXmlApplicationContext(

‎repository/src/main/java/com/iluwatar/Person.java‎

Lines changed: 0 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -4,11 +4,6 @@
44
import javax.persistence.GeneratedValue;
55
import javax.persistence.Id;
66

7-
/**
8-
* Person entity
9-
*
10-
* @author DevCrumb.com
11-
*/
127
@Entity
138
public class Person {
149

‎repository/src/main/java/com/iluwatar/PersonDao.java‎

Lines changed: 0 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -5,11 +5,6 @@
55
import org.springframework.data.repository.CrudRepository;
66
import org.springframework.stereotype.Repository;
77

8-
/**
9-
* Person dao interface
10-
*
11-
* @author DevCrumb.com
12-
*/
138
@Repository
149
public interface PersonDao extends CrudRepository<Person, Long> {
1510

‎repository/src/main/resources/META-INF/persistence.xml‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,8 +1,8 @@
11
<?xml version="1.0" encoding="UTF-8"?>
22
<persistence version="1.0"
3-
xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
4-
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
3+
xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
4+
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
55

66
<persistence-unit name="jpaData" />
77

8-
</persistence>
8+
</persistence>

‎repository/src/main/resources/applicationContext.xml‎

Lines changed: 24 additions & 35 deletions
Original file line numberDiff line numberDiff line change
@@ -7,45 +7,34 @@
77
xsi:schemaLocation="
88
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
99
http://www.springframework.org/schema/data/jpa http://www.springframework.org/schema/data/jpa/spring-jpa-1.0.xsd">
10-
10+
1111
<!-- Directory to scan for repository classes -->
1212
<jpa:repositories base-package="com.iluwatar" />
13-
14-
<bean id="dataSource"
15-
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
16-
<property name="driverClassName">
17-
<value>org.postgresql.Driver</value>
18-
</property>
19-
<property name="url">
20-
<value>jdbc:postgresql://localhost:5432/postgres</value>
21-
</property>
22-
<property name="username">
23-
<value>postgres</value>
24-
</property>
25-
<property name="password">
26-
<value>ile666</value>
27-
</property>
28-
</bean>
29-
30-
<bean id="entityManagerFactory"
31-
class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
32-
<property name="dataSource" ref="dataSource" />
33-
<property name="persistenceUnitName" value="jpaData" />
34-
<property name="jpaVendorAdapter">
35-
<bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter" />
36-
</property>
37-
<property name="jpaProperties">
38-
<props>
39-
<prop key="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</prop>
40-
<prop key="hibernate.show_sql">false</prop>
41-
<prop key="hibernate.format_sql">false</prop>
42-
<prop key="hibernate.hbm2ddl.auto">create</prop>
43-
</props>
44-
</property>
45-
</bean>
4613

4714
<bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
4815
<property name="entityManagerFactory" ref="entityManagerFactory" />
4916
</bean>
5017

51-
</beans>
18+
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
19+
destroy-method="close">
20+
<property name="driverClassName" value="org.h2.Driver" />
21+
<property name="url" value="jdbc:h2:~/databases/person" />
22+
<property name="username" value="sa" />
23+
<property name="password" value="sa" />
24+
</bean>
25+
26+
<bean id="entityManagerFactory"
27+
class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
28+
<property name="dataSource" ref="dataSource" />
29+
<property name="packagesToScan" value="com.iluwatar" />
30+
<property name="persistenceProvider">
31+
<bean class="org.hibernate.ejb.HibernatePersistence" />
32+
</property>
33+
<property name="jpaProperties">
34+
<map>
35+
<entry key="hibernate.dialect" value="org.hibernate.dialect.H2Dialect" />
36+
<entry key="hibernate.hbm2ddl.auto" value="update" />
37+
</map>
38+
</property>
39+
</bean>
40+
</beans>

0 commit comments

Comments
 (0)