1 Reply Latest reply on Feb 8, 2008 3:26 PM by Sohil Shah

    Portal data source config problem

    William Newbie

      I'm getting the following error after a build/build.sh deploy and jboss-portal.sar is copied in jboss-4.2.2.GA/server/default/deploy.

      --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
      ObjectName: jboss.jca:service=DataSourceBinding,name=PortalDS
       State: NOTYETINSTALLED
       Depends On Me:
       portal:service=Hibernate
       portal:service=Hibernate,type=Instance
       portal:service=Hibernate,type=PortalObject
       portal:service=Hibernate,type=Portlet
      
      
      13:34:04,344 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-127.0.0.1-8080
      


      added postgres-ds.xml to jboss-4.2.2.GA/server/default/deploy
      added postgresql-8.3-603.jdbc4.jar to jboss-4.2.2.GA/server/default/lib

      I've changed out the following <jndi-name> tag to PostgresDS as well, but didn't work. This file is basically the same as the postgres-ds.xml found in server/default/deploy.

      jboss-portal-2.6.3.GA-src/core/output/resources/setup/portal-ds.xml
      <datasources>
       <local-tx-datasource>
       <jndi-name>PortalDS</jndi-name>
       <connection-url>jdbc:postgresql://192.168.3.10:8080/jbossportal</connection-url>
       <driver-class>org.postgresql.Driver</driver-class>
       <user-name>my</user-name>
       <password>mypass</password>
       <!-- sql to call when connection is created. Can be anything, select 1 is valid for PostgreSQL
       <new-connection-sql>select 1</new-connection-sql>
       -->
       <!-- sql to call on an existing pooled connection when it is obtained from pool. Can be anything, select 1 is valid for PostgreSQL
       <check-valid-connection-sql>select 1</check-valid-connection-sql>
       -->
       <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml -->
       <metadata>
       <type-mapping>PostgreSQL 8.0</type-mapping>
       </metadata>
       </local-tx-datasource>
      </datasources>
      


      Any ideas?

        • 1. Re: Portal data source config problem
          Sohil Shah Master

           

          <connection-url>jdbc:postgresql://192.168.3.10:8080/jbossportal</connection-url>
          


          Is your Postgres database instance running on port 8080?

          My first instict tells me, this is an issue with your connection-url.

          Can you the full stack trace that includes the error that happens when datasource installation is failing?

          Thanks