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

[Brian Kotek]

I'm pretty sure it was only tested with 9i and 10g.

On 4/4/06, bayo Ojo <[EMAIL PROTECTED]> wrote:

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/

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