配tomcat的数据源死活不行,郁闷?谁帮忙?

Question

Context ctx = new InitialContext();
      DataSource ds = (DataSource) ctx.lookup("java:/comp/env/jdbc/myoracle");
      conn = ds.getConnection();

Answer 1

另外,把你的Resource结点的所有内容及子结点,配到Context结点中去,即作为Context的子结点试试.

Answer 2

</Context>
        <Context className="org.apache.catalina.core.StandardContext" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="false" debug="0" docBase="C:\eclipse-SDK-2.1.3-win32\eclipse\workspace\tom" mapperClass="org.apache.catalina.core.StandardContextMapper" path="" privileged="false" reloadable="true" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper">
       
          <Resource name="jdbc/smsgroup" scope="Shareable" type="javax.sql.DataSource"/>
          <ResourceParams name="jdbc/smsgroup">
            <parameter>
              <name>maxWait</name>
              <value>10000</value>
            </parameter>
            <parameter>
              <name>maxActive</name>
              <value>100</value>
            </parameter>
            <parameter>
              <name>password</name>
              <value>shiwtshiwt</value>
            </parameter>
            <parameter>
              <name>url</name>
              <value>jdbc:mysql://localhost:3306/smsgroup?autoReconnect=true</value>
            </parameter>
            <parameter>
              <name>driverClassName</name>
              <value>org.gjt.mm.mysql.Driver</value>
            </parameter>
            <parameter>
              <name>maxIdle</name>
              <value>30</value>
            </parameter>
            <parameter>
              <name>username</name>
              <value>swt</value>
            </parameter>
          </ResourceParams>

</Context>
放在</host>前面，另外在你的project的WEB-INF中的web.xml配置了了吗？
  <resource-ref>
      <description>DB Connection</description>
      <res-ref-name>jdbc/smsgroup</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
  </resource-ref>
最后，我觉得你的代码是对的

Answer 3

数据源找到了,可是报这样的错误:
canｎｏｔ create jdbc driver of class '' for connect url 'null'
可是,class12.jar我考到common\lib\下了,而且也加了classpath,还有什么没配吗?

Answer 4

妈的，我也碰到相同的问题，老是找不到jdbc dirver,而驱动的jar都在common\lib\下。最后只好参照一个以前项目没问题的配置：
<!-- demo config-->        
        <Context path="/demo" docBase="demo" debug="0" reloadable="true">
<Resource name="jdbc/NewsXADataSource" auth="Container" type="javax.sql.DataSource"/>      <ResourceParams name="jdbc/NewsXADataSource">
        <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://localhost:1433;databaseName=master</value>
   </parameter>
  <parameter>
     <name>username</name>
     <value>sa</value>
  </parameter>
  <parameter>
     <name>password</name>
     <value></value>
  </parameter>
  </ResourceParams>
   </Context>web.xml中照旧。才没问题