The problem may be in your config file. Can you verify that your table and column names are uppercased?
Beth Bowden
Phone: 919-541-3355 FAX: 919-541-3687
E-Mail: [EMAIL PROTECTED]
Address: NIEHS, MD EC-03, P.O. BOX 12233, Research Triangle Park, NC 27709
From: Brian Kotek [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 04, 2006 2:21 PM
To: [email protected]
Subject: Re: [Reactor For CF] Is Reactor oracle 8i compliant?
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 6103 : AND col.TABLE_NAME = colCon.TABLE_NAME104 : AND colCon.CONSTRAINT_NAME = tabCon.CONSTRAINT_NAME105 : 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
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 -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
-- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/-- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
-- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
