|
[x]
Posted via EE Mobile
|
|
| Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again. |
|
|
|
|
Asked by Sachin_Ajmani in MySQL Server, J2EE, Databases Miscellaneous
hi Experts,
I m working on a project in which clients inserting their data in database. i m using MySql.
all going well if clients regularly insert their data in database. but when client want to insert their old data then out of memory error comes. I goggled and get that this error coming because client want to insert 1000 or more rows continuously and every time they insert their row then new connection created. All working is in thread. So if only 3 Client comes and want to insert their data approx 4000 rows or more depends some conditions then 4000 new connection created between client and mysql.. and then out of memory error comes..
how can i remove this problem and suggest me how can i create only one connection and use it for all clients. or you can say i want to create only one connection and use it in my whole project where data need to insert or select or delete or update without creating new connection.
20091111-EE-VQP-92 - Hierarchy / EE_QW_3_20080625
