Hi Guys,
I am experiencing a db pooling issue. I use Jbss 2.4.4 with Tomcat 3.2.3. I use SQL Server 2000. I made connection in the EJB(bmp). It is working fine.
I can connection to database and retrive data. However, if I kill the process in the SQL Server, the Jboss can not reconnect to database unless I have to restart the Jboss.
Do you guys have the same problem before?
How to solve this kind of problem.
If you have any idea, please let me know
Thanks in advanced.
Eddy
PE: Here is my code
================================
InitialContext ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup("java:/SQLServerPool");
Connection conn = ds.getConnection();