I believe that if you need to make a change to the DAO, etc, that you can do it in a custom set of XSL files for Oracle and then submit that. Beth Bowden would be the best person to collaborate wih on this since I believe she created the original set of XSL for Oracle in the first instance. This is just going from memory though.

~Jeff

On 5/20/06, Douglas Knudsen <[EMAIL PROTECTED]> wrote:
ok, so I can modify the file reactor/xsl/dao.project.xsl  adding in a
wee bit to the section controlling creation of the DAOs update method.
Works for me, but for the rest of the world that doesn't use Oracle I
dunno.  Maybe everyone should just use Oracle?  ha!! Old Steve would
like that , eh?

I thought about whether this is a good thing or not too.  Would it be
better to in this sort of case, not create a update?  Or maybe its
better to maek the update() method actually perform a delete() then a
create()?

I know Doug is out and all, and he better stay away, eh?  I've never
really gotten involved with this sort of thing. How to contribute
here?

DK


On 5/19/06, Douglas Knudsen <[EMAIL PROTECTED]> wrote:
> yes, this is known.  Its because Oracle stores all its table metadata
> using upper case.  Not the issue with the below though.
>
> DK
>
> On 5/19/06, wikiwikiman <[EMAIL PROTECTED]> wrote:
> > Since you're using Oracle, you had better make sure that all table and
> > field names are uppercased (that's what Oracle reuires). If I'm not
> > mistaken, the latest version of Reactor may well have a bug in this
> > matter - try uppercasing your names in the reactor.xml file and try
> > again...
> >
> > Wouter
> >
> > On 5/19/06, Douglas Knudsen <[EMAIL PROTECTED]> wrote:
> > > I have a table called mytable say with two columns fkone and fktwo.
> > > This table is a so called link table and both columns comprise the
> > > primary key.  I'm using Oracle BTW.  Looking at the DAO for this table
> > > generated by reactor I see SQL like this
> > >
> > > UPDATE mytable
> > > SET
> > > WHERE
> > > fkone = ...
> > > AND
> > > fktwo = ....
> > >
> > > obviously this bombs out when I try to perform a save() on the mytable
> > > object. Am I breaking a best practise here?  Or is this a bug of some
> > > sort?
> > >
> > > --
> > > Douglas Knudsen
> > > http://www.cubicleman.com
> > > this is my signature, like it?
> > >
> > >
> > >
> > > -- 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/
> >
> >
> >
>
>
> --
> Douglas Knudsen
> http://www.cubicleman.com
> this is my signature, like it?
>


--
Douglas Knudsen
http://www.cubicleman.com
this is my signature, like it?



-- 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/

Reply via email to