Hi, I am using jboss-3.2.3 and oracle 9 database. My problem is sometimes i get null pointer exception when i get connection from the pool even though i have set the maximum pool size to 100. I think it is sufficient enough to handle the connections because there only 10 users connecting to the database simultaneously. The oracle-ds.xml setting is as follows:
<local-tx-datasource> <jndi-name>ora</jndi-name> <connection-url>jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=on)(LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=10.10.10.1)(PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=10.10.10.2)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=oradb))) </connection-url> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> <user-name>x</user-name> xx <min-pool-size>50</min-pool-size> <max-pool-size>100</max-pool-size> <blocking-timeout-millis>1800000</blocking-timeout-millis> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name> </local-tx-datasource> i am setting the minimum pool to 50 which mean it will have minimum of 50 connections in the pool even though there isn't any connection being used? Am i right? Should i set the minimum pool to 0? I am not sure why i get null pointer exception when i try to get connection even though i have set <blocking-timeout-millis>1800000</blocking-timeout-millis> which it suppose to wait for 30 minutes if the connections are all used up. Anyone know why? Pls help. Thanks alot yuki View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3857988#3857988 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3857988 ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user