Hello Doug
1- My ROOt.xml doesn't have any error.That problem caused by wrong copy and paste.
2- I changed the order of Parameters in Resource tag but wasn't useful.
3- Look, I don't see any error message.When I check the number of connection in
Mysqladmin, in 4.1.18 the number of connection doesn't rise quickliy but in 5.0.19
for each open page we have a distinct connection.
4- I think this problem caused by Common-pool-1.1 and Common-dbcp-1.1 jar
files,because in 4.1.30 that have the same jar files you also see that problem.
5- A test,if you copy thoes jar files in 4.1.18 and rename them, connection pooling
doesn't work such as 4.1.30 and 5.0.9 without any error message.
6 - And another test, my java file is like this :
package pooling;
import javax.sql.*;
import javax.naming.*;
import java.sql.*;
public class webPooling
{
Connection mySqlConnection = null;
public webPooling() //Class constructor
{
}
public void init() //Connection Creator
{
try
{
Context ctx = new InitialContext();
if(ctx == null )
throw new Exception("ERROR IN CONTEXT INITIALIZATION!!?");
DataSource mySqlDatasource = (DataSource)ctx.lookup
("java:comp/env/jdbc/UKwebpooling");
if(mySqlDatasource == null)
throw new Exception ("ERROR IN DATASOURCE CREATING");
else
mySqlConnection = mySqlDatasource.getConnection();
}//try
catch(Exception e)
{
e.printStackTrace();
}
}
public Connection getConnection()
{
return mySqlConnection;
}
}
if you add this code to the end of this java file :
public void closeConnection()
{
try
{
if(!mySqlConnection.isClosed())
mySqlConnection.close();
}
catch(Exception ex)
{
System.out.println("ERROR IN CLOSING THE CONNECTION (POOL)");
ex.printStackTrace();
}
}
and call this method in your Jsp file, in 4.1.18 you don't see any error message and
Connection pooling works so good, but in 5.0.19 you see this error message:
Connection is already closed.
.....
and so many Exceptions.....
8- If you create a Statement in java file, that error message doesn't appear.
What is your idea?
With thanks.
masood.
---------------------------------
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital prints for 25¢
