Advertisement

05.31.2008 at 05:22AM PDT, ID: 23446759 | Points: 500
[x]
Attachment Details

JBoss JDBC Data Source exception

Asked by techprocess in Jboss Application Server, Java Programming Language

Tags: JAVA, Firefox, Internet explorer, java.sql.SQLException: Already closed, java.sql.SQLException: Already closed

i have configured JDBC Datasource with jboss using following configuration.

<datasources>
  <local-tx-datasource>
    <jndi-name>IMTPOOl</jndi-name>
    <connection-url>jdbc:microsoft:sqlserver://10.10.60.115:1433;DatabaseName=bjsqldb</connection-url>
    <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
      <connection-property name="auto-commit">false</connection-property>
    <user-name>dbimtquery</user-name>
    <password>dbimtquery</password>
    <min-pool-size>20</min-pool-size>
    <max-pool-size>100</max-pool-size>

      <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
      <metadata>
         <type-mapping>MS SQLSERVER2000</type-mapping>
      </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 helpStart Free Trial
[+][-]05.31.2008 at 06:48AM PDT, ID: 21683716

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.31.2008 at 07:17AM PDT, ID: 21683794

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.31.2008 at 08:25AM PDT, ID: 21683987

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.07.2008 at 10:35PM PDT, ID: 21737634

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628