Lists

Terms and Conditions
Lists hosted on this site
Email the Postmaster
Tips for posting to public mailing lists

more oracle problems

Subject: more oracle problems
From: Dave Elsner <email@hidden>
Date: Tue, 4 Apr 2006 14:36:06 +1000

Hi,

After moving an existing application to Oracle 9i. I have encountered some problems with the SQL being generated from WebObjects, it generates the following SQL:

SELECT DISTINCT t0.academicGeneral, t0.accessLevel, t0.activeNameID, t0.brandNewRecord, RTRIM(t0.building), t0.countryID, t0.degreeID, t0.email, RTRIM(t0.fax), t0.fileName, t0.filePath, t0.groupID, t0.hasFile, t0.personCode, RTRIM(t0.phone), RTRIM(t0.room), t0.pkID, RTRIM(t0.serialNumber), RTRIM(t0.staffNumber), RTRIM(t0.title), t0.tobeShown, t0.type, t0.updatedNightly, RTRIM(t0.URL), RTRIM (t0.wumpusID) FROM PERSON t0, PSN_NAME T1 WHERE (t0.type = 3 AND t0.accessLevel <> -1) AND t0.activeNameID = T1.pkID ORDER BY T1.lastName ASC, T1.firstName ASC


This SQL produces an error saying:

Next exception:SQL State:42000 -- error code: 1791 -- msg: ORA-01791: not a SELECTed expression

at com.webobjects.jdbcadaptor.JDBCContext._jdbcErrorWithChannel (JDBCContext.java:138) at com.webobjects.jdbcadaptor.JDBCChannel._evaluateExpression (JDBCChannel.java:310) at com.webobjects.jdbcadaptor.JDBCChannel.evaluateExpression (JDBCChannel.java:261) at com.webobjects.jdbcadaptor.JDBCChannel.selectAttributes (JDBCChannel.java:185) at com.webobjects.eoaccess.EODatabaseChannel._selectWithFetchSpecificationE ditingContext(EODatabaseChannel.java:879)

If I remove the DISTINCT or the ORDER BY then it works fine. Is there any reason the above SQL should not work and if so why is WO generating incorrect SQL?

TIA
- Dave
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden


Follow-Ups:

Re: more oracle problems
From: Guido Neitzer <email@hidden>
Re: more oracle problems
From: wojingo <email@hidden>


Prev by Date:
QTSS Frontend

Next by Date:
Re: QTSS Frontend

Previous by thread:
Re: QTSS Frontend

Next by thread:
Re: more oracle problems

Index(es):

Date
Thread