Creating connection pool on Sun Application Server 8.1

Hi All,

I am trying to create a connection pool for my MySql database on Sun Application Server(Version 8.1) using 'asadmin'. I am also able to create the connection pool successfully but when i am trying to ping the connection pool, it is giving me the java.net.UnknownHostException. The command I am using for creating the connection pool is as follows:

create-jdbc-connection-pool --user admin --password adminadmin --host localhost --port 4849 --datasourceclassname com.mysql.jdbc.jdbc2.optional.MySqlConnectionPoolDataSource --restype javax.sql.XADatasource --property User=root:Password=admin:SelectMethod=Cursor:DatabaseName=testdb:serverName=\"l ocalhost\":portNumber=3306 MyConnectionPool

My database and the application server are running on the same machine.

Has anyone come across such a problem? Any help would be highly appriciated.

Thanks in Advance,

Anurag.

[924 byte] By [anurag.choudhary] at [2007-11-26 11:03:35]
# 1
hi Anurag,Check the properties in the jdbc-connection-pool tag and make sure that the values are populated correctly. You can also try specifying the actual hostname or IP address of the machine instead of localhost and see if that works.Cheers,Vasanth
pts_forum at 2007-7-7 3:17:28 > top of Java-index,Application & Integration Servers,Application Servers...