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:
[Q]
Error Executing Database Query.
The conglomerate (96) requested does not exist.
The error occurred in /var/www/apps/wwwroot/ex9_CF/reservations/verify.c fm:
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/wwwro ot/ex9_CF/reservations/verify.
cfm:1) at
cfverify2ecfm564280480.runPage(/var/www/apps/wwwro ot/ex9_CF/reservations/verify.
cfm:1)
java.sql.SQLException: The conglomerate (96) requested does not exist.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.g etSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLExcep tion(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.handleE xception(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleE xception(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(J RunStatement.java:348)
at coldfusion.sql.Executive.executeQuery(Executive.ja va:1220)
at coldfusion.sql.Executive.executeQuery(Executive.ja va:1008)
at coldfusion.sql.Executive.executeQuery(Executive.ja va:939)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryT ag.java:831)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.j ava:521)
at
cfverify2ecfm564280480.runPage(/var/www/apps/wwwro ot/ex9_CF/reservations/verify.
cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java :196)
at coldfusion.tagext.lang.IncludeTag.doStartTag(Inclu deTag.java:370)
at coldfusion.filter.CfincludeFilter.invoke(Cfinclude Filter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(Applica tionFilter.java:279)
at coldfusion.filter.RequestMonitorFilter.invoke(Requ estMonitorFilter.java:48)
at coldfusion.filter.MonitoringFilter.invoke(Monitori ngFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.jav a:86)
at coldfusion.filter.LicenseFilter.invoke(LicenseFilt er.java:27)
at coldfusion.filter.ExceptionFilter.invoke(Exception Filter.java:70)
at coldfusion.filter.BrowserDebugFilter.invoke(Browse rDebugFilter.java:74)
at
coldfusion.filter.ClientScopePersistenceFilter.inv oke(ClientScopePersistenceFilt
er.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilt er.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilt er.java:46)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilt er.java:38)
at coldfusion.filter.DatasourceFilter.invoke(Datasour ceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:175)
at coldfusion.bootstrap.BootstrapServlet.service(Boot strapServlet.java:89)
at jrun.servlet.FilterChain.doFilter(FilterChain.java :86)
at
coldfusion.monitor.event.MonitoringServletFilter.d oFilter(MonitoringServletFilte
r.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(Boot strapFilter.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(JRunInvok erChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequ estDispatcher.java:286)
at jrun.servlet.ServletEngineService.dispatch(Servlet EngineService.java:543)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable( JRunProxyService.java:203)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRu nnable(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.get SQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.w rapArgsForTransportAcrossDRDA(
Unknown Source)
... 45 more
[/Q]