I had the same experience while working with MG Unity and Reactor. The database
schema was being queried every time I did an insert or an update even though
everything was set to production. So to narrow things down I took MG out of the
equation and wrote a simple test just with reactor. It seems like if you
validate the record using the validate() method before you do the insert or
update the DB schema is queried otherwise its not. I am using Reactor version
429 with coldfusion MX7 and SQL Server 2005.
After a lot of looking around I tracked this down to line 186 of
reactor.core.objectFactory
<cfset var dictionaryXmlPath =
"#getObject(arguments.alias).getMapping()#/Dictionary/#arguments.alias#dictionary.xml"
/>
The call to getObject seems to generate the query to the database schema
I changed the above line to the following
<cfset var tempmapping = "/" & Replace(getMapping(), ".", "/", "all") />
<cfset var dictionaryXmlPath =
"#tempmapping#/Dictionary/#arguments.alias#dictionary.xml" />
and that seems to have solved the issue. I am no where near a Reactor expert.
I have used it for a couple of months so I wanted to share this with everyone
so that they can take a look and see what they think about this.
The test code I used is as follows.
<cfsilent>
<cfapplication name="testapp" sessionmanagement="true"/>
<cfif not structKeyExists(application,'reactor') or isDefined("url.init")>
<cfset application.reactor = CreateObject("Component",
"reactor.reactorFactory").init(expandPath("reactor.xml")) />
</cfif>
</cfsilent>
My reactor configuration file is as follows
<reactor>
<config>
<project value="testapp" />
<dsn value="testdsn" />
<type value="mssql" />
<mapping value="/testapp/data" />
<mode value="production" />
</config>
<objects>
<object name="Post">
<hasMany name="Comment">
<relate from="PostId" to="PostId" />
</hasMany>
</object>
</objects>
</reactor>
And finally the code that I am using to test this
<cfset record = application.reactor.createRecord("Post")>
<cfset record.setPost("Post is going to be the post text ")>
<cfset record.setTitle("This is the post title")>
<!--if you remove validate database schema is not queried-->
<cfset record.validate()>
<cfset record.save()>
Ali
>>> "Doug Hughes" <[EMAIL PROTECTED]> 4/22/2008 8:46 AM >>>
Did you use the reactor configuration that comes with MG's CS.xml? Or did
you provide your own?
Also - I've had embarasing experiances where the application itself was
reloading.... someone decided to clear the application scope in the
application.cfm for testing purposes and then checked that code in to our
repo.... thus the application was always reloading. I'd check to make sure
that's not the case.
But, it does sound to me like reactor is in development mode (even if
model-glue is in production).
Doug
On Tue, Apr 22, 2008 at 8:54 AM, Adam Cameron <[EMAIL PROTECTED]> wrote:
> To me it sounds like MG is set to reload on each request. You want MG not
> > to reload or rescaffold and you want reactor in production mode.
> >
>
> Hi Doug.
>
> I have this in my ColdSpring.xml file:
>
> {code}
> <property name="reload"><value>false</value></property>
> <!-- Rescaffold is overridden by reload - if reload is false, rescaffold's
> setting doesn't matter -->
> <property name="rescaffold"><value>false</value></property>
> {code}
>
> There's nothing either way specifically in ModelGlue.xml (my understanding
> being that this responsibility is taken over by ColdSpring.xml in the latest
> version of M-G).
>
> One variation from the installation guidelines I have is that my /reactor
> mapping is not set in CF, but is done in Application.cfc. And I have the
> mapping because I've got the reactor dir in a different dir:
> [base]/com/alagad/Reactor (the CF and site webroot are [base]/PhotoGallery;
> I'm using the inbuilt web server for this). Could this be an issue? I
> would expect if there was any problems with said approach I'd be getting far
> more serious issues than what I'm seeing (ie: I'd expect it not to work at
> all), so presume it's OK.
>
> As per previous, I reckon people shouldn't spend too much time on this @
> present as I'll set up some test rigs this evening in a more controlled
> environment, and have a mess around. I might be able to sort it out myself.
>
> That said, I do appreciate the suggestions: I'd just hate for you lot to
> be spending more time on this than I can, at present. If you know what I
> mean.
>
> Cheers.
>
>
> --
> Adam
>
>
>
>
>
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> -- --
> Reactor for ColdFusion Mailing List
> [EMAIL PROTECTED]
> Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> -- --
>
>
--
Doug Hughes, President
Alagad Inc.
[EMAIL PROTECTED]
888 Alagad4 (x3)
Office: 919-550-0755
Fax: 888-248-7836
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[EMAIL PROTECTED]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
--- Scanned by eMail Protection Services---
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[EMAIL PROTECTED]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
