Morten, here are some suggestions from a colleague: On 11/02/11 11:21, Warren, Peter (CESRE, North Ryde) wrote: > Does Geoserver build SQL with subqueries? I wouldn't have thought so. If it doesn't then this is likely an error in a view definition. > If it does build SQL with subqueries then this could be caused by duplicate feature_IDs used in the chaining. > Note: We really don't have much to go on here so I could be wrong.
On 11/02/11 10:30, Ben Caradoc-Davies wrote: > Morten, > > please turn on verbose logging and let us know if you can see the SQL > that is generated when you get this error. > > Can we please see your app-schema mapping file? > > Kind regards, > Ben. > > On 10/02/11 20:22, Lindegaard, Morten wrote: >> Hi, >> >> I have installed 2.1-RC1 recently, and I have copied a configuration that >> use the app-schema and oracle extensions from beta3 to RC1. >> >> The configuration nests features, and selects from various views and tables. >> >> It works fine in beta3, but RC1 fails with "java.lang.RuntimeException: >> java.sql.SQLException: ORA-01427: single-row subquery returns more than one >> row". >> >> Does anyone know of changes from beta3 to RC1 that would explain the change >> in behaviour? >> >> Thanks in advance! >> >> Kind regards, >> Morten Lindegaard >> >> >> > -- Ben Caradoc-Davies <[email protected]> Software Engineering Team Leader CSIRO Earth Science and Resource Engineering Australian Resources Research Centre ------------------------------------------------------------------------------ The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE: Pinpoint memory and threading errors before they happen. Find and fix more than 250 security defects in the development cycle. Locate bottlenecks in serial and parallel code that limit performance. http://p.sf.net/sfu/intel-dev2devfeb _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
