Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Open connection properties file.
  2. Enter the connection properties in the following format.

    UI Text Boxcode
    connection.<name>.sql.driver=<database_driver>

    
    connection.<name>.sql.minEvictableIdleTimeMillis=1800000

    
    connection.<name>.sql.numTestsPerEvictionRun=3

    
    connection.<name>.sql.password=<encoded_password>

    
    connection.<name>.sql.poolInitialSize=0

    
    connection.<name>.sql.poolMaxIdle=8

    
    connection.<name>.sql.poolMaxTotal=8

    
    connection.<name>.sql.poolMaxWait=-1

    
    connection.<name>.sql.poolMinIdle=0

    
    connection.<name>.sql.testOnBorrow=true

    
    connection.<name>.sql.testOnReturn=false

    
    connection.<name>.sql.testWhileIdle=false

    
    connection.<name>.sql.timeBetweenEvictionRunsMillis=-1

    
    connection.<name>.sql.type=<connection_type>

    
    connection.<name>.sql.url=<database_url>

    
    connection.<name>.sql.username=<username>

    
    connection.<name>.sql.validationQuery=

    
    connection.<name>.sql.validationQueryTimeout=-1
  3. Save the file

    .

Connection Pool Parameters

...