Scaffolding doesn't work in Oracle

[Bryan S]

Scaffolding only works in Oracle if you override the default and create the table name in all lower case

The fix is below.

D:\Inetpub\wwwroot\ModelGlue?\unity\orm\ReactorAdapter?.cfc

<cffunction name="list"

original code <cfset var md = getObjectMetadata(lcase(arguments.table)) />

removing the lcase fixes the problem <cfset var md = getObjectMetadata(arguments.table) />

[joe.rinehart]

I'll have to look into this further. There used to be case sensitivity issues inside reactor that forcing to lcase fixed.

What happens if you leave the table name as default and use reactor to create an all lower-case alias?

[Bryan S]

Replying to joe.rinehart:

What happens if you leave the table name as default and use reactor to create an all lower-case alias?

<object name="MYNEWTABLENAME91" alias="mynewtablename91"> </object>

---

ELIMINATES THIS BUT...

---

Oops! Message Object 'mynewtablename91' does not exist. Detail Reactor was unable to find an object in the database with the name 'mynewtablename91.' Extended Info Tag Context D:\Inetpub\wwwroot\reactor\core\objectFactory.cfc (145) D:\Inetpub\wwwroot\reactor\reactorFactory.cfc (101) D:\Inetpub\wwwroot\ModelGlue?\unity\orm\ReactorAdapter?.cfc (104) D:\Inetpub\wwwroot\ModelGlue?\unity\orm\ReactorAdapter?.cfc (457) D:\Inetpub\wwwroot\ModelGlue?\unity\controller\ReactorORMController.cfc (50) D:\Inetpub\wwwroot\ModelGlue?\unity\listener\Listener.cfc (26) D:\Inetpub\wwwroot\ModelGlue?\unity\eventrequest\MessageBroadcaster?.cfc (32) D:\Inetpub\wwwroot\ModelGlue?\unity\framework\ModelGlue?.cfc (332) D:\Inetpub\wwwroot\ModelGlue?\unity\framework\ModelGlue?.cfc (290) D:\Inetpub\wwwroot\ModelGlue?\unity\framework\ModelGlue?.cfc (263) D:\Inetpub\wwwroot\ModelGlue?\unity\ModelGlue?.cfm (75) D:\Inetpub\wwwroot\AppSecurityManager?\index.cfm (53)

---

THE VIEW OUTPUTS LIKE THIS: Note that it divides at every CapitalLetter? as you designed. Oddly though it is being aliased to all lower so in this case it should be mynewtablename91s which obviously isn't desireable either.

---

M Y N E W T A B L E N A M E91s / Add New M Y N E W T A B L E N A M E91

C O L O N E91 C O L T W O91 Z C O L T H R E E91 A C O L F O U R91 No Records

[joe.rinehart]

The lcase() call was removed as part of another commit. Please test against Oracle.