search

geosolutions-it / DATEX-Utilities

DATEX Utilities
https://datex2.eu/
1 stars 2 forks source link

Geoserver and Oracle 12 integration with ojdbc8 #11

Closed simboss closed 6 years ago

simboss commented 6 years ago

Freshdesk Ticket ID: 16306
Freshdesk Ticket Agent: Support
Freshdesk Ticket Agent Email: support@geo-solutions.it
Ticket Priority: Medium
Freshdesk Ticket Description:

See related discussion on google group.

An estimate is required.


simboss commented 6 years ago

Comment added by agent Support in Freshdesk ticket id 16306:

Hi Gabriel Jonsson,

a couple of questions to better understand the exception you get:

 - which ojdbc8 jars did you deploy (e.g. ojdbc8.jar, ucp.jar, etc.)
 - where did you deploy them (GeoServer WEB-INF/lib or tomcat lib dir)?
 - did you use JNDI to configure your connections (and do you have an example resource connection to see)?

Thanks

Ticket: http://geosolutions.freshdesk.com/helpdesk/tickets/16306

 
==
Our support, Your Success! Visit http://www.geo-solutions.it/enterprise-support-services for more information.
==
Support Engineer

GeoSolutions S.A.S.
Via di Montramito 3/A
55054  Massarosa (LU)
Italy
fax:     +39 0584 1660272

simboss commented 6 years ago

Comment added by customer Gabriel Jonsson in Freshdesk ticket id 16306:

Attaching copy of drivers in drivers.zip
I believe it is the same you get from https://www.oracle.com/technetwork/database/features/jdbc/jdbc-ucp-122-3110062.html

Drivers are placed in <Tomcat base directory>/lib 
Naming slightly different. We have ojdbc.jar, and it is ojdbc8.jar on webpage. (I believe the reason is our Tomcat admins set up symbolic links to simplify switching between driver versions.)

I also tried once to place drivers in GeoServer WEB-INF/lib once but it did not help. 

Part of the JNDI settings from Tomcat context.xml with some sensitive data replaced with aaaaaa etc. 

                <Resource
                        name="jdbc/trafikknageo"
                        auth="Container"
                        factory="oracle.ucp.jdbc.PoolDataSourceImpl"
                        type="oracle.ucp.jdbc.PoolDataSource"
                        description="jdbc/trafikkna datasource"
                        connectionFactoryClassName="oracle.jdbc.pool.OracleDataSource"
                        minPoolSize="50"
                        maxPoolSize="50"
                        inactiveConnectionTimeout="20"
                        maxConnectionReuseCount="10"
                        user="aaaaaaa"
                        password="bbbbbbbb"
                        onsConfiguration="nodes=ccccccccc.vegvesen.no:6200,dddddddddd.vegvesen.no:6200"
                        fastConnectionFailoverEnabled="true"
                        connectionProperties=";oracle.net.ns.SQLnetDef.TCP_CONNTIMEOUT_STR=3000;"
                        url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=eeeeeeee.vegvesen.no)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ffffffff.vegvesen.no)))"
                        connectionPoolName="trafikkna"
                        validateConnectionOnBorrow="true"
                        sqlForValidateConnection="select 1 from DUAL"
                />

Attachments :

  1. drivers.zip
simboss commented 6 years ago

Comment added by agent Support in Freshdesk ticket id 16306:

Hi Gabriel Jonsson,

I replicated the exception you get creating more than one JNDI resource with the same connectionPoolName, while using different names for different resources is working for me.
Could you check if this is also your issue?

Ticket: http://geosolutions.freshdesk.com/helpdesk/tickets/16306

 
==
Our support, Your Success! Visit http://www.geo-solutions.it/enterprise-support-services for more information.
==
Support Engineer

GeoSolutions S.A.S.
Via di Montramito 3/A
55054  Massarosa (LU)
Italy
fax:     +39 0584 1660272

simboss commented 6 years ago

Comment added by customer Gabriel Jonsson in Freshdesk ticket id 16306:

Hi!

Yes, we have multiple resources and one other also had 
connectionPoolName="trafikkna"

I changed to
connectionPoolName="trafikknageo" 
in the resource Geoserver uses.

Now the error seems to be gone, and the map layers are working.

simboss commented 6 years ago

Comment added by agent Support in Freshdesk ticket id 16306:

Hi Gabriel Jonsson,

Good, let me know if you have any other related issue or we can close this one.

Ticket: http://geosolutions.freshdesk.com/helpdesk/tickets/16306

 
==
Our support, Your Success! Visit http://www.geo-solutions.it/enterprise-support-services for more information.
==
Support Engineer

GeoSolutions S.A.S.
Via di Montramito 3/A
55054  Massarosa (LU)
Italy
fax:     +39 0584 1660272

simboss commented 6 years ago

Comment added by customer Gabriel Jonsson in Freshdesk ticket id 16306:

I monitor the logs but I haven't seen any other issue so far. 

Just a questions. Is ojdbc8, the java 1.8 driver supported and tested nowadays in Geoserver as much as the ojdbc7 driver? 
I did not find official info what Oracle drivers are supported with Geoserver. Only a recent forum post where a user believed ojdbc8 is too new to be supported. 

simboss commented 6 years ago

Comment added by agent Marketing Agent in Freshdesk ticket id 16306:

Dear Gabriel,
I believe most of our clients are still NOT on Oracle 12 so are our test machines, therefore we don't have any evidence to show in favour or against this version of the driver.

Regards,

==
Our support, Your Success! Visit http://www.geo-solutions.it/enterprise-support-services for more information.
==


GeoSolutions S.A.S.
Via di Montramito 3/A
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax:     +39 0584 1660272



-------------------------------------------------------

simboss commented 6 years ago

Comment added by agent Marketing Agent in Freshdesk ticket id 16306:

Hi Gabriel Jonsson,

I will resolve the ticket for now. It will automatically close in 1W if there are no other exchanges.

Regards,

==
Our support, Your Success! Visit http://www.geo-solutions.it/enterprise-support-services for more information.
==


GeoSolutions S.A.S.
Via di Montramito 3/A
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax:     +39 0584 1660272



-------------------------------------------------------