Programming Tutorials Browser Tutorials Articles Struts Tutorials Hibernate Tutorials

  Tutorial: Primrose - Free J2EE Database Connection Pooling Software

Primrose Primrose is a database connection pool, written in Java. Current containers support are Tomcat 4 & 5, and JBoss 3. There is also now a standalone version of primrose that can be used for applications not running inside a container.

Tutorial Details:

Features include :
Optional notification of crisis events.
Highly adaptable configuration file - see the config file for all the options.
SQL statement monitoring for connections, including what connection is called from what code and the precise SQL it is performing, including '?' parameters.
Starting/Stopping pools without application restarts
Adding / removing connections on the fly
Automated retrieval of duff connections
A web interface for pool management
Queueing of connection requests during heavy load.
Statistics for types of SQL statements executed and executiion times, to provide a complete overview of webapp-db interaction
Multiple pool instances, managed through one interface.
No more forgotton unclosed Statement and ResultSet objects - primrose closes them for you.
Easy deployment and integration with your webapp container.
No need to rewrite your client code to utilise the pool.
Enhances debug of poor performing client code - if a connection hangs, the precise connection, and the exact SQL it is performing is logged, including what client Java code called it.


 

Read Tutorial at: Click here to view the tutorial

Rate Tutorial:
Primrose - Free J2EE Database Connection Pooling Software

View Tutorial:
Primrose - Free J2EE Database Connection Pooling Software

Related Tutorials:

Improve the robustness and performance of your ObjectPool - JavaWorld - August 1998
Improve the robustness and performance of your ObjectPool - JavaWorld - August 1998
 
Which JSP book serves up the best lesson?
Which JSP bookAs for Web servers/databases, just mentioning a server in the book is not sufficient to be listed here.
 
Frameworks save the day - JavaWorld September 2000
Frameworks save the day - JavaWorld September 2000
 
Develop n-tier applications using J2EE - JavaWorld December 2000
Develop n-tier applications using J2EE - JavaWorld December 2000
 
Get disconnected with CachedRowSet , This allows for ResultSet s to be serialized, sent to remote clients, updated
The new J2EE RowSet implementation provides updateable disconnected ResultSets in your JSPs
 
The magic of Merlin - JavaWorld March 2001
The magic of Merlin - JavaWorld March 2001
 
Connect the enterprise with the JCA, Part 1
Connect the enterprise with the JCA, Part 1
 
Build database-powered mobile applications on the Java platform
Build database-powered mobile applications on the Java platform
 
Create your own type 3 JDBC driver, Part 1
Create your own type 3 JDBC driver, Part 1
 
Design patterns make for better J2EE apps
Design patterns make for better J2EE apps
 
Java Tip 143: Utilize the Database Schema Browser
Java Tip 143: Utilize the Database Schema Browser
 
JView 2004 - J2EE Performance Management Software - Version 1.4
JView 2004 Enterprise Edition available now! JView 2004 is the leading J2EE Production Performance Monitor and Java Performance Tuning solution, providing precise real-time performance metrics to assist you in ensuring your performance requirements a
 
SQL Database Access with DBTags
SQL Database Access with DBTags In a J2SE or J2EE application, Java Database Connectivity (JDBC) can be used to create a connection with a SQL database, create database tables, retrieve result sets, and update the database. To use a database from a Jav
 
Apache Geronimo
Apache Geronimo Welcome to Apache Geronimo, the J2EE server project of the Apache Software Foundation. Please help us make this a world class, certified J2EE container!
 
Servlet and JSP performance tuning
Servlet and JSP performance tuning This article describes performance-tuning techniques (PTT) for developing high performance and scalable JSP (JavaServer Pages) pages and servlets. That means building applications that are reasonably and consistently fa
 
A first look at Apache Geronimo
Start developing and deploying J2EE apps on the first open source J2EE server. When released, Geronimo will be the first J2EE-certified open source server. This article will give you the basics you need for developing and deploying J2EE applications on Ge
 
Pool resources using Apache's Commons Pool Framework
Resource pooling is not new and is being widely used to conserve and optimize the usage of resources like threads, sockets, and database connections. Web server implementations routinely use thread pool implementations for performance and scalability reas
 
Developing Distributed application using Enterprise Java Beans, J2EE Architecture, EJB Tutorial, WebLogic Tutorial.
Developing Distributed application using Enterprise Java Beans, J2EE Architecture, EJB Tutorial, WebLogic Tutorial. Distributed Architecture Two-tier application: In the past two-tier applications were used. Two-tier applications are also know as
 
Introduction to the JSP Java Server Pages
Introduction to the JSP Java Server Pages Welcome to JSP Section Introduction To JSP Java Server Pages or JSP for short is Sun's solution for developing dynamic web sites. JSP provide excellent server side scripting support for creating database
 
JSP FUNDAMENTALS
JSP FUNDAMENTALS JSP FUNDAMENTALS By: Hrishikesh Deshpande Introduction : JSP termed as Java Server Pages is a technology introduced by Sun Microsystems Inc. to develop the web application in more efficient way than Servlets. It has got many
 
Site navigation
 

 

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.

Copyright © 2006. All rights reserved.