you should make your bean persistent (change the scope to application) and then have it create 'n' connections when first called. you can then reuse connections. There are a number of implementations available for connection pooling. You may want to reuse them instead of re-creating the process.
Prashanth --- phani <[EMAIL PROTECTED]> wrote: > Hi, > > I am using a bean to get connection for a db from my > jsp page. But the problem is for each and every > request the page fetches a connection from the > bean. This becomes a over head to the system. > What i want to do is i want to open n no (say 50 ) > of connection when the server is started and any > request must be routed through these connection > only. > > How to do this? > > Thanks in advance. > > phani > __________________________________________________ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>