Thanks for the insight Brian. I do understand that Reactor is still in
development. But, like you say, I see many posts using the alias and
none of them seem to be having an issue with it.
I personally feel the post I sent a few weeks ago was pretty straight
forward. I'll repost if below and I would love some one could help.
As I sense a little defensiveness in your reply, please don't think
I'm posting with a bad attitude. I'm simply asking if you all could
tell me how to get help with this seemingly simple issue since posting
to this list isn't getting the issue resolved.
For what it's worth, I believe there might be a bigger issue here.
Last night we traced the issue and the reactor core is not translating
the alias before it hits the stored procedure.
This works:
<object name="EVENTS">
<hasmany name="EVENT_ROLE">
<link name="EVENT_ROLE" />
</hasmany>
</object>
<cfset test = reactor.createGateway('EVENTS') />
This does not work (error below).
<object name="EVENTS" alias="TEST">
<hasmany name="EVENT_ROLE">
<link name="EVENT_ROLE" />
</hasmany>
</object>
<cfset test = reactor.createGateway('TEST') />
What am I doing wrong?
On 4/14/06, Brian Kotek <[EMAIL PROTECTED]> wrote:
> If it's causing you this much of a problem you may want to hold off on using
> Reactor for this project. It is still a piece of beta software and everyone
> here working on it or participating in the forums also has other
> responsibilities. It's one thing to ask a relatively straighforward
> question, it's quite another to post dozens of lines of XML and an ER
> diagram and ask what's wrong. For what its worth, I've used Reactor with the
> alias and haven't had any problems.
>
> One thing that may help would be if you could post the most simple example
> you can create that demonstrates the problem.
>
> Regards,
>
> Brian
>
>
>
> On 4/14/06, Brian Billings <[EMAIL PROTECTED]> wrote:
> >
> All,
>
> Questions on my questions. Are we asking the wrong question or not
> providing enough info?
>
> We have been having the issue for over a month and posted 6 or 7
> different posts and for what ever reason cannot get any help with it.
>
> For ahile we could just not use the alias but we are to the point that
> we have to have them to go forward and this issue with Reactor is hold
> us back.
>
> Is there something more we can do to get help with this?
>
>
>
> On 4/10/06, Brian Billings <[EMAIL PROTECTED]> wrote:
> > Simeon and all,
> > When I changed the XLM to what you provided and i'm getting this error
> > when I run the code below:
> >
> > <cfset local.gateway = variables.reactor.createGateway("ROLES") />
> >
> > First Attempt:
> > <cfset local.query =
> > local.gateway.createQuery
> ().join('ROLES','EVENT_ROLE','ER_').join('EVENT_ROLE','EVENTS','E_')
> > />
> >
> > I also tried this and got a similar message:
> > <cfset local.query =
> local.gateway.createQuery().join('ROLES','EVENTS','E_') />
> >
> > Message Relationship Does Not Exist
> > Detail The object 'EVENT_ROLE' does have have a relationship with an
> > alias of 'EVENTS'.
> > Extended Info
> > Tag Context F:\MARC\Reactor\base\abstractMetadata.cfc
> (167)
> >
> >
> > Here is what is in my file.
> >
> > <object name="EVENTS">
> > <hasmany name="ROLES">
> >
> > <link name="EVENT_ROLE" />
> > </hasmany>
> > </object>
> >
> > <object name="ROLES">
> > <hasmany name="EVENTS">
> >
> > <link name="EVENT_ROLE" />
> > </hasmany>
> > </object>
> > <object name="EVENT_ROLE">
> > <hasone name="EVENTS">
> > <relate from="EVENT_SK" to="EVENT_SK" />
> > </hasone>
> > <hasone name="ROLES">
> >
> > <relate from="ROLE_SK" to="ROLE_SK" />
> > </hasone>
> > </object>
> >
> >
> > Thanks for your help.
> >
> > On 4/10/06, Simeon Bateman <[EMAIL PROTECTED]> wrote:
> > >
> > > Ignore that code in the other post. Gmail sent too early :)
> > >
> > > Here is what I think that config would look like:
> > >
> > > <object name="EVENTS">
> > > <hasmany name="ROLES">
> > >
> > > <link name="EVENT_ROLE" />
> > > </hasmany>
> > > </object>
> > >
> > > <object name="ROLES">
> > > <hasmany name="EVENTS">
> > >
> > > <link name="EVENT_ROLE" />
> > > </hasmany>
> > > </object>
> > > <object name="EVENT_ROLE">
> > > <hasone name="EVENTS">
> > > <relate from="EVENT_SK" to="EVENT_SK" />
> > > </hasone>
> > > <hasone name="ROLES">
> > >
> > > <relate from="ROLE_SK" to="ROLE_SK" />
> > > </hasone>
> > > </object>
> > >
> > >
> > > Let me know if that makes sense. EVENTS haveMany ROLES; ROLES haveMany
> EVENTS; and the to are linked by the EVENT_ROLE object.
> > >
> > > sim
> > >
> > >
> > >
> > > On 4/9/06, Simeon Bateman <[EMAIL PROTECTED]> wrote:
> > > >
> > > > Looking at this closer here is what I would expect to see. It appears
> that the EVENTS object need to have a "hasMany" relations ship with ROLES.
> and then you would link those via teh Event_ROLE table. I would expect the
> confif for that to look like this.
> > > >
> > > >
> > > > <object name="EVENTS">
> > > >
> > > > <hasmany name="EVENT_ROLE">
> > > >
> > > > <link name="EVENT_ROLE" />
> > > >
> > > > </hasmany>
> > > >
> > > > </object>
> > > >
> > > >
> > > > <object name="ROLE">
> > > >
> > > > <hasMany name="EVENTS">
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > </object>
> > > >
> > > >
> > > > <object name="EVENT_ROLE">
> > > >
> > > > <hasone name="EVENTS">
> > > >
> > > > <relate from="EVENT_SK" to="EVENT_SK" />
> > > >
> > > > </hasone>
> > > >
> > > > <hasone name="ROLES">
> > > >
> > > > <link name="ROLES" />
> > > >
> > > > </hasone>
> > > >
> > > > </object>
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > On 4/8/06, Brian Billings < [EMAIL PROTECTED]> wrote:
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Yesterday I submitted a post about the problem I am having with the
> alias in the reactor config file (which is still unresolved) and I believe
> it was Simeon that brought up a possible issue with the way I am linking
> objects in the cofig file.
> > > > >
> > > > >
> > > > >
> > > > > I have had a very hard time wrapping my head around how the config
> file works and I honestly still don't understand it completely. My code runs
> with all of the intricate joins so I don't think it is totally wrong.
> > > > >
> > > > >
> > > > >
> > > > > I have attached a gif of my database tables and the Reactor file. I
> don't have all of the objects mapped yet (im basically mapping the
> relationships as I need them).
> > > > >
> > > > >
> > > > >
> > > > > Before I go forward I would like to be sure that am I doing this
> right? Like I mentioned, it works.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Summary of what I am doing:
> > > > >
> > > > > -Roles are defined (ROLES)
> > > > >
> > > > > -Applications are defined (APPLICATIONS)
> > > > >
> > > > > -Applications have events (APPLICATION_EVENT)
> > > > >
> > > > > -Events are assigned roles (EVENT_ROLE)
> > > > >
> > > > > -User are assigned roles via direct mapping (USER_ROLE) or via group
> (GROUPS, GROUP_ROLE & GROUP_USER)
> > > > >
> > > > > -User must have one or more roles assigned to the event to see the
> event
> > > > >
> > > > >
> > > > >
> > > > > <reactor>
> > > > >
> > > > > <config>
> > > > >
> > > > > <project value="MARC" />
> > > > >
> > > > > <dsn value="MARC" />
> > > > >
> > > > > <type value="mssql" />
> > > > >
> > > > > <mapping value="/core/model/Reactor" />
> > > > >
> > > > > <mode value="always" />
> > > > >
> > > > > </config>
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > <objects>
> > > > >
> > > > >
> > > > >
> > > > > <object name="EVENTS">
> > > > >
> > > > > <hasmany name="EVENT_ROLE">
> > > > >
> > > > > <link name="EVENT_ROLE" />
> > > > >
> > > > > </hasmany>
> > > > >
> > > > > </object>
> > > > >
> > > > >
> > > > >
> > > > > <object name="EVENT_ROLE">
> > > > >
> > > > > <hasone name="EVENTS">
> > > > >
> > > > > <relate from="EVENT_SK" to="EVENT_SK" />
> > > > >
> > > > > </hasone>
> > > > >
> > > > > <hasone name="ROLES">
> > > > >
> > > > > <link name="ROLES" />
> > > > >
> > > > > </hasone>
> > > > >
> > > > > </object>
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > <object name="GROUP_ROLE">
> > > > >
> > > > > <hasone name="GROUPS">
> > > > >
> > > > > <relate from="GROUP_SK" to="GROUP_SK" />
> > > > >
> > > > > </hasone>
> > > > >
> > > > > <hasone name="ROLES">
> > > > >
> > > > > <link name="ROLES" />
> > > > >
> > > > > </hasone>
> > > > >
> > > > > </object>
> > > > >
> > > > >
> > > > >
> > > > > <object name="GROUPS">
> > > > >
> > > > > <hasmany name="GROUP_ROLE">
> > > > >
> > > > > <link name="GROUP_ROLE" />
> > > > >
> > > > > </hasmany>
> > > > >
> > > > >
> > > > >
> > > > > </object>
> > > > >
> > > > >
> > > > >
> > > > > <object name="USER_ROLE">
> > > > >
> > > > > <hasone name="USERS">
> > > > >
> > > > > <relate from="USER_SK" to="USER_SK" />
> > > > >
> > > > > </hasone>
> > > > >
> > > > > <hasone name="ROLES">
> > > > >
> > > > > <relate from="ROLE_SK" to="ROLE_SK" />
> > > > >
> > > > > </hasone>
> > > > >
> > > > > </object>
> > > > >
> > > > >
> > > > >
> > > > > <object name="ROLES">
> > > > >
> > > > > <hasMany name="GROUP_ROLE">
> > > > >
> > > > > <relate from="ROLE_SK" to="ROLE_SK" />
> > > > >
> > > > > </hasMany>
> > > > >
> > > > > <hasMany name="EVENT_ROLE">
> > > > >
> > > > > <relate from="ROLE_SK" to="ROLE_SK" />
> > > > >
> > > > > </hasMany>
> > > > >
> > > > > <hasMany name="USER_ROLE">
> > > > >
> > > > > <relate from="ROLE_SK" to="ROLE_SK" />
> > > > >
> > > > > </hasMany>
> > > > >
> > > > > </object>
> > > > >
> > > > >
> > > > >
> > > > > <object name="USERS">
> > > > >
> > > > > <hasMany name="USER_ROLE">
> > > > >
> > > > > <relate from="USER_SK" to="USER_SK" />
> > > > >
> > > > > </hasMany>
> > > > >
> > > > > <hasMany name="GROUP_USER">
> > > > >
> > > > > <relate from="USER_SK" to="USER_SK" />
> > > > >
> > > > > </hasMany>
> > > > >
> > > > > </object>
> > > > >
> > > > >
> > > > >
> > > > > <object name="GROUP_USER">
> > > > >
> > > > > <hasOne name="GROUPS">
> > > > >
> > > > > <relate from="GROUP_SK" to="GROUP_SK" />
> > > > >
> > > > > </hasOne>
> > > > >
> > > > > </object>
> > > > >
> > > > >
> > > > >
> > > > > </objects>
> > > > >
> > > > > </reactor>
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
>
>
>
> -- 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/
-- Reactor for ColdFusion Mailing List -- [email protected]
-- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
