TOMCAT5 and PostgreSQL Configuration development JSP

As for the installation of knowledge, here is not much to say, to pay attention to the two points is:

1. Install Tomcat (Jakarta-tomcat-5.0.28.exe)

2. Installation of PostgreSQL (Postgresql-8.0-beta1-20040809.msi) (7.0 and 8.0 versions are available)

Directly installed to the C or D disk can be, at the same time to set user name and password such as: admin 123456, in the future access to the database will be used, the other PostgreSQL in the installation directory of the disk system format must be NTFS, otherwise can not fit.

Configuration database driver: (Jdk14 refers to your JDK installation directory)

Put the PostgreSQL data driver in the jdk14/jre/lib/ext/: Locate the PG74.214.JDBC3 file in the installed database (such as: D:\POSTGRESQL\JDBC), and put it into the Jdk14/jre/lib/ext /Medium

I. Establishment of virtual directories (TMP1) and database join pools (JDBC/PG1)

1, the establishment of directory D:\ TMP1 and D:\ Tmp1\web-inf

2, using TOMCAT5 Web management interface to establish a global description of the JDBC connection

Enter the administrator username and password required for the original installation and login to the admin interface. Click on the menu on the left side of the data sources, click on the right to create a new source.

Enter the Jndi name, JDBC driver class name, database URL, and PG8 username and password