We have an application which is deployed on jboss4 and maintaining a pool of connection with Inconcert database. PFB the ds.xml file:-
<adapter-display-name>Inconcert System Connection</adapter-display-name>
<config-property name="ServerName" type="java.lang.String">optxicp</config-property>
<config-property name="ServerHost" type="java.lang.String">icapp</config-property>
<config-property name="ServerPort" type="java.lang.String">61071</config-property>
<!-- A seperate sub-pool is created per username logged into inconcert, and the max pool size is per sub pool -->
I am not able to understand what is the meaning of sub pool per user. I think connection pool is maintained at application level and not at user level. Much appreciate if somebody clarify my doubt.
Thanks in advance,
You are correct in assuming that a database connection pool is maintained at the application server level, not at the user level. However, it would appear that the Inconcert database maintains its own connection pool. You should ask your question to the makers of the database.