Reactor records already use transactions but you can turn it off using myRecord.save(false)
João Fernandes
-----Original Message-----
From: [EMAIL PROTECTED] on behalf of Dan Vega
Sent: Tue 01-Aug-06 8:55 PM
To: reactor
Subject: [Reactor for CF] nested transaction error
Does anyone know how I can perform transactions and still use reactor? I
have the following
<!--- if form is submitted --->
<!--- object 1 --->
set all fields
validate
save
<!-- object 2 --->
set fields
validate
save
And so on for another 4 or 5 objects.
But around this whole thing I want to wrap transaction tags and if
ErrorCollection.hasErrors() I want to back out of the transaction. I have
tried to wrap but it seems another method uses the transaction tag
The following information is meant for the website developer for debugging
purposes. Error Occurred While Processing Request Nested
transactions are not supported. You cannot nest a cftransaction tag
within another cftransaction tag. Check for a cftransaction tag on the page
that called the CFC. The error occurred in *C:\Program Files\Apache
Group\Apache2\htdocs\Reactor\base\abstractRecord.cfc: line 101*
*Called from* C:\Program Files\Apache
Group\Apache2\htdocs\Reactor\base\abstractRecord.cfc: line 92
*Called from* C:\Program Files\Apache
Group\Apache2\htdocs\appname\staff\editAdvisor.cfm: line 27
*Called from* C:\Program Files\Apache
Group\Apache2\htdocs\appname\staff\editAdvisor.cfm:
line 15
*Called from* C:\Program Files\Apache
Group\Apache2\htdocs\appname\staff\editAdvisor.cfm:
line 13
*Called from* C:\Program Files\Apache
Group\Apache2\htdocs\appname\staff\editAdvisor.cfm:
line 1
*Called from* C:\Program Files\Apache
Group\Apache2\htdocs\appname\staff\Application.cfc:
line 25
99 : <!--- saveInTransaction --->
100 : <cffunction name="saveInTransaction" access="private" hint="I
save the record in a transaction." output="false" returntype="void">
*101 : <cftransaction>*
102 : <cfset executeSave() />
103 : </cftransaction>
------------------------------
Resources:
- Check the ColdFusion
documentation<http://www.macromedia.com/go/proddoc_getdoc>to verify
that you are using the correct syntax.
- Search the Knowledge
Base<http://www.macromedia.com/support/coldfusion/>to find a solution
to your problem.
Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.5)
Gecko/20060719 Firefox/1.5.0.5 Remote Address 127.0.0.1 Referrer
http://localhost/appname/staff/editAdvisor.cfm Date/Time 01-Aug-06 04:01
PM Stack Trace at
cfabstractRecord2ecfc1906471027$funcSAVEINTRANSACTION.runFunction(C:\Program
Files\Apache Group\Apache2\htdocs\Reactor\base\abstractRecord.cfc:101) at
cfabstractRecord2ecfc1906471027$funcSAVE.runFunction(C:\Program Files\Apache
Group\Apache2\htdocs\Reactor\base\abstractRecord.cfc:92) at
cfeditAdvisor2ecfm1418557142._factor0(C:\Program Files\Apache
Group\Apache2\htdocs\appname\staff\editAdvisor.cfm:27) at
cfeditAdvisor2ecfm1418557142._factor3(C:\Program Files\Apache
Group\Apache2\htdocs\appnamestaff\editAdvisor.cfm:15) at
cfeditAdvisor2ecfm1418557142._factor10(C:\Program Files\Apache
Group\Apache2\htdocs\appname\staff\editAdvisor.cfm:13) at
cfeditAdvisor2ecfm1418557142.runPage(C:\Program Files\Apache
Group\Apache2\htdocs\appname\staff\editAdvisor.cfm:1) at
cfApplication2ecfc1169789817$funcONREQUEST.runFunction(C:\Program
Files\Apache Group\Apache2\htdocs\appname\staff\Application.cfc:25)
coldfusion.tagext.sql.TransactionTag$NestedTransactionInCFCException:
Nested transactions are not supported.
at
coldfusion.tagext.sql.TransactionTag.doStartTag(TransactionTag.java:164)
at
cfabstractRecord2ecfc1906471027$funcSAVEINTRANSACTION.runFunction(C:\Program
Files\Apache Group\Apache2\htdocs\Reactor\base\abstractRecord.cfc:101)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:348)
at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
at
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:294)
at
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:258)
at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:211)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:173)
at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1807)
at cfabstractRecord2ecfc1906471027$funcSAVE.runFunction(C:\Program
Files\Apache Group\Apache2\htdocs\Reactor\base\abstractRecord.cfc:92)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:348)
at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
at
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:294)
at
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:258)
at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:211)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:173)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:192)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:145)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1634)
at cfeditAdvisor2ecfm1418557142._factor0(C:\Program Files\Apache
Group\Apache2\htdocs\appname\staff\editAdvisor.cfm:27)
at cfeditAdvisor2ecfm1418557142._factor3(C:\Program Files\Apache
Group\Apache2\htdocs\appnamestaff\editAdvisor.cfm:15)
at cfeditAdvisor2ecfm1418557142._factor10(C:\Program Files\Apache
Group\Apache2\htdocs\appname\staff\editAdvisor.cfm:13)
at cfeditAdvisor2ecfm1418557142.runPage(C:\Program Files\Apache
Group\Apache2\htdocs\appname\staff\editAdvisor.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915)
at cfApplication2ecfc1169789817$funcONREQUEST.runFunction(C:\Program
Files\Apache Group\Apache2\htdocs\appname\staff\Application.cfc:25)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:348)
at
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:294)
at
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:258)
at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:211)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:173)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:192)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:145)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:54)
at
coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:115)
at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:200)
at
coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:27)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
at
coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at
coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
at coldfusion.CfmServlet.service(CfmServlet.java:107)
at
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
--
Dan Vega
[EMAIL PROTECTED]
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
<<winmail.dat>>
