Chris Dole wrote: > Hello, > > Can anyone provide some assistance? I am trying to use PostgreSQL v7.0.3 > with JBoss-2.1. The configuration entries in jboss.jcml are below. JBoss > hangs when it tries to start the connection pool. The log file is as > follows: > > [InFluidConPool] Starting > [InFluidConPool] XA connection pool InFluidConPool bound to > java:/InFluidConPool Usually a hang here indicates that either the jdbc driver isn't getting loaded (you should see a message somewhere above there saying that the driver was loaded) or that there was a problem connecting to the database. Is the database running on the same machine as JBoss? You may need to configure your pg_hba.conf (I believe that 7.0.3 ships with a pb_hba.conf that allows access from localhost, but not from any other IP). What OS are you running on? Usually the postgres user is named 'postgres', not sysadm. > > and then nothing. JBoss does not progress past this point. > > I'm using the default PostgreSQL database and the sysadm/masterkey login > just to test the connection pool. The PostgreSQL Guardian is running > when I boot JBoss. > > Thanks in advance for any information/help! > Chris > > > My entries in the jboss.jcml file are as follows: > > <mbean code="org.jboss.jdbc.JdbcProvider" > name="DefaultDomain:service=JdbcProvider"> > <attribute > >name="Drivers">org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,oracle.jdbc.driver.OracleDriver,org.postgresql.Driver</attribute> > > > </mbean> > > > <mbean code="org.jboss.jdbc.XADataSourceLoader" > name="DefaultDomain:service=XADataSource,name=PostgreDB"> > <attribute name="PoolName">InFluidConPool</attribute> > <attribute > >name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute> > > > <attribute name="Properties"></attribute> > <attribute > name="URL">jdbc:postgresql://herbert.IEI-Soft.com:5432/template1</attribute> > > <attribute name="GCMinIdleTime">1200000</attribute> > <attribute name="JDBCUser">sysdba</attribute> > <attribute name="Password">masterkey</attribute> > <attribute name="MaxSize">10</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
