Hi Clemens, I don't know why it's happening, seems like your unwrapper is not found. The code working with unwrappers is generic, and failing to find an unwrapper, should also check if the connection is implementing the Java Wrapper interface, but that does not seem to work either eh?
The DBCP unwrapping class is apparently still working, since we keep on working with Oracle without facing the same issue. I'd suggest to add a breakpoint around here: https://github.com/geotools/geotools/blob/18069b4d295af1da3d402d20ed499daeb6a40e98/modules/plugin/jdbc/jdbc-oracle/src/main/java/org/geotools/data/oracle/OracleDialect.java#L646 and follow from there in a debug session. Let us know what you find out! Cheers Andrea On Sat, Jul 27, 2019 at 12:39 PM Clemens Eisserer <linuxhi...@gmail.com> wrote: > Hi, > > I am currently trying to upgrade geotools from 14.3 to 21.2 in a > project in order to make it Java-11 compatible. > So far, everything seems to work again, except for unwrapping > connections from the connection pool (Hikari pool) when running on > tomcat. > > With geotools 14.3 it was enough to place a service-file in > META-INF/services named "org.geotools.data.jdbc.datasource.UnWrapper" > and the content: > "at.somecompany.spatial.geotools.data.oracle.HikariCpUnWrapper". With > 21.2 I get the exception below. > > WARNUNG: Oracle NG (JNDI) should be used, but could not connect > java.io.IOException: Unable to obtain Oracle Connection require for > SDO Geometry access).Check connection pool implementation to unsure > unwrap is available > at > org.geotools.data.oracle.OracleNGDataStoreFactory.createDataStoreInternal(OracleNGDataStoreFactory.java:176) > at > org.geotools.jdbc.JDBCJNDIDataStoreFactory.createDataStoreInternal(JDBCJNDIDataStoreFactory.java:180) > at > org.geotools.jdbc.JDBCDataStoreFactory.createDataStore(JDBCDataStoreFactory.java:389) > at > org.geotools.jdbc.JDBCDataStoreFactory.createDataStore(JDBCDataStoreFactory.java:48) > at > org.geotools.data.DataAccessFinder.getDataStore(DataAccessFinder.java:119) > at > org.geotools.data.DataStoreFinder.getDataStore(DataStoreFinder.java:69) > > Any idea what was / could have been changed between 14.3 and 21.2 that > could lead to the unwrapper being ignored / not found? > > Thank you in advance & best regards, Clemens > > > _______________________________________________ > GeoTools-GT2-Users mailing list > GeoTools-GT2-Users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users > -- Regards, Andrea Aime == GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information. == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via di Montramito 3/A 55054 Massarosa (LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 http://www.geo-solutions.it http://twitter.com/geosolutions_it ------------------------------------------------------- *Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia. This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail.*
_______________________________________________ GeoTools-GT2-Users mailing list GeoTools-GT2-Users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
