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
