Hi,

I'm having a problem getting connections from pool, because when i ask 
for a connection of a especific user, most of the times the pool returns 
to me connection of other user.

that's my jboss.jcml:

<mbean code="org.jboss.jdbc.JdbcProvider" name="DefaultDomain:service=JdbcProvider">
   <attribute name="Drivers">com.informix.jdbc.IfxDriver</attribute>
</mbean>

<mbean code="org.jboss.jdbc.XADataSourceLoader" 
name="DefaultDomain:service=XADataSource,name=informix">
    <attribute name="PoolName">informix</attribute>
    <attribute 
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute>
    <attribute name="Properties"></attribute>
    <attribute 
name="URL">jdbc:informix-sqli://alpha:1525/giap:INFORMIXSERVER=stable</attribute>
    <attribute name="GCMinIdleTime">1200000</attribute>
    <attribute name="JDBCUser"/>
    <attribute name="MaxSize">10</attribute>
    <attribute name="Password"/>
    <attribute name="GCEnabled">false</attribute>
    <attribute name="InvalidateOnError">false</attribute>
    <attribute name="TimestampUsed">false</attribute>
    <attribute name="Blocking">true</attribute>
    <attribute name="GCInterval">120000</attribute>
    <attribute name="IdleTimeout">1800000</attribute>
    <attribute name="IdleTimeoutEnabled">false</attribute>
    <attribute name="LoggingEnabled">false</attribute>
    <attribute name="MaxIdleTimeoutPercent">1.0</attribute>
    <attribute name="MinSize">0</attribute>
  </mbean>

and here is my source code for getting the connection:

  private Connection getConnection(String user, String password) throws Exception{
      Context jndiCtx=getJndiContext();
      DataSource ds=(DataSource)jndiCtx.lookup("java:/informix");
      Connection con=ds.getConnection(user, password);
      return con;
  }

Thanks.
Best regards.

Luis Medalhas
[EMAIL PROTECTED]



_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to