> > 6.1 database drivers to the 6.0+ version available at the
> > related TechNote
> > (http://www.macromedia.com/support/coldfusion/ts/documents/cfm
> > x61_sqlserver_cpu.htm).
> > Unfortunately, MM has removed the 6.0+ drivers in that
> > TechNote and replaced the download to point to the new
> > DataDirect 3.3 drivers. Perhaps you'll have luck with those,
> > but we continued to have problems, so we're still on the 6.0+
> > drivers.
>
>Out of curiosity, are you having the same problems with the 3.3 drivers
>that
>you were with the 3.2 drivers? What database server are you using?
>
>For our SQL Server clients, we've successfully deployed the MS JDBC drivers
>in some cases.
>
Just as a quick follow-up, I have isolated down the scenario that creates
the removeOnExceptions warning. If I use the cftransaction tag around my
queries, the warning is thrown. If I don't, no warning appears. Any idea
what the issue might be? Is this a bug I need to follow up with Macromedia?
As a test with Oracle 8i/9i:
<cftransaction action=""> <cfquery name="get" datasource="myDSN">
SELECT sysdate
FROM dual
</cfquery>
<cfquery name="get2" datasource="myDSN">
SELECT sysdate
FROM dual
</cfquery>
</cftransaction>
<cfdump var="#get#" expand="Yes" />
<cfdump var="#get2#" expand="Yes" />
This will throw the following warning to my log file:
removeOnExceptions is true for myDSN, closed the physical Connection
If I comment out the cftransaction tags, nothing is thrown.
As I said, over time and under load this eventually brings the instance to a
grind.
Regards,
Dave.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
