API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 30th, 2016
96
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.96 KB | None | 0 0
raw download clone embed print report
  1. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  2. xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
  3. <modelVersion>4.0.0</modelVersion>
  4. <groupId>com.cooldrinker</groupId>
  5. <artifactId>CoolDrinker</artifactId>
  6. <packaging>war</packaging>
  7. <version>0.0.1-SNAPSHOT</version>
  8. <name>CoolDrinker Maven Webapp</name>
  9. <url>http://maven.apache.org</url>
  10.  
  11. <properties>
  12. <spring.version>4.0.1.RELEASE</spring.version>
  13. </properties>
  14.  
  15. <dependencies>
  16. <dependency>
  17. <groupId>com.google.code.findbugs</groupId>
  18. <artifactId>jsr305</artifactId>
  19. <version>3.0.0</version>
  20. </dependency>
  21.  
  22. <dependency>
  23. <groupId>jstl</groupId>
  24. <artifactId>jstl</artifactId>
  25. <version>1.2</version>
  26. </dependency>
  27.  
  28. <dependency>
  29. <groupId>junit</groupId>
  30. <artifactId>junit</artifactId>
  31. <version>3.8.1</version>
  32. <scope>test</scope>
  33. </dependency>
  34.  
  35. <!-- Lombok -->
  36. <dependency>
  37. <groupId>org.projectlombok</groupId>
  38. <artifactId>lombok</artifactId>
  39. <version>1.16.6</version>
  40. <scope>provided</scope>
  41. </dependency>
  42.  
  43. <!-- Spring dependencies -->
  44. <dependency>
  45. <groupId>org.springframework</groupId>
  46. <artifactId>spring-core</artifactId>
  47. <version>${spring.version}</version>
  48. </dependency>
  49.  
  50. <dependency>
  51. <groupId>org.springframework</groupId>
  52. <artifactId>spring-web</artifactId>
  53. <version>${spring.version}</version>
  54. </dependency>
  55.  
  56. <dependency>
  57. <groupId>org.springframework</groupId>
  58. <artifactId>spring-webmvc</artifactId>
  59. <version>${spring.version}</version>
  60. </dependency>
  61.  
  62. <!-- Data service -->
  63. <dependency>
  64. <groupId>org.mybatis</groupId>
  65. <artifactId>mybatis</artifactId>
  66. <version>3.1.1</version>
  67. </dependency>
  68.  
  69. <dependency>
  70. <groupId>org.mybatis</groupId>
  71. <artifactId>mybatis-spring</artifactId>
  72. <version>1.1.1</version>
  73. </dependency>
  74.  
  75. <dependency>
  76. <groupId>org.springframework</groupId>
  77. <artifactId>spring-jdbc</artifactId>
  78. <version>${spring.version}</version>
  79. </dependency>
  80.  
  81. <dependency>
  82. <groupId>mysql</groupId>
  83. <artifactId>mysql-connector-java</artifactId>
  84. <version>5.1.38</version>
  85. </dependency>
  86.  
  87. <dependency>
  88. <groupId>commons-dbcp</groupId>
  89. <artifactId>commons-dbcp</artifactId>
  90. <version>1.4</version>
  91. </dependency>
  92.  
  93. </dependencies>
  94.  
  95. <build>
  96. <finalName>CoolDrinker</finalName>
  97. </build>
  98. </project>
  99.  
  100. <?xml version="1.0" encoding="UTF-8"?>
  101. <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  102. xmlns="http://java.sun.com/xml/ns/javaee"
  103. xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">
  104.  
  105. <display-name>Archetype Created Web Application</display-name>
  106.  
  107. <servlet>
  108. <servlet-name>dispatcher</servlet-name>
  109. <servlet-class>
  110. org.springframework.web.servlet.DispatcherServlet
  111. </servlet-class>
  112. <load-on-startup>1</load-on-startup>
  113. </servlet>
  114.  
  115. <servlet-mapping>
  116. <servlet-name>dispatcher</servlet-name>
  117. <url-pattern>/</url-pattern>
  118. </servlet-mapping>
  119.  
  120. <context-param>
  121. <param-name>contextConfigLocation</param-name>
  122. <param-value>/WEB-INF/dispatcher-servlet.xml</param-value>
  123. </context-param>
  124.  
  125. <listener>
  126. <listener-class>
  127. org.springframework.web.context.ContextLoaderListener
  128. </listener-class>
  129. </listener>
  130.  
  131. </web-app>
  132.  
  133. <beans xmlns="http://www.springframework.org/schema/beans"
  134. xmlns:context="http://www.springframework.org/schema/context"
  135. xmlns:mvc="http://www.springframework.org/schema/mvc"
  136. xmlns:tx="http://www.springframework.org/schema/tx"
  137. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  138. xsi:schemaLocation="
  139. http://www.springframework.org/schema/beans
  140. http://www.springframework.org/schema/beans/spring-beans.xsd
  141. http://www.springframework.org/schema/context
  142. http://www.springframework.org/schema/context/spring-context.xsd
  143. http://www.springframework.org/schema/mvc
  144. http://www.springframework.org/schema/mvc/spring-mvc.xsd
  145. http://www.springframework.org/schema/tx
  146. http://www.springframework.org/schema/tx/spring-tx.xsd">
  147.  
  148. <context:component-scan base-package="com.cooldrinker.controller,
  149. com.cooldrinker.dataservice.service,
  150. com.cooldrinker.mybatis.dao" />
  151.  
  152. <!-- Mybatis configuration -->
  153. <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
  154. <property name="driverClassName" value="com.mysql.jdbc.Driver" />
  155. <property name="url" value="jdbc:mysql//127.0.0.1/cooldrinker" />
  156. <property name="username" value="cooldrinker" />
  157. <property name="password" value="cooldrinker" />
  158. </bean>
  159.  
  160. <tx:annotation-driven transaction-manager="transactionManager" />
  161. <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  162. <property name="dataSource" ref="dataSource" />
  163. </bean>
  164.  
  165. <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
  166. <property name="dataSource" ref="dataSource" />
  167. <property name="typeAliasesPackage" value="com.cooldrinker.mybatis.model"/>
  168. <property name="mapperLocations" value="classpath*:com/cooldrinker/mybatis/mappers/*.xml" />
  169. </bean>
  170.  
  171. <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
  172. <constructor-arg index="0" ref="sqlSessionFactory" />
  173. </bean>
  174.  
  175. <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
  176. <property name="basePackage" value="com.cooldrinker.mybatis.mapper" />
  177. </bean>
  178.  
  179. <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  180. <property name="prefix">
  181. <value>/WEB-INF/views/</value>
  182. </property>
  183. <property name="suffix">
  184. <value>.jsp</value>
  185. </property>
  186. </bean>
  187.  
  188. <mvc:resources mapping="/resources/**" location="/resources/" />
  189.  
  190. <mvc:annotation-driven />
  191.  
  192. </beans>
  193.  
  194. HTTP Status 500 - Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'com.mysql.jdbc.Driver' for connect URL 'jdbc:mysql//127.0.0.1:3306/cooldrinker'
  195.  
  196. type Exception report
  197.  
  198. message Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'com.mysql.jdbc.Driver' for connect URL 'jdbc:mysql//127.0.0.1:3306/cooldrinker'
  199.  
  200. description The server encountered an internal error that prevented it from fulfilling this request.
  201.  
  202. exception
  203.  
  204. org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'com.mysql.jdbc.Driver' for connect URL 'jdbc:mysql//127.0.0.1:3306/cooldrinker'
  205. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:973)
  206. org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:863)
  207. javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
  208. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
  209. javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
  210. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  211.  
  212. root cause
  213.  
  214. org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'com.mysql.jdbc.Driver' for connect URL 'jdbc:mysql//127.0.0.1:3306/cooldrinker'
  215. org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:243)
  216. org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371)
  217. org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:335)
  218. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:105)
  219. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  220. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
  221. com.sun.proxy.$Proxy135.getAdminByUsername(Unknown Source)
  222. com.cooldrinker.controller.AdminLoginController.login(AdminLoginController.java:39)
  223. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  224. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  225. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  226. java.lang.reflect.Method.invoke(Method.java:606)
  227. org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:214)
  228. org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
  229. org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
  230. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:749)
  231. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:690)
  232. org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)
  233. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:945)
  234. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:876)
  235. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)
  236. org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:863)
  237. javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
  238. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
  239. javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
  240. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  241.  
  242. root cause
  243.  
  244. org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'com.mysql.jdbc.Driver' for connect URL 'jdbc:mysql//127.0.0.1:3306/cooldrinker'
  245. org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1452)
  246. org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
  247. org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
  248. org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:205)
  249. org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371)
  250. org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:335)
  251. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:105)
  252. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  253. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
  254. com.sun.proxy.$Proxy135.getAdminByUsername(Unknown Source)
  255. com.cooldrinker.controller.AdminLoginController.login(AdminLoginController.java:39)
  256. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  257. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  258. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  259. java.lang.reflect.Method.invoke(Method.java:606)
  260. org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:214)
  261. org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
  262. org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
  263. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:749)
  264. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:690)
  265. org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)
  266. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:945)
  267. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:876)
  268. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)
  269. org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:863)
  270. javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
  271. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
  272. javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
  273. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  274.  
  275. root cause
  276.  
  277. java.sql.SQLException: No suitable driver
  278. java.sql.DriverManager.getDriver(DriverManager.java:278)
  279. org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1437)
  280. org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
  281. org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
  282. org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:205)
  283. org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371)
  284. org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:335)
  285. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:105)
  286. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  287. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
  288. com.sun.proxy.$Proxy135.getAdminByUsername(Unknown Source)
  289. com.cooldrinker.controller.AdminLoginController.login(AdminLoginController.java:39)
  290. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  291. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  292. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  293. java.lang.reflect.Method.invoke(Method.java:606)
  294. org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:214)
  295. org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
  296. org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
  297. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:749)
  298. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:690)
  299. org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)
  300. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:945)
  301. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:876)
  302. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)
  303. org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:863)
  304. javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
  305. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
  306. javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
  307. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!