weblogic连接池的问题,怎么解决?
ywsws 2001-09-27 03:18:14 我在jsp页面里直接连接sybase数据库没有问题:
Properties props = new Properties();
props.put("user","objuser");
props.put("password","user2000");
Driver myDriver = (Driver) Class.forName
("com.sybase.jdbc.SybDriver").newInstance();
Connection conn = myDriver.connect
("jdbc:sybase:Tds:10.92.128.71:5500/BDW_SERVER", props);
Statement stmt = conn.createStatement();
stmt.execute("select * from an_olt");
ResultSet rs = stmt.getResultSet();
while (rs.next()) {
out.print(rs.getString(1) + " - " +
rs.getString(2)+"<br>");
}
stmt.close();
conn.close();
运行没有问题,但是我建一个connection pool:
weblogic.jdbc.connectionPool.sybasePool= url=jdbc:sybase:Tds:10.92.128.71:5500, driver=com.sybase.jdbc.SybDriver, initialCapacity=1, maxCapacity=10, capacityIncrement=1, props=user=objuser;password=user2000;
然后连接这个pool:
try{
Connection conn=null;
Statement stmt=null;
Driver myDriver=(Driver) Class.forName("weblogic.jdbc.pool.Driver").newInstance();
conn=myDriver.connect("jdbc:weblogic:pool:sybasePool",null);
stmt=conn.createStatement();
}
catch(Exception e){
out.println(e);
}
weblogic报错:
java.sql.SQLException: Connection Pool sybasePool does not exist
请问是什么原因?我用的weblogic6.1是从bea的网站down下来的,还望各位大虾赐教,谢谢!