[Reactor For CF] Is Reactor oracle 8i compliant?

[bayo Ojo]

We have an application we are migrating to MG and using Reactor for database persistence. The DB is oracle 8i, we get this error when we try to do creategateway,       Error Executing Database Query.   [Macromedia][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended     The error occurred in E:\CERT\JCert\CFC\Reactor\ReactorBER\trunk\reactor\data\oracle\ObjectDao.cfc: line 105 Called from E:\CERT\JCert\CFC\Reactor\ReactorBER\trunk\reactor\data\oracle\ObjectDao.cfc: line 8 Called from E:\CERT\JCert\CFC\Reactor\ReactorBER\trunk\reactor\core\objectFactory.cfc: line 194 Called from E:\CERT\JCert\CFC\Reactor\ReactorBER\trunk\reactor\core\objectFactory.cfc: line 41 Called from E:\CERT\JCert\CFC\Reactor\ReactorBER\trunk\reactor\reactorFactory.cfc: line 20 Called from E:\CERT\JCert\CFC\Reactor\UserOracle\test.cfm: line 6 Called from E:\CERT\JCert\CFC\Reactor\ReactorBER\trunk\reactor\data\oracle\ObjectDao.cfc: line 105 Called from E:\CERT\JCert\CFC\Reactor\ReactorBER\trunk\reactor\data\oracle\ObjectDao.cfc: line 8 Called from E:\CERT\JCert\CFC\Reactor\ReactorBER\trunk\reactor\core\objectFactory.cfc: line 194 Called from E:\CERT\JCert\CFC\Reactor\ReactorBER\trunk\reactor\core\objectFactory.cfc: line 41 Called from E:\CERT\JCert\CFC\Reactor\ReactorBER\trunk\reactor\reactorFactory.cfc: line 20 Called from E:\CERT\JCert\CFC\Reactor\UserOracle\test.cfm: line 6 103 :                          AND col.TABLE_NAME         = colCon.TABLE_NAME 104 :                          AND colCon.CONSTRAINT_NAME = tabCon.CONSTRAINT_NAME 105 :                  WHERE col.TABLE_NAME =  <cfqueryparam cfsqltype="cf_sql_varchar" scale="128" value="#arguments.Object.getName()#" /> 106 :          </cfquery> 107 : SQL    SELECT col.COLUMN_NAME as name, CASE WHEN colCon.CONSTRAINT_NAME IS NOT NULL THEN 'true' ELSE 'false' END as primaryKey, col.NULLABLE, col.DATA_TYPE as dbDataType, col.DATA_LENGTH as length, col.DATA_DEFAULT as "DEFAULT" FROM all_tab_columns col LEFT JOIN all_constraints tabCon ON col.TABLE_NAME = tabCon.TABLE_NAME AND tabCon.CONSTRAINT_TYPE = 'P' LEFT JOIN all_cons_columns colCon ON col.COLUMN_NAME = colCon.COLUMN_NAME AND col.TABLE_NAME = colCon.TABLE_NAME AND colCon.CONSTRAINT_NAME = tabCon.CONSTRAINT_NAME WHERE col.TABLE_NAME = (param 1) DATASOURCE   netbank VENDORERRORCODE   933 SQLSTATE   HY000     Please try the following: Check the ColdFusion documentation to verify that you are using the correct syntax. Search the Knowledge Base to find a solution to your problem.   Browser   Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322) Remote Address   127.0.0.1 Referrer     Date/Time   04-Apr-06 02:27 PM     Stack Trace (click to expand)     Please any ideas?   Bayo Ojo Integrated Software Services Limited 15, Akinsemoyin Street, Surulere, Lagos, Nigeria. Mobile:2348033087030 Tel:     7915935     -- Reactor for ColdFusion Mailing List -- reactor@doughughes.net -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/