Gary,
You can try,
<CFTRANSACTION ACTION="BEGIN">
<cfset CommitThis="true">
<cftry>
<CFQUERY DATASOURCE="#request.dsn#" DBTYPE="ODBC">
</CFQUERY>
<cfcatch type='database'>
<cfset CommitThis="false">
</cfcatch>
</cftry>
<cfif CommitThis is "true">
<cftransaction action='Commit'>
<cfelse>
<cftransaction action='Rollback'>
</cfif>
</CFTRANSACTION>
Hope this helps!
Warm Regards,
Sameer S. Kekade.
QUATRO FOUR RETAIL
"The right connections for your business"
Tel. direct +61 2 9370 2775
Fax direct +61 2 9370 1200
Mobile 0411 566 650
[EMAIL PROTECTED]
www.quatro.com.au
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Gary
Crouch
Sent: Wednesday, 28 April 2004 10:57 AM
To: CFAussie Mailing List
Subject: [cfaussie] Java JDBC connection with transactions
Ok, I am hosting a CFMX and MSSQL account with Web Central.
Our application is using Fuesbox 3 so the DSN and PW are coded in to the
AppInit file.
If I use a query or stored procedure every thing is fine.
As soon as I rap queries in a <cftransaction> block I get this error:-
The root cause of this exception was: java.sql.SQLException:
[Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server connection..
Has anyone seen this before? One of my colleagues says it's because they
are running CFMX on J2EE, is this true and does it drop the facility of
the <cftransaction> tag?
Please Please Help.
<head action="bangs" on="desk"/>
Gary Crouch
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
