I think João was saying you can just disable transactions in reactor to handle it yourself and avoid nesting the un-nestable
On 8/1/06, Dan Vega <[EMAIL PROTECTED]> wrote:
but if object 1 has errors objects 2-5 are still being saved? On 8/1/06, João Fernandes <[EMAIL PROTECTED] > wrote: > > 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/ > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > > -- 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/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
