Прикрутил пул.
на всякий решил написать. Глядишь кто еще решит помучиться с томкатом5
Поставил:
jdk1.5.0
jre1.5.0
jakarta-tomcat-5.5.7
Tomcat_5_5\conf\server.xml:
1.
<Host name="localhost" debug="0" appBase="P:\TS" unpackWARs="true">
Tomcat_5_5\conf\Catalina\localhost\kop1.xml:
(Потому как: conf/server.xml file cannot be reloaded without restarting Tomcat. Please note that for tomcat 5, unlike tomcat 4.x, it is NOT recommended to place <Context> elements directly in the server.xml file.)
1.
2.
3.
4.
5.
6.
<Context path="/kop1" docBase="KOP1" debug="9" reloadable="true">
<Resource name="DB2DB"
auth="Container"
type="javax.sql.DataSource"
factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
Tomcat 5.5.4 uses "org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
username="user"
password="name"
driverClassName="COM.ibm.db2.jdbc.app.DB2Driver"
url="jdbc:db2:XXXXXX"
maxWait="-1"
removeAbandoned="true"
removeAbandonedTimeout="60"
logAbandoned="true"/>
</Context>
KOP1\WEB-INF\web.xml:
1.
2.
3.
4.
5.
6.
<resource-ref>
<description>DB Connection</description>
<res-ref-name>DB2DB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
Страничка:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
<%@ page contentType="text/html; charset=windows-1251" language="java" import ="javax.naming.Context,
javax.naming.InitialContext,
javax.sql.DataSource,
java.sql.Connection" %>
<html>
<head>
<title> </title>
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<body >
<%
Connection conn = null ;
try {
Context ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup("java:comp/env/DB2DB");
if (ds != null ) conn = ds.getConnection();
%>
Ура
<%
}
finally
{
conn.close();
}
%>
</body>
</html>
