[jboss-user] [JBoss Portal] - Switching to Sybase Database in JBoss Portal

[eabarquez]

Hello All,

I am trying to switch the database of my JBoss Portal installation to Sybase. I followed the directions in the reference guide on how to switch database, i.e.:

1. Place the connectors in the "[JBOSS_HOME]\server\default\lib" folder.

2. Add a "portal-sybase-ds.xml" datasource file and place it in the "deploy" folder. The file is shown below.

3. Remove the "portal-hsqldb-ds.xml" in the "deploy" folder to avoid conflict in the new datasource.

4. Change the dialect to "org.hibernate.dialect.SybaseDialect" of the different "hibernate.cfg.xml" files found in the "jboss-portal.sar" folder to force the DB dialect to Sybase.

When I run the server, the tables are being created accordingly. However, it throws the exception shown below. I also cannot navigate to the portal page. Is there anything I am missing out in the process?

I am using the server that is bundled with the zip file that I downloaded in the JBoss Portal site. Here are my specifications:

JBOSS: jboss-portal-2.6-ALPHA2
OS: Windows XP


  | The exception being thrown:
  |   
  | --- MBeans waiting for other MBeans ---
  | ObjectName: portal:service=CMS
  |   State: FAILED
  |   Reason: javax.jcr.RepositoryException: failed to create folder for repository meta data: failed to check existence of file system entry: /meta: failed to check existence of file system entry: /meta
  |   I Depend On:
  |     jboss.jca:service=DataSourceBinding,name=PortalDS
  |     portal:service=JAASLoginModule
  |     portal:service=Hibernate,type=CMS
  |     portal:service=Module,type=IdentityServiceController
  |     portal:service=InterceptorStackFactory,type=Cms
  |   Depends On Me:
  |     portal:service=Management,type=CMS,name=Default
  |     portal:commandFactory=CMSObject
  |     cms.pm.cache:service=TreeCache
  |     portal:service=ContentEditor,type=cms
  |  
  | ObjectName: portal:service=Hibernate,type=Instance
  |   State: FAILED
  |   Reason: org.hibernate.exception.GenericJDBCException: could not execute query
  |   I Depend On:
  |     jboss.jca:service=DataSourceBinding,name=PortalDS
  |   Depends On Me:
  |     portal:container=Instance
  |  
  | ObjectName: portal:service=Hibernate,type=PortalObject
  |   State: FAILED
  |   Reason: org.hibernate.exception.GenericJDBCException: could not execute query
  |   I Depend On:
  |     jboss.jca:service=DataSourceBinding,name=PortalDS
  |   Depends On Me:
  |     portal:container=PortalObject
  |  
  | --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
  | ObjectName: portal:service=Hibernate,type=Instance
  |   State: FAILED
  |   Reason: org.hibernate.exception.GenericJDBCException: could not execute query
  |   I Depend On:
  |     jboss.jca:service=DataSourceBinding,name=PortalDS
  |   Depends On Me:
  |     portal:container=Instance
  |  
  | ObjectName: portal:service=Hibernate,type=PortalObject
  |   State: FAILED
  |   Reason: org.hibernate.exception.GenericJDBCException: could not execute query
  |   I Depend On:
  |     jboss.jca:service=DataSourceBinding,name=PortalDS
  |   Depends On Me:
  |     portal:container=PortalObject
  |  
  | ObjectName: portal:service=CMS
  |   State: FAILED
  |   Reason: javax.jcr.RepositoryException: failed to create folder for repository meta data: failed to check existence of file system entry: /meta: failed to check existence of file system entry: /meta
  |   I Depend On:
  |     jboss.jca:service=DataSourceBinding,name=PortalDS
  |     portal:service=JAASLoginModule
  |     portal:service=Hibernate,type=CMS
  |     portal:service=Module,type=IdentityServiceController
  |     portal:service=InterceptorStackFactory,type=Cms
  |   Depends On Me:
  |     portal:service=Management,type=CMS,name=Default
  |     portal:commandFactory=CMSObject
  |     cms.pm.cache:service=TreeCache
  |     portal:service=ContentEditor,type=cms  
  | 


  | My portal-sybase-ds.xml file:
  |  
  | <?xml version="1.0" encoding="UTF-8"?>
  |  
  | <datasources>
  |   <local-tx-datasource>
  |     <jndi-name>PortalDS</jndi-name>
  |     <connection-url>jdbc:sybase:Tds:cc3:5000/jbossportal</connection-url>
  |     <driver-class>com.sybase.jdbc2.jdbc.SybDataSource</driver-class>
  |     <user-name>sa</user-name>
  |     <password></password>
  |     <metadata>
  |       <type-mapping>Sybase</type-mapping>
  |     </metadata>
  |   </local-tx-datasource>
  | </datasources>
  | 

Please advise. Thanks in advance.

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

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