tomcat7 - 配置 jdbc-pool (tomcat 7)

Question

我在使用 tomcat 7 配置 jdbc-pool 时遇到了一些问题:我尝试遵循以下示例:http://www.tomcatexpert.com/blog/2010/04/01/configuring-jdbc-pool-high-concurrency

所以我有:

conf/server.xml

 <GlobalNamingResources>
  <Resource type="javax.sql.DataSource"
            name="jdbc/DB"
            factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
            driverClassName="com.mysql.jdbc.Driver"
            url="jdbc:mysql://localhost:3306/mydb"
            username="user"
            password="password"
/>
 </GlobalNamingResources>

conf/context.xml

<Context>
  <ResourceLink type="javax.sql.DataSource"
                name="jdbc/LocalDB"
                global="jdbc/DB"
/>
 <Context>

当我尝试这样做时:

Context initContext = new InitialContext();
Context envContext  = (Context)initContext.lookup("java:/comp/env");
DataSource datasource = (DataSource)envContext.lookup("jdbc/LocalDB");
Connection con = datasource.getConnection();

我不断收到此错误:

javax.naming.NameNotFoundException: Name jdbc is not bound in this Context
 at org.apache.naming.NamingContext.lookup(NamingContext.java:803)
 at org.apache.naming.NamingContext.lookup(NamingContext.java:159)

请帮忙
tnx

Answer 1

<Context>  <ResourceLink type="javax.sql.DataSource"  name="jdbc/LocalDB" global="jdbc/DB"/>

替换那个 name="jdbc/LocalDB"与 name="jdbc/DB"在您的 context.xml 中
和

(DataSource)envContext.lookup("java:/comp/env/jdbc/DB");

【第二行代码多余】。