Hi
We are getting started with Geoserver 2.5 here, hosted on Glassfish and things are going well. Following recommended practice I’m trying to setup a JNDI connection to our Oracle 11g database to be able to pool the connections between data stores and workspaces, however am receiving the following error :
error:java.lang.RuntimeException: Error reading Features java.lang.RuntimeException: Error reading Features Error reading Features java.sql.SQLException: Could not obtain native oracle connection for class com.sun.gjc.spi.jdbc40.ConnectionWrapper40 Could not obtain native oracle connection for class com.sun.gjc.spi.jdbc40.ConnectionWrapper40
This happens when trying to compute the bounds of a layer, or when viewing a layer if it’s been published with manually entered bounds.
It seems the issue is related to Ian’s error to do with geoserver not being able to backtrack from the JNDI connection to a native one when the pool is hosted on Glassfish:
http://osgeo-org.1560.x6.nabble.com/Oracle-JNDI-connection-with-JBOSS-EAP-td5091016.html
I’ve a couple of questions I hope someone can help me with, if this is indeed the problem;
- How could implement a fix to allow JNDI pools with Glassfish server ?
(We have limited Java experience to do this ourselves, but if it’s straightforward we could possibly give it a go) - If JNDI data stores resort to native connections to retrieve SDO_GEOMETRY objects, is there any benefit in using a JNDI pool over a native Oracle NG connection ?
Thanks,
Andrew
–
Andrew Kesterton
Team Leader (GIS), IT Division
Dundee City Council
