from table1
INNER JOIN table2 on table1.field = table2.field
inner joins are simply written as equi joins in Oracle
FROM table1, table 2
where table1.field = table2.field
as far as I'm aware this is the case for Oracle in general and is not an issue related to just 8.1.x ( although I haven't used it for 18 months ).
Neil
Ah ah! So I can't even do:
SELECT *
FROM Foo as f JOIN Bar as b
ON f.something = b.something
Instead of
SELECT *
FROM Foo as f INNER JOIN Bar as b
ON f.something = b.something
If that's correct then I'm not going to be able to support Oracle 8 in the 1.0 release.
Doug
From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Harry Klein
Sent: Wednesday, June 14, 2006 4:19 AM
To: [email protected]
Subject: AW: [Reactor for CF] Oracle?
Doug,
as far as I know Oracle 8 is only SQL/92 Entry-Level compliant and does not include features such as the new inner join syntax.
We always used
select ... from a, b
where a.col1 = b.col1
for inner joins
or
select ... from a, b
where a.col1 = b.col1 (+)
and
select ... from a, b
where a.col1 (+) = b.col1
for outer joins
-Harry
Von: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] Im Auftrag von Doug Hughes
Gesendet: Dienstag, 13. Juni 2006 23:48
An: [email protected]
Betreff: RE: [Reactor for CF] Oracle?Please log this as a bug on http://trac.reactorframework.com. Would everyone agree that the solution would simply be to remove the word "inner" from inner joins? I think this should consistently work cross dbms.
Doug
From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Newby Matthew S CONT PORT
Sent: Tuesday, June 13, 2006 4:58 PM
To: '[email protected]'
Subject: Re: [Reactor for CF] Oracle?
Doug,
Based on my initial testing with Oracle 8i, I think there might be a problem with the link tag. Of course, I just got Reactor working today, so it's quite likely I've made a mistake somewhere... :-)
I have three tables, a users table, a roles table, and a users_roles linking table (actually, I've got close to 40 tables, but I'm starting small with reactor). My Reactor.xml file has something like the following in the objects tag:
<objects>
<object name="MYAPP_USERS" >
<hasOne name="USER_STATUS_REF" >
<relate from="USER_STATUS_ID" to="USER_STATUS_ID" />
</hasOne>
<hasMany name="USER_NETWORK_ACCOUNTS" >
<relate from="USER_SA_ID" to="USER_SA_ID" />
</hasMany>
<hasMany name="ROLE_DEFS_KEY" >
<link name="USERS_ROLES" />
</hasMany>
</object>
<object name="USERS_ROLES" >
<hasOne name="MYAPP_USERS" >
<relate from="USER_SA_ID" to="USER_SA_ID" />
</hasOne>
<hasOne name="ROLE_DEFS_KEY" >
<relate from="ROLE_ID" to="ROLE_ID" />
</hasOne>
</object>
<object name="ROLE_DEFS_KEY" >
<hasMany name="MYAPP_USERS" >
<link name="USERS_ROLES" />
</hasMany>
</object>
</objects>
So, I created a page and instanced the reactor object and added the following CF code, following the examples in the incomplete but excellent documentation:
<cfset UserRecord = reactor.createRecord("MYAPP_USERS").load(USER_SA_ID=15)/>
<cfset qRoles = UserRecord.getROLE_DEFS_KEYIterator().getQuery()/>The SQL used for the getQuery() is something like:
SELECT
"ROLE_DEFS_KEY"."ROLE_DESCRIPTION" AS "ROLE_DESCRIPTION",
"ROLE_DEFS_KEY"."ROLE_ID" AS "ROLE_ID",
"ROLE_DEFS_KEY"."ROLE_NAME" AS "ROLE_NAME",
"ROLE_DEFS_KEY"."SHOW" AS "SHOW"
FROM
"MYAPP"."ROLE_DEFS_KEY" "ROLE_DEFS_KEY"
INNER JOIN "MYAPP"."USERS_ROLES" "USERS_ROLES"
ON "ROLE_DEFS_KEY"."ROLE_ID" = "USERS_ROLES"."ROLE_ID"
WHERE
"USERS_ROLES"."USER_SA_ID" = 15
The INNER JOIN ... ON syntax is not recognized by Oracle 8i. ColdFusion throws a Database error of "[Macromedia][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended". TOAD croaks on a copy of the query on the word "INNER", with the same ORA-00933 error.
I have another copy of my database in Oracle 10g and am able to run the query in TOAD with no problems there.
My $0.02 worth,
-matt
Matthew Newby
PNS Web Services
PH: 207-438-5263
email: [EMAIL PROTECTED]
When digitally signed, the signature is in accordance with DoDI 8520.2, dated 1 Apr 2004.On Sat, 03 Jun 2006 15:16:23 -0700, Doug Hughes wrote:
Hey people -
I can't remember if reactor works with Oracle 8i or not. (Muchless 9i or 10whatever.)
Beth - Any chance you could tell me which versions it works with?
Doug
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
--
"I like work: it fascinates me. I can sit and look at it for hours."
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
