Problems with AWS Redshift Driver

We use AWS Redshift

Drivers to query our Redshift

database. Please search before the maven dependency for the driver we are using in our project.

com.amazon.redshift
redshift-jdbc41
1.2.1.1001

      

We make a connection pool of objects using

org.apache.tomcat.jdbc.pool.DataSource object.

We noticed that even when we close connections, the connection appears to be active. Temporary tables that should be dropped are not lost. When different threads retrieve different connection objects from the pool, they appear to behave as if they were the same connections. Transactions started using these two different connection objects appear to continue together, resulting in Serializable isolation interrupt exceptions. We are constantly faced with such exceptions. I also wanted to know if Redshift supports automatic rollback if any request fails in a transaction, I can't see that.

Is there any known issue in AWS Redshift Drivers

or has anyone else had a problem with a similar issue

+3


source to share





All Articles