connect postgres v7.1.3 to JBoss 2.4.4 
Author Message
 connect postgres v7.1.3 to JBoss 2.4.4

Hi All,

I am trying to connect the JBoss2.4.4 server running on my machine to
a postgreSQL database running on another network machine. I understand
that I have to configure various MBeans via the "jboss.jcml" file. So
far I have done/modified the following in jboss.jcml......

<mbean code="org.jboss.jdbc.JdbcProvider"
name="DefaultDomain:service=JdbcProvider">
     <attribute name="Drivers">org.hsqldb.jdbcDriver</attribute>
     <attribute name="Drivers">org.postgresql.Driver</attribute>
  </mbean>

  <mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=DefaultDS">
    <attribute name="PoolName">DefaultDS</attribute>
    <attribute name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attribute>
    <attribute name="Properties"></attribute>
    <attribute name="URL">jdbc:postgresql://{*filter*}.michaelwise.co.uk/people</attribute>
    <attribute name="GCMinIdleTime">1200000</attribute>
    <attribute name="JDBCUser">object</attribute>
    <attribute name="MaxSize">10</attribute>
    <attribute name="Password">assetdb</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>

From time spent searching this groups archives, I thought that this
would be enough.....however, when I run the server, it simply hangs at
the following point:

[INFO,DefaultDS] Starting
[INFO,DefaultDS] XA Connection pool DefaultDS bound to java:/DefaultDS

I notice that further down in jboss.jcml there is info for
configuration of MBeans for JCA support. Should I be configuring these
as well as the above?

Thanks in advance,

Mike



Mon, 20 Sep 2004 00:46:06 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. REPOST: Postgres and JBoss configuration

2. Postgres and JBoss configuration

3. Postgres and Jboss (2.4.3) configuration

4. REPOST: Postgres and Jboss (2.4.3) configuration

5. missing Pg.pm in Postgres v7.3.1

6. [Fwd: What may be the url we need to use to connect the Postgres

7. monitor postgres connect session

8. Problem connecting to postgres

9. What may be the url we need to use to connect the Postgres Database with Java

10. using ADO connect to postgres

11. How can I connect Windows to postgres

12. Error connecting to Postgres database.


 
Powered by phpBB® Forum Software