posted 14 years ago
I am writing a 'service file'. In this i am using more number of 'sql connections'. As of now i have declared Connection, PrepareStatement, ResultSet in Class level. So i am using these in my code again and again. ie. Every time i am creating new connection and closing it again.
Yesterday my friend said me to use a single connection through out the code. Like with out closing the connection.
Please help me.. Which better way(When i am using more SQL statements)
Regards,
A.A.Anbarasu