I found the thing that I had to do to make this work... but first:
I have at least three schemas that (due to various accidents) contain
the same set of objects (i.e. dbo.users, jared.users and
foobar.users)... I go and I log in as jared. The expectation is that
everything I do will be centered around the jared schema unless I
specify it should do something else.
Not so. If the user jared has DBA-level access to the DB, it seems
like Reactor will try to generate code for every instance of the same
columns in each schema... did that make sense? So if the table exists
in 3 schemas and the current user in the CF Admin DSN has DBA access,
I'll get a metadata chunk for the table's component parts at least 3
times.
Perhaps I can explain it better tomorrow when I'm more awaker.
J
------------------------------------------------
Jared C. Rypka-Hauer
Senior Software Engineer
Alagad - http://www.alagad.com/
Member: Adobe Community Experts - ColdFusion
Certified Advanced ColdFusion Developer
On Nov 29, 2007, at 4:52 PM, Tom McNeer wrote:
Jared,
On Nov 29, 2007 5:22 PM, Jared Rypka-Hauer <[EMAIL PROTECTED]>
wrote:
No, they're not empty, they ARE kept in the model directory, but
(at least for oracle) the Metadata classes are NOT EMPTY. They
contain references to the DB type and the schema.
Pardon me, I was incorrect. The generic is empty...
<cfcomponent hint="I am the database agnostic custom Metadata
object for the ENTITY object. I am generated, but not overwritten
if I exist. You are safe to edit me."
extends="reactor.project.mcicUnity.Metadata.ENTITYMetadata">
<!--- Place custom code here, it will not be overwritten --->
</cfcomponent>
The MSSQL-specific one is not:
<cfcomponent hint="I am the mssql custom Metadata object for the
ENTITY object. I am generated, but not overwritten if I exist.
You are safe to edit me."
extends="ENTITYMetadata">
<!--- Place custom code here, it will not be overwritten --->
<cfset variables.metadata.owner = "dbo" />
<cfset variables.metadata.dbms = "mssql" />
</cfcomponent>
I don't want to try to fix it for you, I want to compare what you
have with what I have to see if they are similar, since this is the
second time we've seen this problem it's hard to repro and it needs
to be fixed.
Very hard to reproduce, indeed. I tried.
I won't ask you to do anything, I just want to look at your generic
and DB-specific files.
Oh, you can ask me to do something. I'd be happy to do some testing
if you get a handle on something you want me to try. Let me know if
I can help at all.
Are you and/or Doug continuing active development on Reactor? I've
found definite advantages and disadvantages to both Transfer and
Reactor. I guess I had gotten the impression that Reactor
development had ceased.
--
Thanks,
Tom
Tom McNeer
MediumCool
http://www.mediumcool.com
1735 Johnson Road NE
Atlanta, GA 30306
404.589.0560
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- --
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
