Another way of doing this without deleting and recreating the connection-pool is to use "asadmin" get and set commands.
First use the get command to check the old database settings:
>asadmin get -user admin --passwordfile /root/passwd.gf "server.resources.jdbc-conection-pool.[i]<jdbc-connection-pool-id>[/i].*
Next use the set command to change to the new database settings:
>asadmin set --user admin --passwordfile /root/passwd.gf "server.resources.jdbc-connection-pool.[i]<jdbc-connection-pool-id>[/i].datasource-classname=[i]<new classname>[/i]"
>asadmin set -user admin --passwordfile /root/passwd.gf "server.resources.jdbc-connection-pool.[i]<jdbc-connection-pool-id>[/i].property.DatabaseName=[i]<new database name>[/i]
...
[Message sent by forum member 'janey' (janey)]
http://forums.java.net/jive/thread.jspa?messageID=250196