2 Replies Latest reply on May 25, 2002 10:38 AM by astahlhut

    JBoss3 and PostgreSQL - PostgresDS not bound - newbie

    astahlhut

      I builded the following postgres-service.xml (copied from hsqldb-service.xml). The postgres-service.xml lies in the deploy-file, but trying to deploy the CD-example bean i get the error-message: "rg.jboss.deployment.DeploymentException: PostgresDS not bound". I have to start the MBean [jboss.jca:service=LocalTxCM,name=PostgresDS]in the management-Console manually, then everything works as expected (In the JNDI-View i can see PostgresDS). I want it to be started at startup. What am I doing wrong?


      <?xml version="1.0" encoding="UTF-8"?>

      <!-- ===================================================================== -->
      <!-- -->
      <!-- JBoss Server Configuration -->
      <!-- -->
      <!-- ===================================================================== -->

      <!-- $Id: postgres-service.xml -->



      <!-- ==================================================================== -->
      <!-- New ConnectionManager setup for default postgres dbs -->
      <!-- ==================================================================== -->


      <!--make the rar deploy! hack till better deployment-->
      jboss.jca:service=RARDeployer


      <depends optional-attribute-name="ManagedConnectionFactoryName">
      <!--embedded mbean-->

      <!--hack-->
      <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter
      jboss:service=Postgres

      <!--real attributes-->


      <config-property>
      <config-property-name>ConnectionURL</config-property-name>
      <config-property-type>java.lang.String</config-property-type>
      <config-property-value>jdbc:postgresql://tian:5432/schmidt</config-property-value>
      </config-property>
      <config-property>
      <config-property-name>DriverClass</config-property-name>
      <config-property-type>java.lang.String</config-property-type>
      <config-property-value>org.postgresql.Driver</config-property-value>
      </config-property>
      <config-property>
      <config-property-name>UserName</config-property-name>
      <config-property-type>java.lang.String</config-property-type>
      <config-property-value>foo</config-property-value>
      </config-property>
      <config-property>
      <config-property-name>Password</config-property-name>
      <config-property-type>java.lang.String</config-property-type>
      <config-property-value>foo</config-property-value>
      </config-property>


      PostgresDS


      <depends optional-attribute-name="ManagedConnectionPool">
      <!--embedded mbean-->


      0
      50
      5000
      15
      <!--criteria indicates if Subject (from security domain) or app supplied
      parameters (such as from getConnection(user, pw)) are used to distinguish
      connections in the pool. Choices are
      ByContainerAndApplication (use both),
      ByContainer (use Subject),
      ByApplication (use app supplied params only),
      ByNothing (all connections are equivalent, usually if adapter supports
      reauthentication)-->
      ByContainer


      <depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager
      java:/jaas/PostgresDbRealm
      java:/TransactionManager