Switching to Sybase Database in JBoss Portal
eabarquez Mar 14, 2007 3:16 AMHello 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.