Thanks for your reply.
i have used a separate class file for database connection establishment.
here is the connectionpool file.
here is the query execute method
here is the query calling method
i got this error
java.sql.SQLException: Invalid state, the Connection object is closed.
please tell me what i did error coding in the above coding.
please help if any one know the answer.
Thanks and regads,