API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 25th, 2014
245
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.35 KB | None | 0 0
raw download clone embed print report
  1. org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [spring/spring-model.xml]: Invocation of init method failed; nested exception is com.googlecode.flyway.core.command.FlywaySqlScriptException: Error executing statement at line 84: CREATE VIEW empty_car_details
  2. AS SELECT
  3. ec.id AS id,
  4. ec.guid AS guid,
  5. c.car_number AS car_number,
  6. ct.title AS car_type_title,
  7. co.title AS car_owner_title,
  8. ot.title AS ownership_type_title,
  9. dr.title AS departure_railway_title,
  10. drr.title AS departure_railroad_title,
  11. ec.invoice_number AS invoice_number,
  12. ec.departure_date AS departure_date,
  13. ar.title AS arrival_railway_title,
  14. arr.title AS arrival_railroad_title,
  15. ec.arrival_date AS arrival_date,
  16. ec.invoice_date_expire AS invoice_date_expire,
  17. ec.dist_min_way AS dist_min_way,
  18. ec.price AS price,
  19. CASE WHEN ec.taxable THEN (price*1.18) ELSE price END AS price_with_tax,
  20. CASE WHEN ec.taxable THEN (price*0.18) ELSE 0 END AS price_tax,
  21. ec.last_freight_code AS last_freight_code,
  22. ec.sender_name AS sender_name,
  23. ec.recipient_name AS recipient_name,
  24. cnt.title AS contractor_title,
  25. ec.rebillable AS rebillable,
  26. rcnt.title AS rebill_contractor_title,
  27. ec.is_repair AS is_repair,
  28. ec.note AS note,
  29. (ec.arrival_date - ec.departure_date) AS days_in_way,
  30. CASE WHEN ec.departure_date > ec.invoice_date_expire
  31. THEN (ec.departure_date - ec.invoice_date_expire) ELSE 0 END AS delay_days,
  32. CASE WHEN (price*(CASE WHEN ec.departure_date > ec.invoice_date_expire
  33. THEN (ec.departure_date - ec.invoice_date_expire)
  34. ELSE 0 END)*0.09) < price
  35. THEN (price*(CASE WHEN ec.departure_date > ec.invoice_date_expire
  36. THEN (ec.departure_date - ec.invoice_date_expire)
  37. ELSE 0 END)*0.09)
  38. ELSE price END AS fine,
  39. ec.payer_name AS payer_name,
  40. ec.taxable AS taxable,
  41. ec.invoice_date_delivery AS invoice_date_delivery
  42. FROM empty_cars ec
  43. LEFT JOIN cars c ON c.id = ec.car_id
  44. LEFT JOIN car_types ct ON ct.id = c.car_type_id
  45. LEFT JOIN car_owners co ON co.id = c.owner_id
  46. LEFT JOIN ownership_types ot ON ot.id = co.ownership_type_id
  47. LEFT JOIN railways dr ON dr.id = ec.departure_railway_id
  48. LEFT JOIN railroads drr ON drr.id = dr.railroad_id
  49. LEFT JOIN railways ar ON ar.id = ec.arrival_railway_id
  50. LEFT JOIN railroads arr ON arr.id = ar.railroad_id
  51. LEFT JOIN contractors cnt ON cnt.id = ec.contractor_id
  52. LEFT JOIN contractors rcnt ON rcnt.id = ec.rebill_contractor_id
  53.  
  54. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1553)
  55. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
  56. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)
  57. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304)
  58. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)
  59. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300)
  60. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195)
  61. at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:703)
  62. at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:760)
  63. at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)
  64. at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:403)
  65. at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
  66. at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)
  67. at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4739)
  68. at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5159)
  69. at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
  70. at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:726)
  71. at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:702)
  72. at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:697)
  73. at org.apache.catalina.startup.HostConfig.manageApp(HostConfig.java:1646)
  74. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  75. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  76. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  77. at java.lang.reflect.Method.invoke(Method.java:483)
  78. at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:300)
  79. at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:819)
  80. at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801)
  81. at org.apache.catalina.mbeans.MBeanFactory.createStandardContext(MBeanFactory.java:463)
  82. at org.apache.catalina.mbeans.MBeanFactory.createStandardContext(MBeanFactory.java:413)
  83. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  84. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  85. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  86. at java.lang.reflect.Method.invoke(Method.java:483)
  87. at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:300)
  88. at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:819)
  89. at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801)
  90. at javax.management.remote.rmi.RMIConnectionImpl.doOperation(RMIConnectionImpl.java:1466)
  91. at javax.management.remote.rmi.RMIConnectionImpl.access$300(RMIConnectionImpl.java:76)
  92. at javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(RMIConnectionImpl.java:1307)
  93. at javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(RMIConnectionImpl.java:1399)
  94. at javax.management.remote.rmi.RMIConnectionImpl.invoke(RMIConnectionImpl.java:828)
  95. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  96. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  97. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  98. at java.lang.reflect.Method.invoke(Method.java:483)
  99. at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:323)
  100. at sun.rmi.transport.Transport$1.run(Transport.java:178)
  101. at sun.rmi.transport.Transport$1.run(Transport.java:175)
  102. at java.security.AccessController.doPrivileged(Native Method)
  103. at sun.rmi.transport.Transport.serviceCall(Transport.java:174)
  104. at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:557)
  105. at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:812)
  106. at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:671)
  107. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  108. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  109. at java.lang.Thread.run(Thread.java:744)
  110. Caused by: com.googlecode.flyway.core.command.FlywaySqlScriptException: Error executing statement at line 84: CREATE VIEW empty_car_details
  111. AS SELECT
  112. ec.id AS id,
  113. ec.guid AS guid,
  114. c.car_number AS car_number,
  115. ct.title AS car_type_title,
  116. co.title AS car_owner_title,
  117. ot.title AS ownership_type_title,
  118. dr.title AS departure_railway_title,
  119. drr.title AS departure_railroad_title,
  120. ec.invoice_number AS invoice_number,
  121. ec.departure_date AS departure_date,
  122. ar.title AS arrival_railway_title,
  123. arr.title AS arrival_railroad_title,
  124. ec.arrival_date AS arrival_date,
  125. ec.invoice_date_expire AS invoice_date_expire,
  126. ec.dist_min_way AS dist_min_way,
  127. ec.price AS price,
  128. CASE WHEN ec.taxable THEN (price*1.18) ELSE price END AS price_with_tax,
  129. CASE WHEN ec.taxable THEN (price*0.18) ELSE 0 END AS price_tax,
  130. ec.last_freight_code AS last_freight_code,
  131. ec.sender_name AS sender_name,
  132. ec.recipient_name AS recipient_name,
  133. cnt.title AS contractor_title,
  134. ec.rebillable AS rebillable,
  135. rcnt.title AS rebill_contractor_title,
  136. ec.is_repair AS is_repair,
  137. ec.note AS note,
  138. (ec.arrival_date - ec.departure_date) AS days_in_way,
  139. CASE WHEN ec.departure_date > ec.invoice_date_expire
  140. THEN (ec.departure_date - ec.invoice_date_expire) ELSE 0 END AS delay_days,
  141. CASE WHEN (price*(CASE WHEN ec.departure_date > ec.invoice_date_expire
  142. THEN (ec.departure_date - ec.invoice_date_expire)
  143. ELSE 0 END)*0.09) < price
  144. THEN (price*(CASE WHEN ec.departure_date > ec.invoice_date_expire
  145. THEN (ec.departure_date - ec.invoice_date_expire)
  146. ELSE 0 END)*0.09)
  147. ELSE price END AS fine,
  148. ec.payer_name AS payer_name,
  149. ec.taxable AS taxable,
  150. ec.invoice_date_delivery AS invoice_date_delivery
  151. FROM empty_cars ec
  152. LEFT JOIN cars c ON c.id = ec.car_id
  153. LEFT JOIN car_types ct ON ct.id = c.car_type_id
  154. LEFT JOIN car_owners co ON co.id = c.owner_id
  155. LEFT JOIN ownership_types ot ON ot.id = co.ownership_type_id
  156. LEFT JOIN railways dr ON dr.id = ec.departure_railway_id
  157. LEFT JOIN railroads drr ON drr.id = dr.railroad_id
  158. LEFT JOIN railways ar ON ar.id = ec.arrival_railway_id
  159. LEFT JOIN railroads arr ON arr.id = ar.railroad_id
  160. LEFT JOIN contractors cnt ON cnt.id = ec.contractor_id
  161. LEFT JOIN contractors rcnt ON rcnt.id = ec.rebill_contractor_id
  162.  
  163. at com.googlecode.flyway.core.dbsupport.SqlScript.execute(SqlScript.java:92)
  164. at com.googlecode.flyway.core.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:72)
  165. at com.googlecode.flyway.core.command.DbMigrate$2.doInTransaction(DbMigrate.java:243)
  166. at com.googlecode.flyway.core.command.DbMigrate$2.doInTransaction(DbMigrate.java:241)
  167. at com.googlecode.flyway.core.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  168. at com.googlecode.flyway.core.command.DbMigrate.applyMigration(DbMigrate.java:241)
  169. at com.googlecode.flyway.core.command.DbMigrate.access$700(DbMigrate.java:44)
  170. at com.googlecode.flyway.core.command.DbMigrate$1.doInTransaction(DbMigrate.java:186)
  171. at com.googlecode.flyway.core.command.DbMigrate$1.doInTransaction(DbMigrate.java:135)
  172. at com.googlecode.flyway.core.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  173. at com.googlecode.flyway.core.command.DbMigrate.migrate(DbMigrate.java:135)
  174. at com.googlecode.flyway.core.Flyway$1.execute(Flyway.java:872)
  175. at com.googlecode.flyway.core.Flyway$1.execute(Flyway.java:819)
  176. at com.googlecode.flyway.core.Flyway.execute(Flyway.java:1200)
  177. at com.googlecode.flyway.core.Flyway.migrate(Flyway.java:819)
  178. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  179. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  180. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  181. at java.lang.reflect.Method.invoke(Method.java:483)
  182. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1681)
  183. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1620)
  184. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1549)
  185. ... 55 more
  186. Caused by: org.postgresql.util.PSQLException: ОШИБКА: колонка co.ownership_type_id не существует
  187. Позиция: 1964
  188. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
  189. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
  190. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
  191. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559)
  192. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
  193. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395)
  194. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  195. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  196. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  197. at java.lang.reflect.Method.invoke(Method.java:483)
  198. at net.bull.javamelody.JdbcWrapper.doExecute(JdbcWrapper.java:395)
  199. at net.bull.javamelody.JdbcWrapper$StatementInvocationHandler.invoke(JdbcWrapper.java:134)
  200. at net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:281)
  201. at com.sun.proxy.$Proxy196.execute(Unknown Source)
  202. at com.googlecode.flyway.core.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:230)
  203. at com.googlecode.flyway.core.dbsupport.SqlScript.execute(SqlScript.java:90)
  204. ... 76 more
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!