如何配制数据源

Question

我想在jsp中用
<sql:setDataSource
   var="db1"
   dataSource="jdbc/ch"/>
问一下在tomcat中该如何配置呢？

Answer 1

在tomcat的server.xml下配制
例如：
<Context path="/ch17" docBase="E:\Program Files\eclipse-SDK-2.1.2-win32\eclipse\workspace\ch17" debug="0"   reloadable="true" privileged="true">   <Resource name="jdbc/bn" auth="Container" type="javax.sql.DataSource"/>   
     <ResourceParams name="jdbc/bn">
        <parameter>
             <name>factory</name>
                  <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
                     </parameter>   <parameter>
                      <name>driverClassName</name>
                               <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
                                  </parameter>   <parameter>
             <name>url</name>
             <value>jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=jspdev</value>   </parameter>
              <parameter>     <name>username</name>
              <value>bn</value>   </parameter>   <parameter>     <name>password</name>     <value>bn</value>
               </parameter>   <parameter>     <name>maxActive</name>     <value>20</value>   </parameter>
               <parameter>
            <name>maxIdle</name>     <value>10</value>   </parameter>   <parameter>
        <name>maxWait</name>     <value>-1</value>   </parameter>
        </ResourceParams>     </Context>

Answer 2

其实这个问题楼主到google一搜一大把的。

Answer 3

说的直接一点就是配置tomcat连接池，google上搜索tomcat 连接池，的确是一大把。
要在你自己的WEB-INF下的web.xml中加入配置代码，简单。

Answer 4

我按照一楼的做了，但是为什么会出现找不到driver呢？我不用数据源直接连接的时候没错啊
帮忙啊，急死了：（
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at com.j2ee14.ch7.DatabaseConn.getConnection(DatabaseConn.java:16)
at com.j2ee14.ch7.DataSourceTestServlet.doGet(DataSourceTestServlet.java:15)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:731)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(DriverManager.java:243)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:773)
... 19 more