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 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:
|
|
|
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 -- [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/
|
