Re: [Reactor for CF] Oracle Problem - the case of an argument changes

[Beth Bowden]

Here's the issue as I see it w/ Oracle and Reactor. By default, Oracle always uppercases the names of database objects including table and column names. However, you can make the object name case-sensitive by the name in quotes.

So the below code creates two different tables, "MYTABLE" and "MyTable":

   create table myTable     ( myCol  char(1) );
  
   create table "myTable"   ( "myCol"  char(1) ); 
 
Table creation is done outside of reactor. So how does Reacor know which method was used?

I think assuming the unquoted method would work for 99% of the people using Oracle with Reactor. However, if Reactor uses the unquoted method, there would have no way to access a table created using quotes.

Reactor assumes the method w/ quotes was used. Hence, you have to use the exact case as you did when creating the table.

My personal preference is to assume the unquoted method but provide an override in the config file.

Beth

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
reactor@doughughes.net
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --