petclinicは、Springフレームワークのテスト駆動サンプルアプリケーションである。 詳細は、下記を参照。 http://static.springsource.org/docs/petclinic.html データベースアクセスのデフォルト設定は、HSQLDBというin-memoryDBである。MySQLを使いたい場合は、下記の修正が必要。 １.data-access.properties # HSQL Settingsをコメントアウトして、# MySQL Settingsのコメントを外す ２.pom.xml mysql-connector-javaのdependencyを有効にし、hsqldbをコメントアウトする 修正後のpom.xml <?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>org.springframework.samples</groupId> <artifactId>spring-petclinic</artifactId> <version>1.0.0-SNAPSHOT</version> <name>petclinic</name> <packaging>war</packaging> <properties> <!-- Generic properties --> <java.version>1.6</java.version> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding> <!-- Spring --> <spring-framework.version>3.2.3.RELEASE</spring-framework.version> <spring-data-jpa.version>1.3.2.RELEASE</spring-data-jpa.version> <!-- Java EE / Java SE dependencies --> <jsp.version>2.2</jsp.version> <jstl.version>1.2</jstl.version> <servlet.version>2.5</servlet.version> <jaxb-impl.version>2.2.7</jaxb-impl.version> <!-- Hibernate / JPA --> <hibernate.version>4.2.1.Final</hibernate.version> <!-- Bean validation --> <hibernate-validator.version>4.3.1.Final</hibernate-validator.version> <!-- Database access --> <tomcat-jdbc.version>7.0.41</tomcat-jdbc.version> <ehcache.version>2.6.6</ehcache.version> <hsqldb.version>2.2.9</hsqldb.version> <!-- AOP --> <aspectj.version>1.7.3</aspectj.version> <!-- Logging --> <logback.version>1.0.13</logback.version> <slf4j.version>1.7.5</slf4j.version> <!-- RSS --> <rome.version>1.0</rome.version> <!-- Test --> <junit.version>4.11</junit.version> <hamcrest.version>1.3</hamcrest.version> <!-- Dates --> <jodatime-hibernate.version>1.3</jodatime-hibernate.version> <jodatime-jsptags.version>1.1.1</jodatime-jsptags.version> <jodatime.version>2.2</jodatime.version> <jadira-usertype-core.version>3.1.0.CR8</jadira-usertype-core.version> <!-- Web dependencies --> <webjars-bootstrap.version>2.3.0</webjars-bootstrap.version> <webjars-jquery-ui.version>1.9.2</webjars-jquery-ui.version> <webjars-jquery.version>1.9.0</webjars-jquery.version> <dandelion.datatables.version>0.8.14</dandelion.datatables.version> <mysql.version>5.1.22</mysql.version> </properties> <dependencies> <dependency> <groupId>org.jadira.usertype</groupId> <artifactId>usertype.core</artifactId> <version>${jadira-usertype-core.version}</version> </dependency> <dependency> <groupId>javax.servlet</groupId> <artifactId>jstl</artifactId> <version>${jstl.version}</version> </dependency> <dependency> <groupId>javax.servlet</groupId> <artifactId>servlet-api</artifactId> <version>${servlet.version}</version> <scope>provided</scope> </dependency> <dependency> <groupId>javax.servlet.jsp</groupId> <artifactId>jsp-api</artifactId> <version>${jsp.version}</version> <scope>provided</scope> </dependency> <dependency> <groupId>com.sun.xml.bind</groupId> <artifactId>jaxb-impl</artifactId> <version>${jaxb-impl.version}</version> <scope>provided</scope> </dependency> <!-- SPRING, SPRING, SPRINGITY SPRING --> <dependency> <groupId>org.springframework.data</groupId> <artifactId>spring-data-jpa</artifactId> <version>${spring-data-jpa.version}</version> <exclusions> <exclusion> <groupId>org.springframework</groupId> <artifactId>*</artifactId> </exclusion> </exclusions> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>${spring-framework.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-aop</artifactId> <version>${spring-framework.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>${spring-framework.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-tx</artifactId> <version>${spring-framework.version}</version> </dependency> <!-- used for EhCacheCacheManager --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context-support</artifactId> <version>${spring-framework.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-orm</artifactId> <version>${spring-framework.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-oxm</artifactId> <version>${spring-framework.version}</version> <exclusions> <exclusion> <groupId>commons-lang</groupId> <artifactId>commons-lang</artifactId> </exclusion> </exclusions> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jms</artifactId> <version>${spring-framework.version}</version> </dependency> <!-- Database connection pool See here for more details on commons-dbcp versus tomcat-jdbc: http://blog.ippon.fr/2013/03/13/improving-the-performance-of-the-spring-petclinic-sample-application-part-3-of-5/ --> <dependency> <groupId>org.apache.tomcat</groupId> <artifactId>tomcat-jdbc</artifactId> <version>${tomcat-jdbc.version}</version> <scope>runtime</scope> </dependency> <!-- Logging with SLF4J & LogBack --> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-api</artifactId> <version>${slf4j.version}</version> <scope>compile</scope> </dependency> <dependency> <groupId>ch.qos.logback</groupId> <artifactId>logback-classic</artifactId> <version>${logback.version}</version> <scope>runtime</scope> </dependency> <!-- used for Atom --> <dependency> <groupId>rome</groupId> <artifactId>rome</artifactId> <version>${rome.version}</version> </dependency>
<!-- Date and Time --> <dependency> <groupId>joda-time</groupId> <artifactId>joda-time</artifactId> <version>${jodatime.version}</version> </dependency> <dependency> <groupId>joda-time</groupId> <artifactId>joda-time-hibernate</artifactId> <version>${jodatime-hibernate.version}</version> </dependency> <dependency> <groupId>joda-time</groupId> <artifactId>joda-time-jsptags</artifactId> <version>${jodatime-jsptags.version}</version> </dependency> <!-- Databases - Uses HSQL by default --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>${mysql.version}</version> </dependency> <!-- <dependency> <groupId>org.hsqldb</groupId> <artifactId>hsqldb</artifactId> <version>${hsqldb.version}</version> <scope>runtime</scope> </dependency> --> <!-- For MySql only --> <!-- <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>${mysql.version}</version> </dependency> --> <!-- HIBERNATE --> <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-entitymanager</artifactId> <version>${hibernate.version}</version> </dependency> <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-validator</artifactId> <version>${hibernate-validator.version}</version> </dependency>
<dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-ehcache</artifactId> <version>${hibernate.version}</version> </dependency> <dependency> <groupId>net.sf.ehcache</groupId> <artifactId>ehcache-core</artifactId> <version>${ehcache.version}</version> <exclusions> <exclusion> <groupId>commons-logging</groupId> <artifactId>commons-logging</artifactId> </exclusion> </exclusions> </dependency> <!-- Webjars (static dependencies distributed as JAR files) --> <dependency> <groupId>org.webjars</groupId> <artifactId>bootstrap</artifactId> <version>${webjars-bootstrap.version}</version> </dependency> <dependency> <groupId>org.webjars</groupId> <artifactId>jquery-ui</artifactId> <version>${webjars-jquery-ui.version}</version> </dependency> <dependency> <groupId>org.webjars</groupId> <artifactId>jquery</artifactId> <version>${webjars-jquery.version}</version> </dependency>
<!-- Test Artifacts --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-test</artifactId> <version>${spring-framework.version}</version> <scope>test</scope> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>${junit.version}</version> <scope>test</scope> </dependency> <!-- used by Spring MVC Test framework --> <dependency> <groupId>org.hamcrest</groupId> <artifactId>hamcrest-library</artifactId> <version>${hamcrest.version}</version> <scope>test</scope> </dependency> <dependency> <groupId>org.aspectj</groupId> <artifactId>aspectjrt</artifactId> <version>${aspectj.version}</version> </dependency> <dependency> <groupId>org.aspectj</groupId> <artifactId>aspectjweaver</artifactId> <version>${aspectj.version}</version> <scope>runtime</scope> </dependency> <!-- Dandelion --> <dependency> <groupId>com.github.dandelion</groupId> <artifactId>datatables-jsp</artifactId> <version>${dandelion.datatables.version}</version> </dependency> <dependency> <groupId>com.github.dandelion</groupId> <artifactId>datatables-export-itext</artifactId> <version>${dandelion.datatables.version}</version> </dependency> <dependency> <groupId>com.github.dandelion</groupId> <artifactId>datatables-servlet2</artifactId> <version>${dandelion.datatables.version}</version> </dependency> </dependencies> <!-- Maven plugin versions are mentioned in order to guarantee the build reproducibility in the long term --> <build> <defaultGoal>install</defaultGoal> <testResources> <testResource> <!-- declared explicitly so Spring config files can be placed next to their corresponding JUnit test class (see example with ValidatorTests) --> <directory>${project.basedir}/src/test/java</directory> </testResource> <testResource> <directory>${project.basedir}/src/test/resources</directory> </testResource> </testResources> <plugins> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-compiler-plugin</artifactId> <version>3.0</version> <configuration> <compilerArguments> <Xlint /> </compilerArguments> <verbose>true</verbose> <source>${java.version}</source> <target>${java.version}</target> <showWarnings>true</showWarnings> </configuration> </plugin> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-surefire-plugin</artifactId> <version>2.13</version> <configuration> <includes> <include>**/*Tests.java</include> </includes> </configuration> </plugin> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-war-plugin</artifactId> <version>2.3</version> <configuration> <warName>petclinic</warName> </configuration> </plugin> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-eclipse-plugin</artifactId> <version>2.9</version> <configuration> <downloadSources>true</downloadSources> <downloadJavadocs>true</downloadJavadocs> <wtpversion>2.0</wtpversion> <sourceIncludes> <sourceInclude>**/*.*</sourceInclude> </sourceIncludes> <additionalBuildcommands> <buildCommand> <name>org.springframework.ide.eclipse.core.springbuilder</name> </buildCommand> <buildCommand> <name>org.eclipse.m2e.core.maven2Builder</name> </buildCommand> </additionalBuildcommands> <additionalProjectnatures> <projectnature>org.eclipse.jdt.core.javanature</projectnature> <projectnature>org.springframework.ide.eclipse.core.springnature</projectnature> <projectnature>org.eclipse.m2e.core.maven2Nature</projectnature> </additionalProjectnatures> </configuration> </plugin> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-assembly-plugin</artifactId> <version>2.4</version> <configuration> <descriptorRefs> <descriptorRef>jar-with-dependencies</descriptorRef> </descriptorRefs> </configuration> </plugin> <plugin> <groupId>org.apache.tomcat.maven</groupId> <artifactId>tomcat7-maven-plugin</artifactId> <version>2.0</version> <configuration> <server>tomcat-development-server</server> <port>9966</port> <path>/petclinic</path> </configuration> </plugin> </plugins> </build> </project> 修正後のdata-access.properties # Properties file with JDBC and JPA settings. # # Applied by <context:property-placeholder location="jdbc.properties"/> from # various application context XML files (e.g., "applicationContext-*.xml"). # Targeted at system administrators, to avoid touching the context XML files. #------------------------------------------------------------------------------- # HSQL Settings #jdbc.driverClassName=org.hsqldb.jdbcDriver #jdbc.url=jdbc:hsqldb:mem:petclinic #jdbc.username=sa #jdbc.password= # Properties that control the population of schema and data for a new data source #jdbc.initLocation=classpath:db/hsqldb/initDB.sql #jdbc.dataLocation=classpath:db/hsqldb/populateDB.sql # Property that determines which database to use with an AbstractJpaVendorAdapter #jpa.database=HSQL jpa.showSql=true #------------------------------------------------------------------------------- # MySQL Settings jdbc.driverClassName=com.mysql.jdbc.Driver jdbc.url=jdbc:mysql://localhost:3306/petclinic jdbc.username=root jdbc.password= # Properties that control the population of schema and data for a new data source jdbc.initLocation=classpath:db/mysql/initDB.sql jdbc.dataLocation=classpath:db/mysql/populateDB.sql # Property that determines which Hibernate dialect to use # (only applied with "applicationContext-hibernate.xml") #hibernate.dialect=org.hibernate.dialect.MySQLDialect # Property that determines which database to use with an AbstractJpaVendorAdapter jpa.database=MYSQL Google+By Zhang Wenxu |
投稿 >
