API tools faq
paste
Advertisement
murp

ContentBox with Oracle 11g

murp
Jun 9th, 2015
245
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.13 KB | None | 0 0
raw download clone embed print report
  1. Error Type: org.hibernate.exception.GenericJDBCException : 907
  2. Error Messages: could not execute query
  3.  
  4. org.hibernate.exception.GenericJDBCException: could not execute query
  5. at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
  6. at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
  7. at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
  8. at org.hibernate.loader.Loader.doList(Loader.java:2297)
  9. at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2172)
  10. at org.hibernate.loader.Loader.list(Loader.java:2167)
  11. at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
  12. at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1706)
  13. at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
  14. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  15. at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  16. at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  17. at java.lang.reflect.Method.invoke(Unknown Source)
  18. at coldfusion.runtime.StructBean.invoke(StructBean.java:508)
  19. at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2461)
  20. at cfCriteriaBuilder2ecfc1529794357$funcLIST.runFunction(C:\ColdFusion10\cfusion\wwwroot\bjs\blog\coldbox\system\orm\hibernate\CriteriaBuilder.cfc:121)
  21. at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
  22. at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
  23. at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
  24. at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
  25. at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
  26. at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:518)
  27. at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:660)
  28. at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:469)
  29. at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2369)
  30. at cfPageService2ecfc830379680$funcFINDPUBLISHEDPAGES.runFunction(C:\ColdFusion10\cfusion\wwwroot\bjs\blog\modules\contentbox\model\content\PageService.cfc:248)
  31. at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
  32. at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
  33. at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
  34. at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
  35. at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:518)
  36. at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:660)
  37. at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:469)
  38. at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2369)
  39. at cfCBHelper2ecfc1922539681$funcROOTMENU.runFunction(C:\ColdFusion10\cfusion\wwwroot\bjs\blog\modules\contentbox\plugins\CBHelper.cfc:1165)
  40. at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
  41. at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
  42. at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
  43. at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
  44. at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:518)
  45. at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:660)
  46. at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:469)
  47. at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2369)
  48. at cf_menu2ecfm676847119.runPage(C:\ColdFusion10\cfusion\wwwroot\bjs\blog\modules\contentbox\layouts\bjslayout\views\_menu.cfm:31)
  49. at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
  50. at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
  51. at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
  52. at cfRenderer2ecfc957396953$funcRENDERVIEWCOMPOSITE.runFunction(C:\ColdFusion10\cfusion\wwwroot\bjs\blog\coldbox\system\plugins\Renderer.cfc:338)
  53. at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
  54. at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
  55. at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
  56. at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
  57. at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
  58. at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
  59. at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
  60. at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2655)
  61. at cfRenderer2ecfc957396953$funcRENDERVIEW.runFunction(C:\ColdFusion10\cfusion\wwwroot\bjs\blog\coldbox\system\plugins\Renderer.cfc:183)
  62. at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
  63. at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
  64. at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
  65. at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
  66. at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
  67. at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
  68. at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:518)
  69. at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:660)
  70. at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:469)
  71. at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2369)
  72. at cfFrameworkSupertype2ecfc1012312686$funcRENDERVIEW.runFunction(C:\ColdFusion10\cfusion\wwwroot\bjs\blog\coldbox\system\FrameworkSupertype.cfc:173)
  73. at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
  74. at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
  75. at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
  76. at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
  77. at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
  78. at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
  79. at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:518)
  80. at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2620)
  81. at cfCBHelper2ecfc1922539681$funcQUICKVIEW.runFunction(C:\ColdFusion10\cfusion\wwwroot\bjs\blog\modules\contentbox\plugins\CBHelper.cfc:1047)
  82. at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
  83. at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
  84. at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
  85. at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
  86. at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
  87. at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655)
  88. at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444)
  89. at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414)
  90. at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2428)
  91. at cfpages2ecfm2138989166.runPage(C:\ColdFusion10\cfusion\wwwroot\bjs\blog\modules\contentbox\layouts\bjslayout\layouts\pages.cfm:91)
  92. at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
  93. at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
  94. at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
  95. at cfRenderer2ecfc957396953$funcRENDERVIEWCOMPOSITE.runFunction(C:\ColdFusion10\cfusion\wwwroot\bjs\blog\coldbox\system\plugins\Renderer.cfc:338)
  96. at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
  97. at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
  98. at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
  99. at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
  100. at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
  101. at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
  102. at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
  103. at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2655)
  104. at cfRenderer2ecfc957396953$funcRENDERLAYOUT.runFunction(C:\ColdFusion10\cfusion\wwwroot\bjs\blog\coldbox\system\plugins\Renderer.cfc:475)
  105. at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
  106. at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
  107. at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
  108. at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
  109. at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
  110. at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
  111. at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:518)
  112. at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:660)
  113. at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:469)
  114. at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2369)
  115. at cfColdbox2ecfc1960341555$funcPROCESSCOLDBOXREQUEST.runFunction(C:\ColdFusion10\cfusion\wwwroot\bjs\blog\coldbox\system\Coldbox.cfc:256)
  116. at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
  117. at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
  118. at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
  119. at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
  120. at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
  121. at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
  122. at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655)
  123. at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444)
  124. at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414)
  125. at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2428)
  126. at cfApplication2ecfc2042642415$funcONREQUESTSTART.runFunction(C:\ColdFusion10\cfusion\wwwroot\bjs\blog\Application.cfc:114)
  127. at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
  128. at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
  129. at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
  130. at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
  131. at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
  132. at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
  133. at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655)
  134. at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444)
  135. at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414)
  136. at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108)
  137. at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:278)
  138. at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:419)
  139. at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
  140. at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
  141. at coldfusion.filter.PathFilter.invoke(PathFilter.java:112)
  142. at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
  143. at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79)
  144. at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
  145. at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
  146. at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
  147. at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
  148. at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
  149. at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
  150. at coldfusion.CfmServlet.service(CfmServlet.java:219)
  151. at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
  152. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
  153. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  154. at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
  155. at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
  156. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  157. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  158. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
  159. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
  160. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
  161. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
  162. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  163. at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
  164. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
  165. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:422)
  166. at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:199)
  167. at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
  168. at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
  169. at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  170. at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  171. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  172. at java.lang.Thread.run(Unknown Source)
  173. Caused by: java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00907: missing right parenthesis
  174.  
  175. at macromedia.jdbc.oraclebase.ddcr.b(Unknown Source)
  176. at macromedia.jdbc.oraclebase.ddcr.a(Unknown Source)
  177. at macromedia.jdbc.oraclebase.ddcq.b(Unknown Source)
  178. at macromedia.jdbc.oraclebase.ddcq.a(Unknown Source)
  179. at macromedia.jdbc.oracle.ddal.a(Unknown Source)
  180. at macromedia.jdbc.oracle.ddal.a(Unknown Source)
  181. at macromedia.jdbc.oracle.ddam.t(Unknown Source)
  182. at macromedia.jdbc.oraclebase.dde3.w(Unknown Source)
  183. at macromedia.jdbc.oraclebase.dde3.v(Unknown Source)
  184. at macromedia.jdbc.oraclebase.dddz.executeQuery(Unknown Source)
  185. at macromedia.jdbc.oraclebase.ddd2.executeQuery(Unknown Source)
  186. at coldfusion.server.j2ee.sql.JRunPreparedStatement.executeQuery(JRunPreparedStatement.java:86)
  187. at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
  188. at org.hibernate.loader.Loader.getResultSet(Loader.java:1849)
  189. at org.hibernate.loader.Loader.doQuery(Loader.java:718)
  190. at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
  191. at org.hibernate.loader.Loader.doList(Loader.java:2294)
  192. ... 164 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!