API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 25th, 2017
57
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.18 KB | None | 0 0
raw download clone embed print report
  1. <bean id="dataSourceDistant" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
  2. <property name="driverClassName" value="net.sourceforge.jtds.jdbc.Driver"/>
  3. <property name="url">
  4. <value>jdbc:jtds:sqlserver://ip:1433/dbname</value>
  5. </property>
  6. <property name="username" value="username"/>
  7. <property name="password" value="password"/>
  8.  
  9. </bean>
  10. <bean id="sessionFactoryDistant" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
  11. <property name="dataSource" ref="dataSourceDistant"/>
  12. <property name="packagesToScan" value="com.springapp.mvc.models_distant_db"/>
  13. <property name="hibernateProperties">
  14. <props>
  15. <prop key="hibernate.dialect">org.hibernate.dialect.SQLServer2008Dialect</prop>
  16. <prop key="hibernate.show_sql">true</prop>
  17. <prop key="hibernate.format_sql">true</prop>
  18. <prop key="hibernate.hbm2ddl.auto">update</prop>
  19. <prop key="hibernate.c3p0.acquire_increment">1</prop>
  20. <prop key="hibernate.c3p0.max_size">15</prop>
  21. <prop key="hibernate.c3p0.min_size">5</prop>
  22. <prop key="hibernate.c3p0.timeout">1800</prop>
  23. <prop key="hibernate.c3p0.max_statements">0</prop>
  24.  
  25. </props>
  26. </property>
  27. </bean>
  28.  
  29. @Entity
  30. @Table(name = "admin")
  31. public class User {
  32. @Id
  33. @GeneratedValue(strategy = GenerationType.AUTO)
  34. @Column(name="adm_id")
  35. private int id;
  36. @Column(name = "name")
  37. private String name;
  38. @Column(name = "password")
  39. private String password;
  40.  
  41. public String getName() {
  42. return name;
  43. }
  44.  
  45. public void setName(String name) {
  46. this.name = name;
  47. }
  48.  
  49. public String getPassword() {
  50. return password;
  51. }
  52.  
  53. public void setPassword(String password) {
  54. this.password = password;
  55. }
  56. //Метод сохраниения
  57. public Success saveUser(User user){
  58. if(user!=null){
  59. sessionFactoryLocalDb.getCurrentSession().save(user);
  60. Success success = new Success();
  61. success.setResult(200);
  62. return success;
  63. }
  64.  
  65. Success success = new Success();
  66. success.setResult(100);
  67. return success;
  68. }
  69.  
  70. HTTP Status 500 – Internal Server Error
  71.  
  72. Type Exception Report
  73.  
  74. Message Request processing failed; nested exception is org.hibernate.exception.SQLGrammarException: could not execute statement
  75.  
  76. Description The server encountered an unexpected condition that prevented it from fulfilling the request.
  77.  
  78. Exception
  79.  
  80. org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.hibernate.exception.SQLGrammarException: could not execute statement
  81. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:978)
  82. org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)
  83. javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
  84. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
  85. javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
  86. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  87. org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  88. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  89. Root Cause
  90.  
  91. org.hibernate.exception.SQLGrammarException: could not execute statement
  92. org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123)
  93. org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
  94. org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
  95. org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
  96. org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:190)
  97. org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:96)
  98. org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:58)
  99. org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3032)
  100. org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3558)
  101. org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:98)
  102. org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:490)
  103. org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:195)
  104. org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:179)
  105. org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:214)
  106. org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:324)
  107. org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:288)
  108. org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:194)
  109. org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:125)
  110. org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:209)
  111. org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:55)
  112. org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:194)
  113. org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:49)
  114. org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:90)
  115. org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:715)
  116. org.hibernate.internal.SessionImpl.save(SessionImpl.java:707)
  117. org.hibernate.internal.SessionImpl.save(SessionImpl.java:702)
  118. com.springapp.mvc.service.MyServiceClass.set(MyServiceClass.java:300)
  119. com.springapp.mvc.service.MyServiceClass$$FastClassBySpringCGLIB$$6125fa23.invoke(<generated>)
  120. org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
  121. org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:717)
  122. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  123. org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98)
  124. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:266)
  125. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95)
  126. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  127. org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653)
  128. com.springapp.mvc.service.MyServiceClass$$EnhancerBySpringCGLIB$$16a518c7.set(<generated>)
  129. com.springapp.mvc.MyController.set(MyController.java:177)
  130. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  131. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  132. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  133. java.lang.reflect.Method.invoke(Method.java:498)
  134. org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)
  135. org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
  136. org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
  137. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:781)
  138. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:721)
  139. org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)
  140. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)
  141. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)
  142. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
  143. org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)
  144. javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
  145. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
  146. javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
  147. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  148. org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  149. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  150. Root Cause
  151.  
  152. java.sql.SQLException: Invalid object name 'uplavlenec'.
  153. net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
  154. net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
  155. net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
  156. net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)
  157. net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613)
  158. net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572)
  159. net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:727)
  160. org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:187)
  161. org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:96)
  162. org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:58)
  163. org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3032)
  164. org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3558)
  165. org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:98)
  166. org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:490)
  167. org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:195)
  168. org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:179)
  169. org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:214)
  170. org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:324)
  171. org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:288)
  172. org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:194)
  173. org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:125)
  174. org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:209)
  175. org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:55)
  176. org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:194)
  177. org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:49)
  178. org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:90)
  179. org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:715)
  180. org.hibernate.internal.SessionImpl.save(SessionImpl.java:707)
  181. org.hibernate.internal.SessionImpl.save(SessionImpl.java:702)
  182. com.springapp.mvc.service.MyServiceClass.set(MyServiceClass.java:300)
  183. com.springapp.mvc.service.MyServiceClass$$FastClassBySpringCGLIB$$6125fa23.invoke(<generated>)
  184. org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
  185. org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:717)
  186. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  187. org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98)
  188. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:266)
  189. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95)
  190. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  191. org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653)
  192. com.springapp.mvc.service.MyServiceClass$$EnhancerBySpringCGLIB$$16a518c7.set(<generated>)
  193. com.springapp.mvc.MyController.set(MyController.java:177)
  194. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  195. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  196. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  197. java.lang.reflect.Method.invoke(Method.java:498)
  198. org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)
  199. org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
  200. org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
  201. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:781)
  202. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:721)
  203. org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)
  204. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)
  205. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)
  206. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
  207. org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)
  208. javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
  209. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
  210. javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
  211. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  212. org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  213. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  214. Note The full stack trace of the root cause is available in the server logs.
  215.  
  216. Apache Tomcat/8.5.20
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!