另外,如果在tomcat-->Administration tool中设置,该如何作呢?
JNDI Name: ?
Data Source URL: ?
JDBC Driver Class: ?
User Name: root
Password:
Max. Active Connections: 20
Max. Idle Connections: 10
Max. Wait for Connection: 2
Validation Query: ?
JNDI Name: ?
Data Source URL: ?
JDBC Driver Class: ?
User Name: root
Password:
Max. Active Connections: 20
Max. Idle Connections: 10
Max. Wait for Connection: 2
Validation Query: ?
解决方案 »
- struts2 package 问题
- 解析一下这段代码是什么意思
- 分页的当前页号如何去传递
- eclipse远程调试的逻辑是什么?
- 散分了
- jsp中的setAttribute
- 各位大虾,问一问题,我使用apache的soap提供webservice接口,那么在请求方的服务器上是不是一定也要安装soap.jar还是只在响应webservice
- 那位前辈能说说jmx具体是干什么用的?可以用于我们开发的应用系统上吗?可用来干什么?谢谢
- 【求助】Java如何将kindeditor里的富文本导出到word书签
- 关于spring集成hibernate获取session轮询取值错误
- struts问题,问一下struts标签问题
- 为什么TOMCAT关不掉
debug="5" reloadable="true" crossContext="true"> <Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_DBTest_log." suffix=".txt"
timestamp="true"/> <Resource name="jdbc/TestDB"
auth="Container"
type="javax.sql.DataSource"/> <ResourceParams name="jdbc/TestDB">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter> <!-- 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.
-->
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter> <!-- Maximum number of idle dB connections to retain in pool.
Set to 0 for no limit.
-->
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter> <!-- Maximum time to wait for a dB connection to become available
in ms, in this example 10 seconds. An Exception is thrown if
this timeout is exceeded. Set to -1 to wait indefinitely.
-->
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter> <!-- MySQL dB username and password for dB connections -->
<parameter>
<name>username</name>
<value>javauser</value>
</parameter>
<parameter>
<name>password</name>
<value>javadude</value>
</parameter> <!-- Class name for mm.mysql JDBC driver -->
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter> <!-- The JDBC connection url for connecting to your MySQL dB.
The autoReconnect=true argument to the url makes sure that the
mm.mysql JDBC Driver will automatically reconnect if mysqld closed the
connection. mysqld by default closes idle connections after 8 hours.
-->
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/javatest?autoReconnect=true</value>
</parameter>
</ResourceParams>
</Context>数据源配置好以后用DataSource的getConnection();和数据库建立连接<%@ page import="java.sql.*"%>
<%@ page import="javax.naming.*"%>
<%@ page import="javax.sql.*"%>
<%
try{
Context Ctx = new InitialContext();
// jdbc/test是jndi的名字,即是配置里面的JNDI Name
DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/test");
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
String sql = " select * from XXX";
ResultSet rs = stmt.executeQuery(sql);%>
http://dev.csdn.net/develop/article/35/35271.shtm
<Resource name="jdbc/ForumMssql" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/ForumMssql">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<parameter>
<name>username</name>
<value>ddddd</value>
</parameter>
<parameter>
<name>password</name>
<value>fffff</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=forum</value>
</parameter>
</ResourceParams>
</Context>
http://blog.csdn.net/gjd111686/archive/2004/09/13/102893.aspx