你是通过启动tomcat后访问http://localhost:8080/admin的方式配置的吗?
最好是这样配置,进去后在图形界面里配,不用手动去修改配置文件.
最好是这样配置,进去后在图形界面里配,不用手动去修改配置文件.
解决方案 »
- 如何保存反射对象 obj
- 如何在url中引用变量值向action传递参数
- SSh整合的一些疑问,望高手赐教
- How to define the type "ns1:DataHandler"?
- 各位帮忙.HIBERNATE深入欠出第一个例子我竟然搞不定....我发多点分
- 调用远程的EJB 需要那些步骤
- 关于webwork2 model驱动的问题
- 一个奇怪的问题?????????????????????????
- j2ee系统的硬件系统,软件系统该用什么?
- 为什么静态方法一定要使用静态方法。不懂希望高手指点 哪个讲得懂给40分~~~~~~~~~~~
- 安装Jbuilder时,出现了问题,大家帮帮忙!谢谢了!
- struts-config的message-resources问题(快疯掉了)
<?xml version='1.0' encoding='utf-8'?>
<Server>
<Listener className="org.apache.catalina.mbeans.ServerLifecycleListener"/>
<Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"/>
<GlobalNamingResources>
<Environment name="simpleValue" type="java.lang.Integer" value="30"/>
<Resource auth="Container" description="User database that can be updated and saved" name="UserDatabase" type="org.apache.catalina.UserDatabase"/>
<Resource name="jdbc/TestDB" type="javax.sql.DataSource"/>
<ResourceParams name="UserDatabase">
<parameter>
<name>factory</name>
<value>org.apache.catalina.users.MemoryUserDatabaseFactory</value>
</parameter>
<parameter>
<name>pathname</name>
<value>conf/tomcat-users.xml</value>
</parameter>
</ResourceParams>
<ResourceParams name="jdbc/TestDB">
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>4</value>
</parameter>
<parameter>
<name>password</name>
<value></value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/jspdb</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
<parameter>
<name>username</name>
<value>root</value>
</parameter>
</ResourceParams>
</GlobalNamingResources>
<Service name="Catalina">
<Connector acceptCount="100" connectionTimeout="20000" disableUploadTimeout="true" port="8080" redirectPort="8443" maxSpareThreads="75" maxThreads="150" minSpareThreads="25">
</Connector>
<Connector port="8009" protocol="AJP/1.3" protocolHandlerClassName="org.apache.jk.server.JkCoyoteHandler" redirectPort="8443">
</Connector>
<Engine defaultHost="localhost" name="Catalina">
<Host appBase="webapps" name="localhost">
<Logger className="org.apache.catalina.logger.FileLogger" prefix="localhost_log." suffix=".txt" timestamp="true"/>
</Host>
<Logger className="org.apache.catalina.logger.FileLogger" prefix="catalina_log." suffix=".txt" timestamp="true"/>
<Realm className="org.apache.catalina.realm.UserDatabaseRealm"/>
</Engine>
</Service>
</Server>
是不是要自己加上去
<%@ page contentType="text/html;charset=GBK"%>
<%@ page import= "java.sql.* "%>
<%@ page import= "javax.naming.* "%>
<%
try{
Context initCtx = new InitialContext();
Context ctx = (Context) initCtx.lookup("java:comp/env"); //获取连接池对象
Object obj = (Object) ctx.lookup("jdbc/TestDB"); javax.sql.DataSource ds = (javax.sql.DataSource)obj; Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
String sql = "select * from messages";
ResultSet rs = stmt.executeQuery(sql); if(rs.next()){
out.println(rs.getString(1)); } rs.close();
stmt.close();
conn.close();
}catch(Exception ex){
out.write("Error: " + ex.getMessage());
}
%>
<hr>
在tomcat5\webapps\ROOT\web-info、下的web.xml里加上了
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/TestDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
在Catalina/localhost/ROOT.xml里加上description="DB Connection" name="jdbc/TestDB" type="javax.sql.DataSource"/>
就可以了