You're right! Thank you. The postgres user doesn't have a password on
my development database, but specifying a bogus password does the
trick. Strange, isn't it?
Marcel
Burkhard Vogel writes:
> Hi,
> Postgres needs a pwd. I won't run otherwise with jdbc.
> Burkhard
> ----- Original Message -----
> From: "Marcel Schepers" <[EMAIL PROTECTED]>
> To: "jboss-user" <[EMAIL PROTECTED]>
> Sent: Sunday, July 15, 2001 5:24 PM
> Subject: [JBoss-user] JBoss and PostgreSQL 6.5.3
>
>
> > Hello,
> >
> > I am having trouble using PostgreSQL 6.5.3 with JBoss. I've copied
> > 'jdbc6.5-1.2.jar' file to ${JBOSS_HOME}/lib/ext and changed jboss.jcml
> > in order to load the jdbc driver. Loading the driver succeeds, I
> > see that in my console window during startup. Nothing strange there,
> although
> > I had to add 'postgresql.Driver' to jboss.jcml instead of
> > 'org.postgresql.Driver'.
> >
> > I created a new database and I made sure that I could make a
> > connection with it using TCP/IP. I verified that using the pgaccess
> > application specifying localhost, 5432 and postgres as user. There is
> > no password required. Still going strong, nothing strange here either.
> > Adding a new datasource using the database mentioned I get this error:
> >
> > > [PostgresDS] Starting
> > > [PostgresDS] XA Connection pool PostgresDS bound to java:/PostgresDS
> > > [PostgresDS] Stopped
> > > [PostgresDS] java.lang.NullPointerException
> > > [PostgresDS] at
> org.opentools.minerva.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSourc
> e.java:165)
> > > etc, etc
> >
> > The part of jboss.jcml causing this:
> > > <mbean code="org.jboss.jdbc.XADataSourceLoader"
> name="DefaultDomain:service=XADataSource, name=PostgresDB">
> > > <attribute
> name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp
> l</attribute>
> > > <attribute name="PoolName">PostgresDS</attribute>
> > > <attribute
> name="URL">jdbc:postgresql://localhost:5432/webuser</attribute>
> > > <attribute name="JDBCUser">postgres</attribute>
> > > <attribute name="Password"></attribute>
> > > </mbean>
> >
> > I can not see what I am doing wrong. Am I overlooking the obvious or
> > is PostgreSQL 6.5.3 in combination with jdbc6.5-1.2.jar not suited for
> > the job? If the latter is the case, do I need to upgrade the JDBC
> > driver or do I need to upgrade PostgreSQL to 7.1 along with a newer
> > JDBC driver? For the record I am using Linux, Java version:
> > 1.3.1,Blackdown Java-Linux Team and JBoss 2.2.2 with Tomcat 3.2.2
> > integrated.
> >
> > Thank you very much,
> > Marcel
> >
> >
> > _______________________________________________
> > 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
