Advertisement
Guest User

Untitled

a guest
Dec 11th, 2016
296
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.57 KB | None | 0 0
  1. WARN: HHH000342: Could not obtain connection to query metadata : Cannot create PoolableConnectionFactory (Unknown database 'tests')
  2.  
  3. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4. xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
  5. <modelVersion>4.0.0</modelVersion>
  6. <groupId>com.springmvc</groupId>
  7. <artifactId>SpringMVC</artifactId>
  8. <packaging>war</packaging>
  9. <version>0.0.1-SNAPSHOT</version>
  10. <name>SpringMVC Maven Webapp</name>
  11. <url>http://maven.apache.org</url>
  12.  
  13. <properties>
  14. <java-version>1.7</java-version>
  15. <org.springframework-version>4.2.1.RELEASE</org.springframework-version>
  16. </properties>
  17.  
  18. <dependencies>
  19. <dependency>
  20. <groupId>junit</groupId>
  21. <artifactId>junit</artifactId>
  22. <version>3.8.1</version>
  23. <scope>test</scope>
  24. </dependency>
  25.  
  26. <dependency>
  27. <groupId>javax.servlet</groupId>
  28. <artifactId>javax.servlet-api</artifactId>
  29. <version>3.1.0</version>
  30. </dependency>
  31.  
  32. <dependency>
  33. <groupId>javax.servlet</groupId>
  34. <artifactId>jstl</artifactId>
  35. <version>1.2</version>
  36. </dependency>
  37.  
  38. <dependency>
  39. <groupId>org.springframework</groupId>
  40. <artifactId>spring-context-support</artifactId>
  41. <version>4.2.1.RELEASE</version>
  42. </dependency>
  43.  
  44. <dependency>
  45. <groupId>org.springframework</groupId>
  46. <artifactId>spring-webmvc</artifactId>
  47. <version>4.2.1.RELEASE</version>
  48. </dependency>
  49.  
  50. <dependency>
  51. <groupId>org.springframework</groupId>
  52. <artifactId>spring-orm</artifactId>
  53. <version>4.2.1.RELEASE</version>
  54. </dependency>
  55.  
  56. <dependency>
  57. <groupId>org.springframework</groupId>
  58. <artifactId>spring-tx</artifactId>
  59. <version>4.2.0.RELEASE</version>
  60. </dependency>
  61.  
  62. <dependency>
  63. <groupId>org.springframework</groupId>
  64. <artifactId>spring-web</artifactId>
  65. <version>4.2.0.RELEASE</version>
  66. </dependency>
  67.  
  68. <dependency>
  69. <groupId>commons-dbcp</groupId>
  70. <artifactId>commons-dbcp</artifactId>
  71. <version>1.4</version>
  72. </dependency>
  73.  
  74. <dependency>
  75. <groupId>mysql</groupId>
  76. <artifactId>mysql-connector-java</artifactId>
  77. <version>5.1.36</version>
  78. </dependency>
  79.  
  80. <dependency>
  81. <groupId>org.codehaus.jackson</groupId>
  82. <artifactId>jackson-mapper-asl</artifactId>
  83. <version>1.9.10</version>
  84. </dependency>
  85.  
  86. <dependency>
  87. <groupId>com.google.code.gson</groupId>
  88. <artifactId>gson</artifactId>
  89. <version>2.3</version>
  90. </dependency>
  91.  
  92. <dependency>
  93. <groupId>org.hibernate</groupId>
  94. <artifactId>hibernate-core</artifactId>
  95. <version>4.1.0.Final</version>
  96. </dependency>
  97.  
  98. <dependency>
  99. <groupId>org.hibernate.javax.persistence</groupId>
  100. <artifactId>hibernate-jpa-2.0-api</artifactId>
  101. <version>1.0.0.Final</version>
  102. </dependency>
  103.  
  104. </dependencies>
  105.  
  106. <build>
  107. <finalName>SpringMVC</finalName>
  108. </build>
  109. </project>
  110.  
  111. <?xml version="1.0" encoding="UTF-8"?>
  112. <beans xmlns="http://www.springframework.org/schema/beans"
  113. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tx="http://www.springframework.org/schema/tx"
  114. xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:context="http://www.springframework.org/schema/context"
  115. xsi:schemaLocation="http://www.springframework.org/schema/beans
  116. http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
  117. http://www.springframework.org/schema/tx
  118. http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
  119. http://www.springframework.org/schema/context
  120. http://www.springframework.org/schema/context/spring-context-3.0.xsd
  121. http://www.springframework.org/schema/mvc
  122. http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd">
  123.  
  124. <!-- Enable autowire -->
  125. <context:annotation-config />
  126. <context:component-scan base-package="com" />
  127.  
  128. <mvc:annotation-driven />
  129.  
  130. <mvc:resources mapping="/resources/**" location="/resources/" />
  131.  
  132. <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
  133. <property name="driverClassName" value="com.mysql.jdbc.Driver" />
  134. <property name="url" value="jdbc:mysql://localhost:3306/tests" />
  135. <property name="username" value="root" />
  136. <property name="password" value="" />
  137. </bean>
  138.  
  139. <!-- Session Factory Declaration -->
  140. <bean id="sessionFactory"
  141. class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
  142. <property name="dataSource" ref="dataSource" />
  143. <property name="packagesToScan" value="com.entities" />
  144. <property name="hibernateProperties">
  145. <props>
  146. <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
  147. <prop key="hibernate.show_sql">true</prop>
  148. <prop key="hibernate.enable_lazy_load_no_trans">true</prop>
  149. <prop key="hibernate.default_schema">test</prop>
  150. <prop key="format_sql">true</prop>
  151. <prop key="use_sql_comments">true</prop>
  152. <!-- <prop key="hibernate.hbm2ddl.auto">create</prop> -->
  153. </props>
  154. </property>
  155. </bean>
  156.  
  157. <tx:annotation-driven transaction-manager="transactionManager" />
  158.  
  159. <bean id="transactionManager"
  160. class="org.springframework.orm.hibernate4.HibernateTransactionManager">
  161. <property name="sessionFactory" ref="sessionFactory" />
  162. </bean>
  163.  
  164. package com.entities;
  165.  
  166. import java.io.Serializable;
  167.  
  168. import javax.persistence.GeneratedValue;
  169. import javax.persistence.GenerationType;
  170. import javax.persistence.Id;
  171. import javax.persistence.Table;
  172.  
  173. @javax.persistence.Entity
  174. @Table(name="users")
  175. public class User implements Serializable {
  176.  
  177. /**
  178. *
  179. */
  180. private static final long serialVersionUID = 1L;
  181. @Id
  182. @GeneratedValue(strategy=GenerationType.IDENTITY)
  183. public int id;
  184.  
  185. private String name;
  186.  
  187. public int getId() {
  188. return id;
  189. }
  190.  
  191. public void setId(int id) {
  192. this.id = id;
  193. }
  194.  
  195. public String getName() {
  196. return name;
  197. }
  198.  
  199. public void setName(String name) {
  200. this.name = name;
  201. }
  202. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement