Hi,
I am sure one of u must have configured a connection pool for
Postgresql6.5.3 on linux with jboss2.1,
I went throught the archives, and manuals, and made entries in jboss.jcml
accordingly, after looking at the configuration for MSSQLServer. The driver
loads and Initializes without a hitch but the server just hangs when it
comes to the connection pool part. Here is the mbean entries I've made my
jboss.jcml file:
<mbean code="org.jboss.jdbc.JdbcProvider"
name="DefaultDomain:service=JdbcProvider">
<attributename="Drivers">
org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,postgresql.Driver
</attribute>
</mbean>
<!-- Postgresql Configuration -->
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=mydb">
<attribute name="PoolName">PostgresqlPool</attribute>
<attribute
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp
l</attribute>
<attribute name="Properties"></attribute>
<attribute name="URL">jdbc:postgresql://localhost/mydb</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">postgres</attribute>
<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>
I would appreciat if some one could mail me across a proper configuration
entry or just correct the above. the databasename is 'mydb' & the useername
is 'postgres' password is empty.
-Rajeev B.
_________________________________________
Care a click for Nature?
http://rainforest.care2.com/i?p=691557508
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
