Best Practice:  Reusing DataSources for JDBC Resources

Technote (FAQ)
Problem
Solution
Acquire, cache and reuse JDBC DataSources. Because of JNDI lookup, acquiring a JDBC DataSources is an expensive operation. Because JDBC DataSources are thread safe they can be cached and reused safely to achieve better performance.
Related information
Best Practice: Reusing DataSources for JDBC Resources

Cross Reference information
SegmentProductComponentPlatformVersionEdition
Software DevelopmentWebSphere Studio Application DeveloperJava developmentLinux, Windows4.0, 4.02, 4.03Edition Independent
Application ServersWebSphere Application Server EnterpriseApplicationDevelopment(WSADIE Runtime)Multi-Platform4.0, 4.0.1, 4.0.2, 4.0.3, 4.0.4, 4.0.5, 4.0.6, 4.0.7Edition Independent











Document Information

Product categories: Software, Application Servers, Distributed Application & Web Servers, WebSphere Application Server, Java 2 Connectivity (J2C)
Operating system(s): Multi-Platform
Software version: 3.0.2, 3.0.2.1, 3.0.2.2, 3.0.2.3, 3.0.2.4, 3.5, 4.0
Software edition: Edition Independent
Reference #: 1053987
IBM Group: Software Group
Modified date: 2003-12-09