Databases
StackOverflow2013
Postsdbo
POtoo many connection error in tomcat 7 with Mysql
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POtoo many connection error in tomcat 7 with Mysql
    primarykey
    data
    text
    <p>I'm getting the below "too many connection " error, even though, I'm sure I have closed connection in my code.</p> <p>I'm using tomcat 7 with MySQL, i didn't configure connection pooling, unless tomcat using connection pooling by default. </p> <pre><code>com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Data source rejected establishment of connection, message from server: "Too many connections" com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Data source rejected establishment of connection, message from server: "Too many connections" at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:525) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1128) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2336) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2369) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153) at com.mysql.jdbc.ConnectionImpl.&lt;init&gt;(ConnectionImpl.java:792) at com.mysql.jdbc.JDBC4Connection.&lt;init&gt;(JDBC4Connection.java:47) at sun.reflect.GeneratedConstructorAccessor42.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:525) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) at java.sql.DriverManager.getConnection(DriverManager.java:579) at java.sql.DriverManager.getConnection(DriverManager.java:243) </code></pre> <p>in my code I close the connection like this.</p> <pre><code> private void insertIntoDB() { /** * THIS JUST a WORKAROUND ... REMOVE later */ if(token==null || token.equals("")) { return; } //System.out.println("Inserting values in Mysql database table!"); Connection connect = null; PreparedStatement preparedStatement = null; try{ // This will load the MySQL driver, each DB has its own driver Class.forName("com.mysql.jdbc.Driver"); // Setup the connection with the DB connect = DriverManager .getConnection("jdbc:mysql://127.0.0.1:3306/dbname?" + "user=dbuser&amp;password=xxxxxxxx"); preparedStatement = connect .prepareStatement("INSERT INTO location_V2_android (udid, token, lat , lng,update_time) VALUES " +" (?, ?, ?, ?, NOW() )" ); preparedStatement.setString(1, udid); preparedStatement.setString(2, token); preparedStatement.setDouble(3,lat); preparedStatement.setDouble(4, lng); preparedStatement.executeUpdate(); //preparedStatement.close(); } catch (SQLException s) { System.out.println("SQL statement is not executed! UpdateLocations V2 updateUserLocationinDB"+ s.toString()); } catch (Exception e) { e.printStackTrace(); } finally { // Close database resources try { if (preparedStatement != null) { preparedStatement.close(); } } catch (SQLException e) { System.out.println("Cleanup failed to close Statement."); } try { if (connect != null) { connect.close(); } } catch (SQLException e) { System.out.println("Cleanup failed to close Connection."); } } } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USuser836026
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COWhy don't you share the connection object among (all, not just your insert into location_V2_android) Statements (and close it once you don't need the database anymore)? That would save a lot of time (establishing the connection would be neseccary once instead of each time you want to insert something).
      singulars
      1. POtoo many connection error in tomcat 7 with Mysql
      1. USSebastian van Wickern
    2. COhow many parallel request are you expecting ?
      singulars
      1. POtoo many connection error in tomcat 7 with Mysql
      1. USBhavik Shah
    3. COFirst of all, post the **complete** stacktrace as well as the code where the error is occurring. Your stacktrace doesn't match up to your code at the moment.
      singulars
      1. POtoo many connection error in tomcat 7 with Mysql
      1. USBuhake Sindi
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload