ok. I throw it on 9i then. :-P -Adam
On 3/16/06, Bowden, Beth (NIH/NIEHS) [E] <[EMAIL PROTECTED]> wrote: > I used Oracle 10g Express Edition. > > Beth Bowden > > Phone: 919-541-3355 FAX: 919-541-3687 > E-Mail: [EMAIL PROTECTED] > Address: NIEHS, MD EC-03, P.O. BOX 12233, Research Triangle Park, NC > 27709 > > > -----Original Message----- > From: Adrocknaphobia [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 16, 2006 12:48 PM > To: [email protected] > Subject: Re: [Reactor For CF] Big fixes / samples fixes / Oracle support > / posgres update > > Rock on. Should I assume Oracle has only been tested on 10g? > > -Adam > > On 3/15/06, Doug Hughes <[EMAIL PROTECTED]> wrote: > > > > > > > > This is just going to be a quick email... I'm exhausted! > > > > > > > > Anyhow, first off, Beth Bowden donated Oracle support last weekend. > It took > > me a few days to get oracle installed to test it. I did find a few > issues > > which I've addressed (beth I'll send you a separate email) and this > took a > > while. However it's there now. > > > > > > > > Both oracle and postgresql use sequences instead of > identity/autonumber > > values. To support this I added another argument "sequence" to the > field > > tag. This is used to specify the sequence that is used to get the > next > > value for that field when a new record is inserted. > > > > > > > > As a result of trying to keep all the samples more or less the same > across > > dbmx, the postgres samples don't use the sequence data type (though > it's > > perfectly legal to). Instead I use a default of nextval() on a > sequence. I > > did this because oracle doesn't allow long sequence names and I wanted > them > > the same between dbms. > > > > > > > > In DBMS that don't support sequences they're ignored. > > > > > > > > There were also some bug fixes to the framework and to the sample > apps. If > > luck is on my side all the sample apps should work on all the > platforms now > > (though the blog still has a few generic bugs I need to fix). > > > > > > > > I have a few more features I'm considering adding before beta: > > > > > > > > 1) ability to add your own expressions as fields to oo-querys > > > > > > > > 2) ability to run some specific code before the select in the > gateways > > > > > > > > (1 and 2 are specifically to allow for interfacing with row-level > encryption > > systems though they could be used for many other purposes. - I'll blog > an > > example when time permits and if I do this.) > > > > > > > > 3) DeleteByQuery on gateways > > > > > > > > 4) ...? > > > > > > > > I think that's it. Anything I'm missing? > > > > > > > > Doug-- 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/ > > > -- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
