I duplicated the problem and committed the fix to SVN.
While at it, I noticed that when reading the metadata reactor does it over
and over again... I put in a hack to work around that, which should help
with development mode speed a bit.
Doug
On Sat, Apr 26, 2008 at 1:29 PM, Chris Blackwell <
[EMAIL PROTECTED]> wrote:
> Hi Doug,
>
> Yes, I can confirm that getting a dictionary causes the schema to be
> requeried in production mode
> I'm using Rev 429, CF8 and mysql
>
> Cheers, Chris
>
> On 26/04/2008, Doug Hughes <[EMAIL PROTECTED]> wrote:
>
> > Can anyone else confirm that getting a dictionary causes the schema to
> > be requeried?
> >
> > Doug
> >
> > On Tue, Apr 22, 2008 at 11:17 AM, Ali Syed <[EMAIL PROTECTED]> wrote:
> >
> > > 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/
> > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> > > -- -- -- --
> > >
> > >
> >
> >
> > --
> > 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/
> > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> > -- -- --
> >
>
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> -- --
>
> 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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
