I am making a project where every jsp requires a connection to a database. Now, at the moment I am creating new connection everytime jsp is loaded. Is this the only way except connection pooling? I want that only one instance of connection is made and it is only passed to all jsp's for the particular session. Means i do not have to create a new coonection in every jsp. thanks in advance for help
what have you got against connection pooling? creating a connection per session to pass around to all the jsps in the session is resource wasteful, since the session holds on to the connection even when the latest (or last) html page has been delivered.