Connection already closed (oracle 12c only)

Asked May 07 '16 at 17:29

Active May 08 '16 at 09:54

Viewed 217 times

We have a Spring Jdbc based project. It runs perfectly fine with Oracle 11g jdbc driver. However, when we recently switches to Oracle 12c, we are constantly seeing the "connection is already closed" exception.

We are wondering what could be causing this issue. We have already configured the "select 1 from dual" as validation SQL and not sure what else could be done.

Is there any analysis tool to see what might be causing this kind of error?

BTW We are using UCP connection pooling.

edited May 08 '16 at 09:54

Mark Rotteveel

100,966
191
140
197

asked May 07 '16 at 17:29

jmao

Have you configured the datasource to test on borrow? `spring.datasource.test-on-borrow=true` http://stackoverflow.com/a/30455408/1199132 – Aritz May 07 '16 at 18:10
yes we already have it configured to true. – jmao May 09 '16 at 13:35
Did you find any solution to this problem? – mettok Feb 20 '18 at 10:40

Connection already closed (oracle 12c only)

0 Answers0