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