Connection was lost

[gutierrez.ge]

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,

[kukeltje]

wrong forum.... try the jbossAS forum

[gutierrez.ge]

But this is a Jbos JBPM forum and this is happening in my Jbpm app.

:s

[kukeltje]

:-) Then you should go to the Microsoft site (or maybe a linux site) since that is where it runs on.... oh no, wait... Dell or Compaq or HP, or Lenovo is where you need to be. Or maybe even Enron since they probably supplied the energy (:-S)... Ahhhh stupid me... you should go to the site of the government of Venezuela since they probably produced the oil.

[gutierrez.ge]

dude, the problem i'm having is with the DB2, SQLServer and Hibernate connections... and it is supposed that jbpm made jbpm Ohh let me see.. mMmmm i gues they did.

Well i guess i should ask them about the xml file configuration cuz they built it.

Mmm.. i dont think that venezuela (wich produce oil) did the xml standard for jbpm server. Mmmm technology.... oil... mmm nop don't match.. sorry. if dont like it dont see it. :P

[kukeltje]

Sure, the jbpm team knows everything about the jbpm config file and how the engine that uses it works. We are *not* specialists in configurations of datasources the way the hibernate and even your DB2 driver behave in maintaining connections and 'we' certainly did not provide the configfile you show, which is *not* a jbpm config file but a datasource config.

jBPM uses the functionality of an appserver that it runs on, in the jbpm starter kit that is JBoss AS. You seem to have a problem with the persistency layer under JBossAS (hibernate). It could either be the datasource config, hibernate itself or even the DB2 driver. So my statement that you'd be best served in the JBoss AS was one to get *you* the *best* help, since I doubt if you will get a helpful answer her.

So.... please try the JBoss AS forum

[gutierrez.ge]

See that's a gentil explanation...

thanks :P

[kukeltje]

But it took me waaaaaaayyyyyy longer to respond.... :-D