API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 24th, 2016
85
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.50 KB | None | 0 0
raw download clone embed print report
  1. #Database related properties
  2. database.driverClassName=com.mysql.jdbc.Driver
  3. database.url=jdbc:mysql://127.0.0.1:3306/xyz
  4. database.username=root
  5. database.password=root@1234
  6.  
  7. #Hibernate related properties
  8. hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
  9. hibernate.hbm2ddl.auto=update
  10. hibernate.show_sql=true
  11. hibernate.format_sql=true
  12.  
  13. <beans xmlns="http://www.springframework.org/schema/beans"
  14. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tx="http://www.springframework.org/schema/tx"
  15. xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:context="http://www.springframework.org/schema/context"
  16. xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
  17. http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd
  18. http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd
  19. http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">
  20.  
  21. <!-- Specifying base package of the Components like Controller, Service,
  22. DAO -->
  23. <context:component-scan
  24. base-package="com.abc" />
  25.  
  26. <!-- Getting Database properties -->
  27. <context:property-placeholder location="classpath:/application.properties" />
  28.  
  29. <mvc:annotation-driven />
  30.  
  31. <!-- Specifying the Resource location to load JS, CSS, Images etc -->
  32. <mvc:resources mapping="/resources/**" location="/resources/" />
  33.  
  34. <!-- View Resolver -->
  35. <bean
  36. class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  37. <property name="prefix" value="/WEB-INF/pages/" />
  38. <property name="suffix" value=".jsp" />
  39. </bean>
  40.  
  41. <!-- DataSource -->
  42. <!-- destroy-method="close" -->
  43. <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
  44. <property name="driverClassName" value="${database.driverClass}" />
  45. <property name="url" value="${database.url}" />
  46. <property name="username" value="${database.username}" />
  47. <property name="password" value="${database.password}" />
  48.  
  49. <!-- <property name="acquireIncrement" value="${connection.acquireIncrement}" /> -->
  50. <!-- <property name="minPoolSize" value="${connection.minPoolSize}" />
  51. <property name="maxPoolSize" value="${connection.maxPoolSize}" />
  52. <property name="maxIdleTime" value="${connection.maxIdleTime}" /> -->
  53. </bean>
  54.  
  55. <!-- Hibernate SessionFactory -->
  56. <bean id="sessionFactory"
  57. class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
  58. <property name="dataSource" ref="dataSource"></property>
  59. <property name="hibernateProperties">
  60. <props>
  61. <prop key="hibernate.dialect">${hibernate.dialect}</prop>
  62. <prop key="hibernate.hbm2ddl.auto">${hibernate.hbm2ddl.auto} </prop>
  63. <prop key="hibernate.format_sql">${hibernate.format_sql}</prop>
  64. <prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
  65. </props>
  66. </property>
  67. <property name="packagesToScan" value="com.abc.xyz.model"></property>
  68. </bean>
  69.  
  70. <!-- Transaction -->
  71. <bean id="transactionManager"
  72. class="org.springframework.orm.hibernate4.HibernateTransactionManager">
  73. <property name="sessionFactory" ref="sessionFactory" />
  74. </bean>
  75.  
  76. <tx:annotation-driven transaction-manager="transactionManager" />
  77. </beans>
  78.  
  79. Oct 24, 2016 11:35:38 PM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
  80. ERROR: HHH000299: Could not complete schema update
  81. java.sql.SQLException: Access denied for user 'sa'@'localhost' (using password: NO)
  82. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1094)
  83. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226)
  84. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158)
  85. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:926)
  86. at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1748)
  87. at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1288)
  88. at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2508)
  89. at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2541)
  90. at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2323)
  91. at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:832)
  92. at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
  93. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  94. at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
  95. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
  96. at java.lang.reflect.Constructor.newInstance(Unknown Source)
  97. at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
  98. at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:417)
  99. at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:344)
  100. at java.sql.DriverManager.getConnection(Unknown Source)
  101. at java.sql.DriverManager.getConnection(Unknown Source)
  102. at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:153)
  103. at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:144)
  104. at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:196)
  105. at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:169)
  106. at org.hibernate.service.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:141)
  107. at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51)
  108. at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:219)
  109. at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:203)
  110. at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:509)
  111. at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1799)
  112. at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870)
  113. at org.springframework.orm.hibernate4.LocalSessionFactoryBuilder.buildSessionFactory(LocalSessionFactoryBuilder.java:372)
  114. at org.springframework.orm.hibernate4.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:454)
  115. at org.springframework.orm.hibernate4.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:439)
  116. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1642)
  117. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1579)
  118. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545)
  119. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
  120. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
  121. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
  122. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
  123. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
  124. at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:207)
  125. at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1128)
  126. at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1056)
  127. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:566)
  128. at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88)
  129. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:349)
  130. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1219)
  131. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)
  132. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
  133. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
  134. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
  135. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
  136. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
  137. at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:207)
  138. at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1128)
  139. at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1056)
  140. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:566)
  141. at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88)
  142. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:349)
  143. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1219)
  144. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)
  145. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
  146. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
  147. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
  148. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
  149. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
  150. at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:207)
  151. at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1128)
  152. at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1056)
  153. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:566)
  154. at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88)
  155. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:349)
  156. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1219)
  157. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)
  158. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
  159. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
  160. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
  161. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
  162. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
  163. at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:751)
  164. at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:861)
  165. at org.springframework.context.support.AbstractApplicationContext.__refresh(AbstractApplicationContext.java:541)
  166. at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java)
  167. at org.springframework.web.servlet.FrameworkServlet.configureAndRefreshWebApplicationContext(FrameworkServlet.java:668)
  168. at org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:634)
  169. at org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:682)
  170. at org.springframework.web.servlet.FrameworkServlet.initWebApplicationContext(FrameworkServlet.java:553)
  171. at org.springframework.web.servlet.FrameworkServlet.initServletBean(FrameworkServlet.java:494)
  172. at org.springframework.web.servlet.HttpServletBean.init(HttpServletBean.java:136)
  173. at javax.servlet.GenericServlet.init(GenericServlet.java:158)
  174. at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1284)
  175. at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1197)
  176. at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1087)
  177. at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5253)
  178. at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5543)
  179. at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
  180. at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1574)
  181. at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1564)
  182. at java.util.concurrent.FutureTask.run(Unknown Source)
  183. at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  184. at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  185. at java.lang.Thread.run(Unknown Source)
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!