My only thought is if you have pg_hba.conf set up to allow TCP from
localhost?
-danch
John Menke wrote:
>
> I just tried that and it still doesn't work.
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]]On Behalf Of Daniel
> > Cardin
> > Sent: Thursday, April 19, 2001 2:52 PM
> > To: [EMAIL PROTECTED]
> > Subject: RE: [JBoss-user] PostgreSQL 7.1 Datasource setup
> >
> >
> > 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
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
Confidential e-mail for addressee only. Access to this e-mail by anyone else is
unauthorized.
If you have received this message in error, please notify the sender immediately by
reply e-mail
and destroy the original communication.
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
