I can't say for sure, because I don't use Postgresql... but AFAIK, you
should
use the same values for the PoolName and the Name under the XADataSource
service.
ie:
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=jdbc/PostgresDB">
<attribute name="PoolName">jdbc/PostgresDB</attribute>
instead of
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=PostgreSQL">
<attribute name="PoolName">jdbc/PostgresDB</attribute>
When JBoss hangs on the datasource binding, from my experience, it
indicates a connection to the datasource
could not be established, either because the name is incorrect or the
database is not reachable.
HTH,
Daniel
-----Message d'origine-----
De : John Menke [mailto:[EMAIL PROTECTED]]
Envoyé : 19 avril, 2001 14:38
À : jboss
Objet : [JBoss-user] PostgreSQL 7.1 Datasource setup
I have the following coded in my jboss.jcml and I have included
postgresql.jar in my lib/ext folder, but JBoss hangs on startup.
postmaster
is running with the -i option when I try this and I have a database
setup
named ejb with ejbUser as a user and ejbUserPassword as the account
password.
My environment is:
JBoss 2.2
PostgreSQL 7.1RC4
Redhat Linux 6.2
JBoss startup ends with the following output:
[jdbc/PostgresDB] Starting
[jdbc/PostgresDB] XA connection pool jdbc/PostgreDB bound to
java:/jdbc/PostgresDB
then it hangs...
Does anyone have Postgres7.1 working with JBoss?
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=PostgreSQL">
<attribute name="PoolName">jdbc/PostgresDB</attribute>
<attribute
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourc
eImp
l</attribute>
<attribute name="Properties"></attribute>
<attribute
name="URL">jdbc:postgresql://localhost:5432/ejb</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">ejbUser</attribute>
<attribute name="MaxSize">10</attribute>
<attribute name="Password">ejbUserPassword</attribute>
<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>
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
