路人甲在吗?demoPool还是有(SOException)例外啊

[fentid]

星期二 四月 17 17:16:55 GMT+08:00 2001:<I> <JDBC Pool> Creating connection pool
demoPool with:
{poolName=demoPool, maxCapacity=10, props=user=scott;password=tiger;server=wyu,
driver=oracle.jdbc.driver.OracleDriver, aclName=weblogic.jdbc.connectionPool.de
moPool, capacityIncrement=1, initialCapacity=1, url=jdbc:oracle:thin:@host:1521:wyu}
oracle.net.TNSAddress.SOException
...
请问TNSAddress的SOException怎么引起的??
最后提示说demoPool创建成功了,可还是用不了,你创建Pool的时候有没有出现例外啊??
星期二 四月 17 17:16:59 GMT+08:00 2001:<I> <JDBC Pool> Connection for pool "demo
Pool" created.

[skyyoung]

例外有啊，我也不清楚为什么，但connection pool可以用啊。
import java.sql.*;
import java.util.*;
import javax.naming.*;

import oracle.jdbc.dbaccess.*;
import oracle.sql.*;

Context ctx = null;
Hashtable ht = new Hashtable();
java.sql.Connection conn = null;
ht.put(Context.INITIAL_CONTEXT_FACTORY,"weblogic.jndi.WLInitialContextFactory");
ht.put(Context.PROVIDER_URL,"t3://localhost:80");
try
{
ctx = new InitialContext(ht);
javax.sql.DataSource ds = (javax.sql.DataSource) ctx.lookup("demoDataSource");
conn = ds.getConnection();
Statement s = conn.createStatement();
...

[fentid]

那个demoPool果然是有用的,我还以为有例外出现就没有用了,谢谢!

[fentid]

老兄有错啊,抄weblogic的例子也有错,不过weblogic自己的例子运行倒是没错;(
ejbFindByPrimaryKey ([e-mail])

UNABLE to get a connection from demoPool!

Please make sure that you have setup the connection pool properly

星期二 四月 17 19:13:27 CST 2001:<E> <Adapter> Exception thrown by rmi server: [316530732462791509S202.192.246.21:[7001,7001,7002,7002,7001,-1]/259]

javax.ejb.EJBException

at ejbprj.DispatchUserBean.getConnection(DispatchUserBean.java:103)

at ejbprj.DispatchUserBean.ejbFindByPrimaryKey(DispatchUserBean.java:47)...
那个getConnection()方法如下:
private Connection getConnection()
throws SQLException
{
InitialContext initCtx = null;
try {
initCtx = new InitialContext();
DataSource ds = (javax.sql.DataSource)
initCtx.lookup("java:comp/env/jdbc/demoPool");
return ds.getConnection();
} catch(NamingException ne) {
log("UNABLE to get a connection from demoPool!");
log("Please make sure that you have setup the connection pool properly");
throw new EJBException(ne);
} finally {
try {
if(initCtx != null) initCtx.close();
} catch(NamingException ne) {
log("Error closing context: " + ne);
throw new EJBException(ne);
}
}
}