Scrited SQL connector, not close connections

This topic has 0 replies, 1 voice, and was last updated 2 weeks, 3 days ago by letroncoso.

  • Author
    Posts
  • #28320
     letroncoso
    Participant

    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 2 weeks, 3 days ago by letroncoso.
Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.

©2020 ForgeRock - we provide an identity and access platform to secure every online relationship for the enterprise market, educational sector and even entire countries. Click to view our privacy policy and terms of use.

Log in with your credentials

Forgot your details?