jdbc连接报错超出准备语句的最大数量，这是数据库超过最大连接数了么？

Question

com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [608]: exceed maximum number of prepared statements: the number of prepared statements per connection cannot exceed the max statements
at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:357)
at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateDatabaseException(SQLExceptionSapDB.java:197)
at com.sap.db.jdbc.packet.ReplyPacket.buildExceptionChain(ReplyPacket.java:110)
at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:934)
at com.sap.db.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSapDB.java:1862)
at com.sap.db.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:1007)
at com.sap.db.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.java:255)
at com.sap.db.jdbc.CallableStatementSapDB.constructor(CallableStatementSapDB.java:207)
at com.sap.db.jdbc.CallableStatementSapDB.(CallableStatementSapDB.java:151)
at com.sap.db.jdbc.CallableStatementSapDBFinalize.(CallableStatementSapDBFinalize.java:16)
at com.sap.db.jdbc.ConnectionSapDB._prepareStatement(ConnectionSapDB.java:1601)
at com.sap.db.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:188)
at com.sap.db.jdbc.trace.Connection.prepareStatement(Connection.java:421)

Answer 1

并不是，超出的是statement而不是connection，超出数据库最大连接数的情况下先死的是数据库服务器，会出现超多等待超时。估计是你某个提交statement的循环没控制好，在上一个statement没有关闭的情况下就创建了新的statement。