On Fri, Mar 18, 2011 at 11:32 AM, Terje Olsøybakk <te...@olsoybakk.no> wrote: > > > I have geoserver 2.1.RC2 using Weblogic Oracle 11g. > > Creating a store using both “Oracle NG” and “Oracle NG (JNDI)” works fine. > All layers are available from both stores. > > > > When I try publishing layers from the stores, the “Oracle NG (JNDI)” layer > creates problems, while the “Oracle NG” layer works fine. When publishing > layers both display correct Native SRS automatic. But when i try ”compute > from data” “Oracle NG” works fine while “Oracle NG (JNDI)” fails with the > error: java.lang.RuntimeException: java.io.IOException: Error occured > calculating bounds at > org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:476) > > If I fill in the bounding boxes manualy and test the layer via layer preview > and GML, I get the bounds error here instead:
The relevant error in the stack trace is: by: java.lang.ClassCastException: weblogic.jdbc.wrapper.Struct_oracle_sql_STRUCT Unfortunately Oracle designed oracle spatial in a very connection pooling unfriendly way, in order to properly work with it one has to unwrap the connections got from the pool in order to work against methods only the native connection provides. In this case it's the struct returned by the database that is being wrapped by weblogic pool it seems, that we're not prepared to unwrap (again, we need to get to the oracle one in order to have things work). Spring provides some generic connection unwrapping code but I'm not aware of equivalent code for structs. However... hum... have you removed from the GeoServer classpath the oracle jdbc driver, leaving it only in the container shared libs? Differences between the class versions of the two can often cause troubles Cheers Andrea -- ------------------------------------------------------- Ing. Andrea Aime GeoSolutions S.A.S. Tech lead Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 962313 mob: +39 333 8128928 http://www.geo-solutions.it http://geo-solutions.blogspot.com/ http://www.youtube.com/user/GeoSolutionsIT http://www.linkedin.com/in/andreaaime http://twitter.com/geowolf ------------------------------------------------------- ------------------------------------------------------------------------------ Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
