hai friends,
i have a application where i have to add,delete,edit. i have used hibernates and created seperate methods for each operation. after adding some 80-90 values it is showing following exception.
Data source rejected establishment of connection, message from server: "Too many connections"
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:649)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1786)
at com.mysql.jdbc.Connection.<init>(Connection.java:450)
at com.mysql.jdbc.NonRegisteringDriver.connect(at java.lang.Thread.run(Unknown Source)
16:53:12,687 INFO DriverManagerConnectionProvider:147 - cleaning up connection pool: jdbc:mysql://localhost/test
16:53:12,687 WARN JDBCExceptionReporter:57 - SQL Error: 1040, SQLState: 08004
16:53:12,687 ERROR JDBCExceptionReporter:58 - Data source rejected establishment of connection, message from server: "Too many connections"
i think too many connection are created. so i wanted to know how to use a single connection. Should i use singleton pattern while creating SessionFactory object ? and also i need to know when exactly connection gets created. ie
1)while creating SessionFactory object
2)or while creating Session object