J2EE - Ping connection pool fails

Hi All,

M having a very peculiar problem :-).

M porting the CTS on our platform (unix based). Problem happens after i "create-jdbc-connection-pool". Using asadmin I am able to create the jdbc-connection-pool. I can c the entry in domain.xml.

But when I try to "ping-connection-pool" to the connection-pool, m getting the below error.

"Operation 'pingConnectionPool' failed in 'resources' Config Mbean."

The ping is failing with the default pool also (PointBasePool). Do I need to start the databse server. If yes, How?

The real problem is with CTS, when I try to:

{.

.

jc = new TSNamingContext();

ds1 = (DataSource)jc.lookup("java:comp/env/jdbc/DB1");

.

.

}

it is not retriving the correct datasource value. Instead the value returned is:

ds1 = com.sun.gjc.spi.DataSource@1c5543b

Any inputs will be of great help

Thanks,

Nisha

[945 byte] By [jms_123a] at [2007-12-4]
# 1
Please refer the section titled "Starting and Stopping the PointBase Database Server" at http://java.sun.com/j2ee/1.4/docs/tutorial/doc/Overview8.html
sivakumarta at 2007-7-10 > top of java,Enterprise & Remote Computing,AVK Portability...
# 2
Thanx.Even though the PointBaseServer was running, the ping-connection-pool fails.The connection-pool created by us is also of no use.
jms_123a at 2007-7-10 > top of java,Enterprise & Remote Computing,AVK Portability...
# 3
Could you check if your pool configuratin matches this : http://docs.sun.com/source/819-0217/dgjdbc.html#wp49625Could you also post your connection pool configuration if that does not work?
sivakumarta at 2007-7-10 > top of java,Enterprise & Remote Computing,AVK Portability...
# 4
Were you able to nail this problem ? I'm stuck with the same problem while running CTS against my database. It will be of great help to know how you fixed your problem.Thanks,George.
geoasksa at 2007-7-10 > top of java,Enterprise & Remote Computing,AVK Portability...