View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3821805#3821805
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3821805 hi, I have 3 database and i would like to get the connection randomly from these 3 database. My problem is sometimes i can get the connection and sometimes i can't get. Can anyone tell me what is wrong with the datasource configuration? I am using oracle version 9 <local-tx-datasource> <jndi-name>ds</jndi-name> <connection-url>jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=on)(LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=10.1.1.1)(PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=10.1.1.2)(PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=10.1.1.3)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=ds))) </connection-url> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> <user-name>user</user-name> password <blocking-timeout-millis>25000</blocking-timeout-millis> <idle-timeout-minutes>5</idle-timeout-minutes> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name> </local-tx-datasource> Besides that i would like to extend the connecting time to 30 minutes. Where should i modify the connection time? Is it at the <idle-timeout-minutes>30</idle-timeout-minutes>? Where to set the maximum connection? Thanks in advance ------------------------------------------------------- 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
