Scrited SQL connector, not close connections

[letroncoso]

Hi all
We are developing a scrited SQL connector, we start from the “scripted-sql-with-mysql” sample.
At the moment we are only interested in using the Schema, Test and Search scripts, which we adapt to communicate with an Oracle.

The connector configuration is as follows

"poolConfigOption" : {
	"maxObjects" : 10,
	"maxIdle" : 10,
	"maxWait" : 150000,
	"minEvictableIdleTimeMillis" : 120000,
	"minIdle" : 1
},
"configurationProperties" : {
	"username" : "idmtest",
	"password" : "**********",
	"driverClassName" : "oracle.jdbc.driver.OracleDriver",
	"url" : "jdbc:oracle:thin:@<ip>:<post>/xe",
	"autoCommit" : true,
	"validationQuery" : "SELECT 1 FROM DUAL",
	"validationInterval" : "30000",
	"testOnBorrow" : true,
	"reloadScriptOnExecution" : false,
	"testScriptFileName" : "0_TestScript.groovy",
	"searchScriptFileName" : "0_SearchScript.groovy",
	"scriptRoots" : [
		"&{idm.instance.dir}/tools"
	],
	"schemaScriptFileName" : "0_SchemaScript.groovy"
},

The value of the “validationInterval” was modified, which went from 2000 to 300000

In the database we are executing the sentence
SELECT username, count (1) From V $ session GROUP BY username

Wen turn on the project, we see that 10 connections are generated
Then when we see the data of the DB, from IDM, we see that the number of connections increases, we have had more than 200 connections and in our laboratory the oracle gives us the error that it has no more connections available

The error observed in the log is the following

SEVERE: Unable to create initial connections of pool.
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12516, TNS:listener could not find available handler with matching protocol stack

As we could do to close the connections, we tried to place them in the scripts without any success.

• This topic was modified 1 year ago by letroncoso.

[Author]

Posts