RE: [Reactor For CF] Big fixes / samples fixes / Oracle support / posgres update

[Doug Hughes]

Oh yea – blow away your project files.   Also change any references in your custom files to the ErrorManager to the Dictionary.    Doug   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Hughes Sent: Wednesday, March 15, 2006 11:14 PM To: reactor@doughughes.net Subject: [Reactor For CF] Big fixes / samples fixes / Oracle support / posgres update   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 -- reactor@doughughes.net -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/ -- Reactor for ColdFusion Mailing List -- reactor@doughughes.net -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/