Tagged: connections, scripted, SQL
This topic has 0 replies, 1 voice, and was last updated 3 months, 3 weeks ago by letroncoso.
-
AuthorPosts
-
October 7, 2020 at 5:41 pm #28320
letroncoso
ParticipantHi 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 availableThe 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 3 months, 3 weeks ago by
letroncoso.
-
This topic was modified 3 months, 3 weeks ago by
-
AuthorPosts
You must be logged in to reply to this topic.