Using TOMCAT5 and PostgreSQL configuration to develop JSP detailed

js|sql| details as to the installation of knowledge, here not 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


Click "SAVE" to display the data source that has been set successfully


Click on the "Commit Changes" button at the top of the page to submit

A resource description is actually added to the TOMCAT5 installation directory Conf/server.xml, and other users or directories can be used in a resourcelink manner


3. Create a virtual directory description file in the TOMCAT5 installation directory Conf\catalina\localhost tmp1.xml

4. Establish Web.xml documents in D:\tmp1\WEB-INF


　　 Second, PostgreSQL7.4 data backup and recovery

1, Backup

Execute the following command to output the entire contents of the test library to the file Testdata.txt in Postgres user-identity backup

Pg_dump-f testdata.txt-u postgres Test

2. Recovery

If the test database does not exist, you need to first build the library

Execute the following command to enter the contents of the file Testdata.txt into the test library as a Postgres user backup

Psql-f testdata.txt-u postgres Test

　　 Third, the PostgreSQL7.4 database after the illegal shutdown, unable to start the problem

Delete the Postmaster.pid file in the directory where the data resides