5 Replies Latest reply on Mar 20, 2014 3:42 AM by joep.vaes

    Jboss connection error please help?


      I am getting the following error for a particular value but working for other values. Can any body help me why is this happening my database is postgres 8.4.17. My connection jar is pg73jdbc3.jar. I am attaching the postgresql-ds.xml and login-xml file also.



      2013-08-10 12:11:32,588 WARN  [org.jboss.resource.connectionmanager.TxConnectionManager] (http- Connection error occured: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@161ae499[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@706ba7cf handles=1 lastUse=1376116869815 permit=true trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@1c387843 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@3f5f852e xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@5296d03b txSync=null]: java.lang.NullPointerException

        • 1. Re: Jboss connection error please help?

          Which version of JBoss AS you are using?

          • 2. Re: Jboss connection error please help?

            I am using jboss 6

            • 3. Re: Jboss connection error please help?

              You cannot use *-ds.xml file in JBoss 6


              any more...


              For Configuring JDBC driver and datasource follow the below steps:


              Step 1: Deploy your jdbc driver (postgresql-9.1-902.jdbc4.jar) under JBoss_6_Home\modules\org\postgresql\main  directory (if such directory doesn't exists create one)


              Step 2: P


              lace the following module.xml file under JBoss_6_Home\modules\org\postgresql\main  directory


              <module xmlns="urn:jboss:module:1.1" name="org.postgresql">
              <resource-root path="postgresql-9.1-902.jdbc4.jar"/>
              <module name="javax.api"/>
              <module name="javax.transaction.api"/>


              Step 3: Configure your datasource standalone.xml


              file under JBoss_6_Home\standalone\configuration as below


              Find the datasource tag in the standalone.xml file and configure as




              <datasource jndi-name="java:jboss/PostgresDS" pool-name="PostgresDS">
              <user-name>admin</user-nam e>
              <valid-connection-checker classname="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLValidConnectionChecker"></valid-connection-checker>
              <exception-sorter classname="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLExceptionSorter">
              <driver name="postgresql" module="org.postgresql">


              Replace connection url according to your application, the above procedure might work...




              • 4. Re: Jboss connection error please help?

                I understand what you say but currently I am able to connect to my database from my application. and also i will try what you say.

                • 5. Re: Jboss connection error please help?

                  Hi Maimur, we have had the same issue twice yesterday, using jboss 6.1. Do you happen to have a solution/reason for the issue?




                  Joep Vaes