Hello Jochem,
The error I am getting is that ColdFusion MX gets an error executing Query of
Queries.
Well, here's my testing code:
-------------------------------------------------------
<cfquery name="qryName" datasource="#REQUEST.DNS#">
SELECT a.*
FROM statscountries a
JOIN (
SELECT isocode
FROM statscountries
WHERE isocode LIKE '%A%'
) b
ON a.isocode = b.isocode
WHERE a.isocode LIKE '%U%'
</cfquery>
<cfquery name="qofq" dbtype="query">
SELECT *
FROM qryName
WHERE isocode LIKE '%U%'
</cfquery>
<cfoutput>
#qofq.RecordCount#
</cfoutput>
---------------------------------------------------------
Then, the error I get when I execute it is:
=================================================================================
Error Occurred While Processing Request
Error Executing Database Query.
The error occurred in /var/www/html/circus/index.cfm: line 14
12 : </cfquery>
13 :
14 : <cfquery name="qofq" dbtype="query">
15 : SELECT *
16 : FROM qryName
SQL SELECT * FROM qryName WHERE isocode LIKE '%U%'
java.sql.SQLException
at coldfusion.sql.JdbcImpl.getConnection(JdbcImpl.java:73)
at coldfusion.sql.JdbcImpl.getConnection(JdbcImpl.java:56)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:207)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:447)
at cfindex2ecfm1734096888.runPage(/var/www/html/circus/index.cfm:14)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
at
coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
==================================================================================
The problem shoots randomly after the CFMX server starts. Sometimes it occurs
in a fluid succession, sometimes it seems fixed but would get crappy after one
restart.
I've also tried dropping in the JDBC drivers at those directories, then restart
the server, but I still get the error. As for using a 7.4 JDBC to access an 8.1
database, it gets an error on some encoding, particularly on trailing spaces,
which I don't get when I use an 8.1 JDBC.
On using PostgreSQL 8.2 with CFMX, I haven't tried it, and I am not sure if the
RPMs would install properly on my FC4. If I remember it right, I think I have
tried installing 8.2 and the RPMs went searching for some .so# that I don't
have.
Does CFMX really use JDBC2? I thought JVM 1.4 uses JDBC3. Isn't the JVM that
comes with ColdFusion version 1.4? So shouldn't I use JDBC3 (although JDBC2
works, anyway).
Anyways, thanks for the advices, and I'll see 8.2.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267569
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
