Tomcat5 + MSSQL Server 2000 Database Connection Pool Configuration Tour

Tomcat believes that everyone is already familiar. As a free and powerful Java Web Server, I got a lot of Java enthusiasts, the latest version of Tomcat5 support servlet2.4 and jsp2.0, today I will use Tomcat5 and MS SQLServer 000 Start the database connection pool configuration together. Need to prepare 1, JDK I use version 1.4.012, Tomcat 5 I use 5.0.16 version download address: http://jakarta.apache.org/site/binindex.cgi3, mssql server 2000 database 4, MSSQL Server 2000 official JDBC Driver, you can download Microsoft's official website free download

After installation of the software installed, I will enter the configuration.

First, find the JDBC installation directory, put the msbase.jar and mssqlser.jar below the lib directory, Msutil.jar three files Copy to $ catalina_home / common / lib / ($ CATALINA_HOME representative is your Tomcat5 installation directory)

Second, use the text editor, I am using editplus to open the $ catalina_home / conf / server.xml file using EditPlus, find the following, paste the following code into the file

factory org.apache.commons.dbcp.basicDataSourceFactory

<-!.. Maximum number of dB connections in pool Make sure you configure your mysqld max_connections large enough to handle all of your db connections Set to 0 for no limit -.> maxActive 100

maxidle 30 maxWait 10000

UserName sa password < Value>

driverclassname com.microsoft.jdbc.sqlserver.sqlserverdriver

URL jdbc: Microsoft: SQLServer: // localhost: 1433; DatabaseName = Northwind

Note: The password of the SA of my local database is empty, the database is Northwind, my directory name dbtest, his directory is d: / Rautinee Work / DB /

Open the web.xml file below dbtest, replace the original content with the following code

MSSQL Server Test App DB Connection JDBC / TESTDB javax.sql.datasource container OK, the configuration is complete, the following work is to write two files to test, whether the connection is successful.

Here I use http://jakarta.apache.org above example

The first is the bean file

Package foo;

Import javax.naming. *; import javax.sql. *; import java.sql. *;

Public class dbtest {

String foo = "not connection"; int BAR = -1; public void init () {try {context ctx = new initialContext (); if (ctx == null) Throw new Exception ("Boom - no context");

DataSource DS = (Datasource) CTX.lookup ("Java: Comp / Env / JDBC / TESTDB");

IF (ds! = null) {connection conn = ds.getConnection (); if (conn! = null) {foo = "got connection" conn.tostring (); statement stmt = conn.createstatement (); resultset RST = Stmt.executeQuery ("Select * from Orders"); if (Rst.next ()) {foo = RST.GetString ("Customerid"); bar = rst.getint ("ORDERID");} conn.close (); }}} Catch (Exception E) {E.PrintStackTrace ();}}

Public string getfoo () {return foo;} public int getbar () {return bar;}}

Then INDEX.JSP file