mbean for db pooling with postgres causing java.lang.NullPoi

[konrad]

i'm trying to set up jboss to use postgres as my db. after making the appropriate settings in jboss.jcml (see below), i get the below error:

[XADataSourceLoader] Starting
[PostgresDS] XA Connection pool PostgresDS bound to java:/PostgresDS
[XADataSourceLoader] Stopped
java.lang.NullPointerException
at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:178)
at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:407)
at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:107)
at java.lang.reflect.Method.invoke(Native Method)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:836)
at $Proxy0.start(Unknown Source)
at org.jboss.util.ServiceControl.start(ServiceControl.java:81)
at java.lang.reflect.Method.invoke(Native Method)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at org.jboss.Main.(Main.java:210)
at org.jboss.Main$1.run(Main.java:116)
at java.security.AccessController.doPrivileged(Native Method)
at org.jboss.Main.main(Main.java:112)

i have tested my db connection to postgres from a stand-alone app and it works fine.

here are my settings:

environment
------------
os: windows2000 with cygwin1.3.3
postgres: 7.1.3 (with jdbc2.0-compatible jdbc driver)
jboss: 2.4.1
java: 1.3.1


jboss.jcml
---------

org.postgresql.Driver,org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver




PostgresDS
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
jdbc:postgresql://localhost:5432/mydb
konrad



for the url, i've also tried the below with no success:
jdbc:postgresql:mydb
jdbc:postgresql://localhost/mydb

if i set the "Blocking" element to "true", jboss just waits...

i've read through the other posts, but still haven't been able to come up with a solution.

i'd appreciate it if you could also email your reply. (btw, is there a regular mailing list version of the forums, or do we need to always check back here for new posts/replies?)

thanks...

[zzhb]

I think you start postgres not using -i .
you must start postgres using postgres -i &

[konrad]

thanks for your reply and suggestion. however, i start postgres as an nt service with the -i option always included. as i mentioned in my previous post, i ran a stand-alone program that connects to postgres via jdbc and queries a table. it runs fine. i do not know why its not working from jboss.

[davidjencks]

This is a total guess, but you might try

as that will produce a 0-length string password rather than a null password (I think).

[konrad]

just tried. unfortunately, it didn't work... :( thanks for the suggestion though! :)

[davidjencks]

mmm, its too late here. Don't know if it will help, I meant

[konrad]

PROBLEM SOLVED. made a *VERY* interesting discovery. apparently, you must (of course) supply the correct username for the owner of the postgres db. however, the password can be anything (e.g. "blah"). however, the below are not acceptable:




the password can be anything but the above 2. in the jboss documentation, it states "You must include a user name and password. They can be bogus if your PostgresSQL installation is configured to "trust" the machine you're coming from, but you can't leave them out." perhaps the dox need to be update that the "username needs to be the one the database was created with and that the password can be anything"?

thanks very much to those who kindly offered their suggestions. much appreciated... :)