[jboss-user] [JBoss Portal] - Portal data source config problem

[wizumwalt]

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?

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4127964#4127964

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4127964