We found that whenever we used transactions, an error would be written to
our log files, but not thrown to screen. However, if you have the username
and password set up with the datasource in the cf administrator then you
wouldn't get any errors.
We've resorted to doing that for some apps, and moving transactional logic
to stored procs for others. No fun. But, it's the only solution we've come
up with so far (Oracle 8i).
----- Original Message -----
From: "Dave Carabetta" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 17, 2004 4:39 PM
Subject: DataDirect 3.3 bug with Oracle? (was RE: Maxing out running
requests...)
> > > We had similar problems that were resolved by reverting the
> > > 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]
