• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
more oracle problems
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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