Connection Pooling for MS SQL Server and Sun One App/Web Server
Posted on 2006-11-01
Hi Experts. I am new to JAVA and I have been gien the responsibility to write and application using JDBC connection pooling with MS SQlServer Express. and SUN ONE Web server From my research, I use the SQLServerXADatasource to
register the datasource and get the connections
Somewhere this does not seem to work.
Please assist me is determining what other classes I need to use to get the connection pool to work.
Here is what I have done
I created the Connection Pool and JNDI resource in Sun One server
Then I do a lookup and bind in my java code with SQLServerXADatasource
Then I get a connection from the datasource (SQLServerXAdatasource.getConnection)
According to the documentation I have found thius far, that is all I need to do because SQlServerXADatasource implements and extends the other classes that I need
However, when I monitor the database, I don't see the connections and I still get a lot of outofmemory exceptions from the web server when I run my application under a high load.
Plase help me shed on light in this matter