Have you tested that the Tomcat-server is actually able to create a connection to the database? I loose count of the number of times some internal firewall prevents connections on TCP 1521, or the connection string is misspelt, or ..
Best Regards, /julian -----Oprindelig meddelelse----- Fra: benjoh [mailto:[email protected]] Sendt: 10. august 2016 10:02 Til: [email protected] Emne: Re: [Geoserver-users] Problem reading features: SQLException: Could not obtain native oracle connection for class com.sun.proxy.$Proxy11 Thanks for the reply! I am not in control over the Tomcat-server we use. I can only deploy applications and configure them. This is my connection resource if it helps: <Resource name="jdbc/app" auth="Container" factory="oracle.ucp.jdbc.PoolDataSourceImpl" type="oracle.ucp.jdbc.PoolDataSource" description="jdbc/trafikkna datasource" connectionFactoryClassName="oracle.jdbc.pool.OracleDataSource" minPoolSize="30" maxPoolSize="30" inactiveConnectionTimeout="20" maxConnectionReuseCount="10" user="user" password="password" onsConfiguration="nodes=node-1,node-2" fastConnectionFailoverEnabled="true" connectionProperties=";oracle.net.ns.SQLnetDef.TCP_CONNTIMEOUT_STR=3000;" url="jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = host)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = service_name)))" connectionPoolName="jdbc/app" validateConnectionOnBorrow="true" sqlForValidateConnection="select 1 from DUAL" /> These are the jars that are inside tomcat libs: catalina-jmx-remote.jar, ojdbc7.jar, ons.jar, simplefan.jar, tomcat-juli-adapters.jar and ucp.jar There is an ojdbc.jar in geoserver.war as well. Could that cause the issue? I could try to remove it and redeploy geoserver. What is weird though, is that I use geoserver in another application on another tomcatserver with the same jars and that works perfectly fine. -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Problem-reading-features-SQLException-Could-not-obtain-native-oracle-connection-for-class-com-sun-pr1-tp5279641p5280185.html Sent from the GeoServer - User mailing list archive at Nabble.com. ------------------------------------------------------------------------------ What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports. http://sdm.link/zohodev2dev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users ------------------------------------------------------------------------------ What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports. http://sdm.link/zohodev2dev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
