数据库连接问题

2019独角兽企业重金招聘Python工程师标准>>>

问题异常：

Couldn't rollback jdbc connection. Io exception: Broken pipe java.sql.SQLException: Io exception: Br

问题原因及处理方式：

1. Network problem: That is the network between the database and application server causing the physical connection to be dropped after a period of time. It's probably due to a firewall running behind the network which is configured to kill db connections after a specified period of time. You may consider a workaround to maintain the connection alive all the time simply by re-configuring your application server. For Tomcat, you may try adding validationQuery="select 'validationQuery' from dual in the Tomcat datasource conf file (context.xml)

2. The connections to the database server are being reset and the client is not notified by the database driver. The problem in this case is that the Oracle driver is discovering that it's socket to the DBMS somehow (firewall again, maybe?) has been closed by the other end. You may consider setting your connection timeout (in the pool) shorter than the network/DB server timeout as a solution.

转载于:https://my.oschina.net/schuppe/blog/1791027