Creating Connection Pools in Glassfish
<jdbc-connection-pool name="yourDS" ...>
  <description>...</description>
  <property name="DatabaseName" value="..."/>
  <property name="Password" value="..."/>
  <property name="User" value="..."/>
  <property name="ServerName" value="localhost"/>
  <property name="PortNumber" value="3306"/>
</jdbc-connection-pool>

asadmin create-jdbc-connection-pool --datasourceclassname    com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource --restype    javax.sql.ConnectionPoolDataSource --property "User=myUser:Password=myPassword:URL=jdbc:mysql://localhost/dbname" myConnPoolName
asadmin create-jdbc-resource --connectionpoolid myConnPoolName jdbc/myConnPoolName

create-jdbc-connection-pool --restype=javax.sql.DataSource --datasourceclassname=oracle.jdbc.pool.OracleDataSource --property=user=<USER>:password=<PWD>:url=<YOUR_SERVER>\:<PORT>\:<SID> <DataSourceName>