Hi,
it is possible to specify the min & max pool size for each datasource indiviually
and you dont need to put each datasource definition in a separate config file.
see example from my config
<local-tx-datasource>
<jndi-name>MyToplinkDataSource</jndi-name>
<connection-url></connection-url>
<driver-class></driver-class>
<user-name></user-name>
<password></password>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-minutes>15</idle-timeout-minutes>
<!-- Set java.sql.Connection transaction isolation level to use.
The constants defined in the interface Connection are the possible transaction
isolation levels and include:
TRANSACTION_READ_UNCOMMITTED
TRANSACTION_READ_COMMITTED
TRANSACTION_REPEATABLE_READ
TRANSACTION_SERIALIZABLE
TRANSACTION_NONE
Ex:
<transaction-isolation>TRANSACTION_SERIALIZABLE</transaction-isoation>
-->
</local-tx-datasource>
hope this helps
johannes
| mcapitanio <[EMAIL PROTECTED]>
Gesendet von: [EMAIL PROTECTED] 13.02.2004 10:18
|
An: [EMAIL PROTECTED] Kopie: Thema: [JBoss-user] [Datasource Configuration] - Configuring Multiple Dasasource |
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3821380#3821380
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3821380
Hello,
I am working with Jboss working over multiple database on multiple machine.
For every DS, I have a file name xxxx-ds.xml inm the deploy directory, with url, driver name, username and password as usual.
Now I have problems with them and i'd like to know if it is possible to configure the maximum number of connections for each DS or globally.
I am having this problem since I am Session beans with a custom made DAO layer. Now if i use DS it won't work cause due to the high number of thread, no more connection are available and it gives problem. On the other hand if i use direct connection to the DB without pooling it works perfectly
Please help!!!
Max
-------------------------------------------------------
SF.Net is sponsored by: Speed Start Your Linux Apps Now.
Build and deploy apps & Web services for Linux with
a free DVD software kit from IBM. Click Now!
http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
