Hi Grant, Set the login attribute to true to get more information on what's happening. NullPointer is returned from the pool if it cannot create a connection to the database for any reason. Verify that you start the postmaster with the -i flag, wich enables network connection to the database (check the script that starts postmaster, bekoz in some package of postgres, the -i is not set by default). Or make sure you have the right login and password.
Reguards -- Hermann R A N G A M A N A Ingénieur Informaticien Primagendys SAS Tél : +(33) 1 43 58 27 83 Fax : +(33) 1 43 58 27 17 e-mail : [EMAIL PROTECTED] ----- Original Message ----- From: "Grant Edwards" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 26, 2001 2:24 PM Subject: [JBoss-user] Problems with my Postgres DS > Hi, > > Take a look at the bits and pieces below, my PostgresDS blows up with a > NullPointer. Could be config, not sure. > > Thank you > > > Extracts from my jboss.jcml > > <!-- ==================================================================== > --> > <!-- JDBC > --> > <!-- ==================================================================== > --> > > <mbean code="org.jboss.jdbc.JdbcProvider" > name="DefaultDomain:service=JdbcProvider"> > <attribute > name="Drivers">org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,com. > informix.jdbc.IfxDriver,org.postgresql.Driver</attribute> > </mbean> > > <mbean code="org.jboss.jdbc.XADataSourceLoader" > name="DefaultDomain:service=XADataSource,name=PostgresDB"> > <attribute > name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attr > ibute> > <attribute name="PoolName">PostgresDS</attribute> > <attribute > name="URL">jdbc:postgresql://eve.lastminute.com/database</attribute> > <attribute name="JDBCUser">userName</attribute> > <attribute name="Password">myPassword</attribute> > </mbean> > > > Extracts from server.log > > [Classpath extension] Added > library:file:/usr/local/jboss/JBoss-2.4.1_Tomcat-3.2.3/jboss/lib/ext/postgre > sql.jar > [Configuration] Drivers set to > org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,com.informix.jdbc.I > fxDriver,org.postgresql.Driver in DefaultDomain:service=JdbcProvider > [Configuration] DataSourceClass set to > org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl in > DefaultDomain:service=XADataSource,name=PostgresDB > [Configuration] PoolName set to PostgresDS in > DefaultDomain:service=XADataSource,name=PostgresDB > [Configuration] URL set to jdbc:postgresql://eve.lastminute.com/database in > DefaultDomain:service=XADataSource,name=PostgresDB > [Configuration] JDBCUser set to userName in > DefaultDomain:service=XADataSource,name=PostgresDB > [Configuration] Password set to myPassword in > DefaultDomain:service=XADataSource,name=PostgresDB > [JdbcProvider] Loaded JDBC-driver:org.postgresql.Driver > > And then I get this : > > [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(Configurati > onService.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.<init>(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) > [Configuration] java.lang.NullPointerException > [Configuration] at > org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java: > 178) > [Configuration] at > org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:407) > [Configuration] at > org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:107) > [Configuration] at java.lang.reflect.Method.invoke(Native Method) > [Configuration] at > com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628) > [Configuration] at > com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523) > [Configuration] at > org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(Configurati > onService.java:836) > [Configuration] at $Proxy0.start(Unknown Source) > [Configuration] at > org.jboss.util.ServiceControl.start(ServiceControl.java:81) > [Configuration] at java.lang.reflect.Method.invoke(Native Method) > [Configuration] at > com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628) > [Configuration] at > com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523) > [Configuration] at org.jboss.Main.<init>(Main.java:210) > [Configuration] at org.jboss.Main$1.run(Main.java:116) > [Configuration] at > java.security.AccessController.doPrivileged(Native Method) > [Configuration] at org.jboss.Main.main(Main.java:112) > > > App Developer / Informix DBA > > address: 4 Buckingham Gate, London SW1E 6JP > > tel: +44 (0)20 7802 4348 fax: +44 (0)20 7802 9420 > > email: [EMAIL PROTECTED] > > internet:http://www.lastminute.com/ > > do something lastminute.com > > > > > > > ------------------------------ > > This e-mail is intended for the named addressee only. It may contain confidential and/or privileged information. If you have received this message in error, please let us know and then delete this message from your system. You should not copy the message, use it for any purpose or disclose its contents to anyone. > > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
