有点小问题

Question

<?xml version="1.0" encoding="UTF-8"?>
<Context>
<!-- 
   <Resource  name="jdbc/Pool"  auth="Container" 
              driverClass="com.microsoft.sqlserver.jdbc.SQLServerDriver" maxPoolSize="10" 
              minPoolSize="2" acquireIncrement="2"
              user="sa" password="" 
              factory="org.apache.naming.factory.BeanFactory" 
              type="com.mchange.v2.c3p0.ComboPooledDataSource" 
              jdbcUrl="jdbc:sqlserver://127.0.0.1:1433;databaseName=master" /> 
这个我能连接没有错误
 -->
 
<Resource auth="Container" description="DB Connection" 
driverClass="oracle.jdbc.driver.OracleDriver" maxPoolSize="10"
 minPoolSize="2" acquireIncrement="2" name="jdbc/Pool"
  user="scott" password="tiger" 
  factory="org.apache.naming.factory.BeanFactory" 
  type="com.mchange.v2.c3p0.ComboPooledDataSource" 
  jdbcUrl="jdbc:oracle:thin:@localhost:1521:XIA"/>
这个我连接时 却又异常  </Context>
我导了c3p0-0.9.0  classes.12  commons-logging的包
//后台得到连接
public Connection getConn() throws Exception{
Context ctx = new InitialContext();
Context tomcatCtx = (Context)ctx.lookup("java:comp/env");
    DataSource ds = (DataSource)tomcatCtx.lookup("jdbc/Pool");
    
    return ds.getConnection();
}
希望尽快给我答复.....谢了

Answer 1

user="scott" password="tiger" 
换个账号别用这个，
还有
classes.12  jar请用oracle安装目录下的，别用其他地方下的
不然会出现不兼容的问题

Answer 2

按照你说的...我都做了
可是结果还是一样的
这是异常信息
javax.naming.NameNotFoundException: Name jdbc is not bound in this Context
at org.apache.naming.NamingContext.lookup(NamingContext.java:770)
at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
at com.newer.struts.dao.DBUtil.getConn(DBUtil.java:36)
at com.newer.struts.dao.LoginDao.checkLogin(LoginDao.java:17)
at com.newer.struts.action.LoginAction.execute(LoginAction.java:24)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)

Answer 3

这个
<?xml version="1.0" encoding="UTF-8"?>
<Context><Resource auth="Container" description="DB Connection" 
driverClass="oracle.jdbc.driver.OracleDriver" maxPoolSize="10"
 minPoolSize="2" acquireIncrement="2" name="jdbc/Pool"
  user="system" password="manager" 
  factory="org.apache.naming.factory.BeanFactory" 
  type="com.mchange.v2.c3p0.ComboPooledDataSource" 
  jdbcUrl="jdbc:oracle:thin:@localhost:1521:XIA"/>  </Context>

Answer 4

user="system" password="manager" 
和上面不一样啊?