7 Replies Latest reply on Dec 14, 2007 7:09 AM by Ronald van Kuijk

    Connection was lost

    Gabriel Gutierrez Newbie

      Hi, im lossing the connections when i use the datasources, another thing is that when i get more than 20 connections from the datasource it says that it doesn't have more.

      this is the xml that is i have for the datasources config.


      <?xml version="1.0" encoding="UTF-8"?>

      <local-tx-datasource>
      <jndi-name>JbpmDS</jndi-name>
      <connection-url>jdbc:sqlserver://srvdm2;DatabaseName=JbpmDBDesarrollo;</connection-url>
      <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
      <user-name>sa</user-name>
      sa
      <min-pool-size>15</min-pool-size>
      </local-tx-datasource>

      <local-tx-datasource>
      <jndi-name>BPMPavecaDS</jndi-name>
      <connection-url>jdbc:sqlserver://srvdm2;DatabaseName=BPMPavecaDesarrollo;</connection-url>
      <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
      <user-name>sa</user-name>
      sa
      <min-pool-size>15</min-pool-size>
      </local-tx-datasource>

      <local-tx-datasource>
      <jndi-name>BPCSDS</jndi-name>
      <connection-url>jdbc:as400://APPN.S103882C/V82BPCSF</connection-url>
      <driver-class>com.ibm.as400.access.AS400JDBCDriver</driver-class>
      <user-name>CONEXION</user-name>
      CONEXION01
      <min-pool-size>15</min-pool-size>
      </local-tx-datasource>

      <local-tx-datasource>
      <jndi-name>MTDS</jndi-name>
      <connection-url>jdbc:as400://APPN.S103882C/VEAM900F</connection-url>
      <driver-class>com.ibm.as400.access.AS400JDBCDriver</driver-class>
      <user-name>CONEXION</user-name>
      CONEXION01
      <min-pool-size>15</min-pool-size>
      </local-tx-datasource>

      <local-tx-datasource>
      <jndi-name>InterfaseDS</jndi-name>
      <connection-url>jdbc:as400://APPN.S103882C/V82BPCSUSF</connection-url>
      <driver-class>com.ibm.as400.access.AS400JDBCDriver</driver-class>
      <user-name>CONEXION</user-name>
      CONEXION01
      <min-pool-size>15</min-pool-size>
      </local-tx-datasource>



      any ideas?? thanks,