java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@dafa2c
is still active. Only one streaming result set may be open and in use per-conne
ction. Ensure that you have called .close() on any active result sets before at
tempting more queries.
at com.mysql.jdbc.MysqlIO.checkForOutstandingStreamingData(MysqlIO.java:
1805)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:835)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:956)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:928)
at com.mysql.jdbc.Connection.execSQL(Connection.java:1871)
at com.mysql.jdbc.Connection.execSQL(Connection.java:1805)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1143)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:310)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:324)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2
92)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
is still active. Only one streaming result set may be open and in use per-conne
ction. Ensure that you have called .close() on any active result sets before at
tempting more queries.
at com.mysql.jdbc.MysqlIO.checkForOutstandingStreamingData(MysqlIO.java:
1805)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:835)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:956)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:928)
at com.mysql.jdbc.Connection.execSQL(Connection.java:1871)
at com.mysql.jdbc.Connection.execSQL(Connection.java:1805)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1143)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:310)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:324)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2
92)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
请教如何解决这个问题,谢谢!
否则你的2个用户将拿到同一个连接!