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
