MicroDeveloper, Inc. - Professional Computing Services

Featured How-To Documents

These are how-to type documents aimed at providing step by step instructions for specific topics. As we resolve some often thorny issues, occasionally we may draw up a document that details how to solve a particular problem or how to avoid them. As the subject material ages or when newer versions make them obsolete, the whitepapers may be removed.

How to Setup Global JNDI Mapping
for Oracle JDBC Connection Pooling with Tomcat This document was originally created to outline the implementation of JNDI for Oracle connections. After working with both 5.0 and 5.5 configurations extensively, and with JDK 1.4.2 versus 1.5, I have come to realize that there are really two ways of implementing the global database JNDI configuration. The only difference I found was that the 5.0.x installation did not always work without a modification to the context web.xml file (Step 3). In 5.5 this was not necessary.

How to Setup JSTL & JNDI
for MySQL 4.x JDBC Connection Pooling
with Tomcat 5.0 and 5.5 This document outlines the step necessary to setup JSTL (JSP Tag Libraries) & JNDI resources on Tomcat for accessing MySQL databases, versions 4.0 through 4.1. This paper uses JSTL merely for convienience in the examples; however it proved to be the trickier aspect in setup. If you are running a relatively current JDK you should be fine. This setup was tested under OS X, Windows using JDK 1.4.2_05, Tomcat 5.0.28, and Tomcat 5.5.7.

Using The SQLDataSet ClassThis white paper clarifies how to properly utilize the SQLDataSet class. The primary reason for this white paper is to address an issue with Oracle databases whereby certain constructs may cause Oracle to throw an ORA-01000: maximum open cursors exceeded error under highly repetitive circumstances. This is a known issue when using the Oracle driver and also when using the Sun Java SQL implementation.

White Papers

Related Files

Associated Sites

Featured How-To Documents