1 Reply Latest reply on Nov 10, 2008 1:26 PM by jamiejaxon

    Is Exercise 9 Linux-Compatible? Having problems verifying Derby DB.

    jamiejaxon
      I'm setting up the server side of this exercise, and am having a problem verifying (via verify.cfm) the data source, however, the data source verifies successfully in the CF admin.

      Here's the error that verify.cfm throws:

      quote:


      Error Executing Database Query.
      The conglomerate (96) requested does not exist.

      The error occurred in /var/www/apps/wwwroot/ex9_CF/reservations/verify.cfm: line 1

      1 : <cfquery name="testdb" datasource="reservations">
      2 : SELECT *
      3 : FROM RESERVATIONS

      SQLSTATE XSAI2
      SQL SELECT * FROM RESERVATIONS WHERE 0=0
      VENDORERRORCODE 30000
      DATASOURCE reservations
      Resources:

      * Check the ColdFusion documentation to verify that you are using the correct syntax.
      * Search the Knowledge Base to find a solution to your problem.

      Browser Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.0.3) Gecko/2008101315 Ubuntu/8.10 (intrepid) Firefox/3.0.3 ColdFire/1.1.51.59
      Remote Address 127.0.0.1
      Referrer http://general.localhost/ex9_CF/reservations/
      Date/Time 10-Nov-08 04:09 PM
      Stack Trace
      at cfverify2ecfm564280480.runPage(/var/www/apps/wwwroot/ex9_CF/reservations/verify.cfm:1) at cfverify2ecfm564280480.runPage(/var/www/apps/wwwroot/ex9_CF/reservations/verify.cfm:1)

      java.sql.SQLException: The conglomerate (96) requested does not exist.
      at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
      at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
      at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348)
      at coldfusion.sql.Executive.executeQuery(Executive.java:1220)
      at coldfusion.sql.Executive.executeQuery(Executive.java:1008)
      at coldfusion.sql.Executive.executeQuery(Executive.java:939)
      at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325)
      at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831)
      at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521)
      at cfverify2ecfm564280480.runPage(/var/www/apps/wwwroot/ex9_CF/reservations/verify.cfm:1)
      at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)
      at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)
      at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
      at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279)
      at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
      at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
      at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
      at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:27)
      at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
      at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74)
      at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:2 8)
      at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
      at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
      at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
      at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
      at coldfusion.CfmServlet.service(CfmServlet.java:175)
      at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
      at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
      at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42 )
      at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
      at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
      at jrun.servlet.FilterChain.service(FilterChain.java:101)
      at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
      at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
      at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
      at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
      at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
      at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
      at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
      Caused by: java.sql.SQLException: The conglomerate (96) requested does not exist.
      at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
      ... 45 more