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
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either.
In this article, I will show you how to enable the custom 40…
Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts.
Introduce Scanner class:
Viewers will learn about basic arrays, how to declare them, and how to use them.
Introduction and definition:
Declare an array and cover the syntax of declaring them:
Initialize every index in the created array:
Example/Features of a basic arr…