On Mon, Nov 25, 2013 at 2:58 PM, Ian Turton <[email protected]> wrote:
> I'm getting a strange error when trying to connect to an Oracle DB using
> JNDI inside a JBOSS-EAP server.
>
> 2013-11-25 13:33:54,046 DEBUG [org.geotools.factory] - Factory
> implementations for category UnWrapper:
> org.geoserver.data.jdbc.SpringUnWrapper
> org.geotools.data.jdbc.datasource.DBCPUnWrapper
> org.geotools.jdbc.LifecycleConnectionUnWrapper
> 2013-11-25 13:33:54,054 WARN [org.geotools.jdbc] - Failed to use
> SDO_TUNE.EXTENT_OF, falling back on envelope aggregation
> java.sql.SQLException: Could not obtain native oracle connection for class
> org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6
> at
> org.geotools.data.oracle.OracleDialect.unwrapConnection(OracleDialect.java:565)
> at
> org.geotools.data.oracle.OracleDialect.readGeometry(OracleDialect.java:502)
> at
> org.geotools.data.oracle.OracleDialect.readGeometry(OracleDialect.java:492)
> at
> org.geotools.data.oracle.OracleDialect.getOptimizedBounds(OracleDialect.java:754)
> at org.geotools.jdbc.JDBCDataStore.getBounds(JDBCDataStore.java:1141)
> at
> org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:501)
> at
> org.geotools.jdbc.JDBCFeatureStore.getBoundsInternal(JDBCFeatureStore.java:189)
>
> The rest of the log is attached.
>
> Interestingly the connection works fine if I use the normal Oracle
> Datastore (with the same jar - which is an updated version for 11.2 rather
> than the one that ships with GeoServer).
>
> Has anyone seen anything similar or got any hints as to how I can go about
> debugging further?
>
In order to read Oracle geometries we need to original Oracle connection.
All connection pools wrap the native connections with some pooling wrapper,
and we have a list
of objects implementing org.geotools.data.jdbc.datasource.UnWrapper that
know how to unwrap
specific pooled connections.
I guess we don't have one for the JBOSS pools.
Mind, if you want to add one, make sure you're using reflection to avoid
the code to be dependent on the
JBoss jars.
Cheers
Andrea
--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
------------------------------------------------------------------------------
Shape the Mobile Experience: Free Subscription
Software experts and developers: Be at the forefront of tech innovation.
Intel(R) Software Adrenaline delivers strategic insight and game-changing
conversations that shape the rapidly evolving mobile landscape. Sign up now.
http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
