aws / aws-secretsmanager-jdbc

The AWS Secrets Manager JDBC Library enables Java developers to easily connect to SQL databases using secrets stored in AWS Secrets Manager.
Apache License 2.0
159 stars 77 forks source link

TomcatConnection pool connection go stale after some time #61

Open antworkscomp opened 2 years ago

antworkscomp commented 2 years ago

Resource name="jdbc/eampleDB" auth="Container" type="javax.sql.DataSource" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" maxActive="100" maxIdle="30" maxWait="1000" username="awssecret"

driverClassName="com.amazonaws.secretsmanager.sql.AWSSecretsManagerMySQLDriver"
url="jdbc-secretsmanager:mysql://hostname:3306/example?useSSL=false"

connection works for a time and after a some time connection go stale , connection already closed exception

rohitnitk commented 1 year ago

tomcat does even work with context ?? How do you do that with secret manager and aws-secretmanager-jdbc..

@antworkscomp