4 Replies Latest reply on Oct 6, 2003 3:34 PM by juha

    Postgres DS not bound

    jggreenjr

      I have the following datasource that I am trying to deploy using JBoss 3.2.1 and Postgres 7.3.4:


      <local-tx-datasource>
      <jndi-name>DefaultDS</jndi-name>
      <connection-url>jdbc:postgresql://192.168.254.201:5432/highclass</connection-url>
      <driver-class>org.postgresql.Driver</driver-class>
      <user-name>jtrdinich</user-name>
      thinkingman
      </local-tx-datasource>


      When I copy this file into the default/deploy directory and look in the server.log file I see the following:

      deployer: org.jboss.deployment.SARDeployer@1b9ce4b
      status: Starting
      state: START_DEPLOYER
      watch: file:/usr/local/jboss-3.2.1/server/default/deploy/postgres-service.xml
      lastDeployed: 1065130061957
      lastModified: 1065130061000
      mbeans:
      ]
      2003-10-02 15:27:41,983 DEBUG [org.jboss.management.j2ee.ServiceModule] postRegister(), parent: jboss.managem
      ent.local:j2eeType=J2EEServer,name=Local
      2003-10-02 15:27:41,984 DEBUG [org.jboss.management.j2ee.ServiceModule] Created JSR-77 ServiceModule, name: p
      ostgres-service.xml
      2003-10-02 15:27:41,984 DEBUG [org.jboss.management.j2ee.factory.ServiceModuleFactory] Created ServiceModule:
      jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=postgres-service.xml
      2003-10-02 15:27:41,985 DEBUG [org.jboss.deployment.MainDeployer] End deployment start on package: postgres-s
      ervice.xml

      Any attempts to access the datasource result in a datasource not deployed error. Does anyone have any ideas of why my dataset is not deployed? Are there any steps to verify that jboss can even connect to my postgres installation?

      Thanks,

      John Green