How to set an Oracle Datasource custom property with type java.util.properties

[Gustavo Río Briones]

We have a J2EE application on a payara 5.2020 server that executes a long running query (PL/SQL that executes for a couple of hours).

We're having some trouble trying to define network/timeout properties at datasource level.

According to Oracle reference, the OracleDataSource implementors can receive the connection properties as a java.util.Properties object.

Table 8-2 Oracle Extended Data Source Properties

Name: connectionProperties

Type: java.util.Properties

Description: Specifies the connection properties.

https://docs.oracle.com/en/database/oracle/oracle-database/18/jjdbc/data-sources-and-URLs.html

Is there a way in the payara Admin console, in the jdbc pool advanced properties, to set a multivaluated property so it would be converted to a java.util.properties and set to the datasource?

Thank you in advance.

[Ondro Mihályi]

Hi, this isn't a very well documented feature but fortunately I needed this for a customer recently and I found out how to do it. You need to put the value in brackets and separate the values with commas, e.g. you can set the value of the "ConnectionCacheProperties" to "(MaxStatementsLimit=100,MaxLimit=10)".

I hope that helps,

Ondro

ut 15. 6. 2021 o 11:18 Gustavo Río Briones <gusr...@gmail.com> napísal(a):

--
You received this message because you are subscribed to the Google Groups "Payara Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to payara-forum...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/payara-forum/c0398b50-c270-4cc2-bfec-87d55f977c96n%40googlegroups.com.

[Gustavo Río Briones]

It worked!

Thank you Ondro.

Just it cases anyone gets here looking for how to fix timeout problems in a long rutting SQL query on Oracle I leave here the full case:

https://stackoverflow.com/questions/67972657/statement-setquerytimeout-doesnt-work-on-oracle-18c-jdbc-driver/67975882#67975882