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 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user