i have configured JDBC Datasource with jboss using following configuration.
<datasources>
<local-tx-datasource>
<jndi-name>IMTPOOl</jndi-n
ame>
<connection-url>jdbc:micro
soft:sqlse
rver://10.
10.60.115:
1433;Datab
aseName=bj
sqldb</con
nection-ur
l>
<driver-class>com.microsof
t.jdbc.sql
server.SQL
ServerDriv
er</driver
-class>
<connection-property name="auto-commit">false</
connection
-property>
<user-name>dbimtquery</use
r-name>
<password>dbimtquery</pass
word>
<min-pool-size>20</min-poo
l-size>
<max-pool-size>100</max-po
ol-size>
<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
<metadata>
<type-mapping>MS SQLSERVER2000</type-mappin
g>
</metadata>
</local-tx-datasource>
</datasources>
i m facing exception "java.sql.SQLException: Already closed" while trying to close the recordset. Previously i was facing the excption while getting connection using datasource configured. Which sounds like my connection pool is fully utilized and further connections cannot be taken without releasing previous.
I have closed the connections immediately after using them but still facing the issue.
pls help
Start Free Trial