how to create connection pool

[ramesh123]

Hi ,
could you please tell me how to create connection pool by using jboss


thanks
Ramesh

[peterj]

When you declare your datasource using a *-ds.xml file, supply min-pool-size and max-pool-size entries. For example:

<datasources>
 <local-tx-datasource>
 <jndi-name>ds/ProductDS</jndi-name>
 <connection-url>jdbc:postgresql:productdb</connection-url>
 <driver-class>org.postgresql.Driver</driver-class>
 <user-name>xxx</user-name>
 <password>xxx</password>
 <min-pool-size>5</min-pool-size>
 <max-pool-size>20</max-pool-size>
 </local-tx-datasource>
</datasources>

Reference: http://docs.jboss.com/jbossas/guides/j2eeguide/r2/en/html_single/#ch7.jdbc.sect