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/
