Hi,
if you have problems you may use my experience.
1. Make sure the JDBC driver is lib/ext
2. Make sure the postmaster is started with -i option.
3. Make sure youre URL is right. I had the following problem:
If my URL is like <attribute
name="URL">jdbc:postgresql://mona/myWMS</attribute>,
i got startup problems. Startup blocked if the blocking attribute was
set.
...
[myWMS] Starting
[myWMS] XA Connection pool myWMS bound to java:/myWMS
Or startup throws an exception
...
[PostgresDS] Starting
[PostgresDS] XA Connection pool myWMS bound to java:/myWMS
[PostgresDS] Stopped
[PostgresDS] java.lang.NullPointerException
[PostgresDS] at
org.opentools.minerva.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:165)
[PostgresDS] at
org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:330)
...
if the blocking attribute is not set. The blocking attribute is not the
problem, it's the URL.
I changed my URL to:
<attribute
name="URL">jdbc:postgresql://mona.iml.fhg.de/myWMS</attribute>
and got a working connection. I inserted the full qualified address.
I seems to me that there is a problem resolving the name mona to the
right IP-address. Ping doesn't have this trouble. Now my working
configuration.
<!-- Drivers that could be used by jBoss -->
<mbean code="org.jboss.jdbc.JdbcProvider"
name="DefaultDomain:service=JdbcProvider">
<attribute name="Drivers">org.postgresql.Driver</attribute>
</mbean>
<!-- PostgreSQL -->
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=PostgresDB">
<attribute name="PoolName">DefaultDS</attribute>
<attribute
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute>
<attribute name="Properties"></attribute>
<attribute
name="URL">jdbc:postgresql://mona.iml.fhg.de/myWMS</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">buerger</attribute>
<attribute name="MaxSize">10</attribute>
<attribute name="Password">ojd</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">1</attribute>
</mbean>
I hope it helps somebody.
Haug Bürger
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
