10 Replies Latest reply on Mar 21, 2007 3:58 AM by Thomas Heute

    Switching to Sybase Database in JBoss Portal

    Eugene Abarquez Newbie

      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.

        • 1. Re: Switching to Sybase Database in JBoss Portal
          Thomas Heute Master

          Please try to force the dialect in:
          portal-cms-sar/conf/hibernate/cms/hibernate.cfg.xml

          I think that it is missing from the doc.

          Please, let me know

          • 2. Re: Switching to Sybase Database in JBoss Portal
            Eugene Abarquez Newbie

            Hi Thomas,

            Thanks for the quick reply.

            Ok, so here's the thing, I modified all the "hibernate.cfg.xml" files found inside the "jboss-portal.sar" folder to force the DB dialect to Sybase. I found six files in all, the directory path of each I have listed as follows:

            1. \jboss-portal.sar\portal-cms.sar\conf\hibernate\cms\hibernate.cfg.xml
            2. \jboss-portal.sar\conf\hibernate\portal\hibernate.cfg.xml
            3. \jboss-portal.sar\conf\hibernate\instance\hibernate.cfg.xml
            4. \jboss-portal.sar\conf\hibernate\portlet\hibernate.cfg.xml
            5. \jboss-portal.sar\conf\hibernate\user\hibernate.cfg.xml
            6.\jboss-portal.sar\portal-cms.sar\portal-workflow.sar\conf\hibernate\workflow\hibernate.cfg.xml

            Here's a sample of how I changed the hibernate.cfg.xml file:

            <?xml version='1.0' encoding='utf-8'?>
            
            <!DOCTYPE hibernate-configuration PUBLIC
             "-//Hibernate/Hibernate Configuration DTD//EN"
             "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
            <hibernate-configuration>
             <session-factory>
            
             <property name="connection.datasource">java:PortalDS</property>
             <property name="show_sql">false</property>
            
             <!-- caching properties -->
             <property name="cache.use_second_level_cache">true</property>
             <property name="cache.use_query_cache">true</property>
             <property name="cache.provider_configuration_file_resource_path">conf/hibernate/cms/ehcache.xml</property>
             <property name="cache.provider_class">org.hibernate.cache.EhCacheProvider</property>
            
             <!-- managed environment transaction configuration -->
             <property name="hibernate.transaction.manager_lookup_class">org.hibernate.transaction.JBossTransactionManagerLookup</property>
             <property name="hibernate.transaction.factory_class">org.hibernate.transaction.JTATransactionFactory</property>
            
             <!-- Force the dialect instead of using autodetection -->
             <property name="dialect">org.hibernate.dialect.SybaseDialect</property>
            
             <!-- Mapping files -->
             <mapping resource="conf/hibernate/cms/domain.hbm.xml"/>
             </session-factory>
            </hibernate-configuration>


            I am still getting the same error from my last post though. I also looked into the server log file and found some additional error messages. This might help.

            2007-03-14 10:14:52,343 DEBUG [org.jboss.portal.jems.hibernate.SessionFactoryBinder] Starting failed portal:service=Hibernate,type=Instance
            org.hibernate.exception.GenericJDBCException: could not execute query
             at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
             at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
             at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
             at org.hibernate.loader.Loader.doList(Loader.java:2147)
             at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028)
             at org.hibernate.loader.Loader.list(Loader.java:2023)
             at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393)
             at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
             at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
             at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
             at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
             at org.jboss.portal.jems.hibernate.SessionFactoryBinder.doCheck(SessionFactoryBinder.java:297)
             at org.jboss.portal.jems.hibernate.SessionFactoryBinder.startService(SessionFactoryBinder.java:251)
             at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
             at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)
             at org.jboss.portal.jems.as.system.AbstractJBossService.start(AbstractJBossService.java:73)
             at sun.reflect.GeneratedMethodAccessor19.invoke(Unknown Source)
             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
             at java.lang.reflect.Method.invoke(Method.java:585)
             at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
             at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
             at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
             at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
             at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
             at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
             at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
             at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
             at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:995)
             at $Proxy0.start(Unknown Source)
             at org.jboss.system.ServiceController.start(ServiceController.java:417)
             at org.jboss.system.ServiceController.start(ServiceController.java:435)
             at org.jboss.system.ServiceController.start(ServiceController.java:435)
             at org.jboss.system.ServiceController.start(ServiceController.java:435)
             at org.jboss.system.ServiceController.start(ServiceController.java:435)
             at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
             at java.lang.reflect.Method.invoke(Method.java:585)
             at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
             at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
             at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
             at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
             at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
             at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
             at $Proxy4.start(Unknown Source)
             at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
             at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
             at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
             at java.lang.reflect.Method.invoke(Method.java:585)
             at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
             at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
             at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
             at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
             at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
             at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
             at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
             at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
             at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
             at $Proxy157.start(Unknown Source)
             at org.jboss.deployment.XSLSubDeployer.start(XSLSubDeployer.java:197)
             at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
             at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
             at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
             at sun.reflect.GeneratedMethodAccessor59.invoke(Unknown Source)
             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
             at java.lang.reflect.Method.invoke(Method.java:585)
             at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
             at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
             at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
             at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
             at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
             at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
             at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
             at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
             at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
             at $Proxy8.deploy(Unknown Source)
             at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
             at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
             at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
             at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)
             at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
             at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
             at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
             at java.lang.reflect.Method.invoke(Method.java:585)
             at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
             at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
             at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
             at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
             at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
             at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
             at $Proxy0.start(Unknown Source)
             at org.jboss.system.ServiceController.start(ServiceController.java:417)
             at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
             at java.lang.reflect.Method.invoke(Method.java:585)
             at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
             at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
             at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
             at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
             at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
             at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
             at $Proxy4.start(Unknown Source)
             at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
             at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
             at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
             at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
             at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
             at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
             at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
             at java.lang.reflect.Method.invoke(Method.java:585)
             at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
             at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
             at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
             at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
             at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
             at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
             at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
             at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
             at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
             at $Proxy5.deploy(Unknown Source)
             at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
             at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
             at org.jboss.Main.boot(Main.java:200)
             at org.jboss.Main$1.run(Main.java:490)
             at java.lang.Thread.run(Thread.java:595)
            Caused by: com.sybase.jdbc2.jdbc.SybSQLException: Incorrect syntax near the keyword 'ROLE'.
            
             at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2846)
             at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2168)
             at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
             at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220)
             at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203)
             at com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1596)
             at com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1581)
             at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:96)
             at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)
             at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
             at org.hibernate.loader.Loader.getResultSet(Loader.java:1668)
             at org.hibernate.loader.Loader.doQuery(Loader.java:662)
             at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
             at org.hibernate.loader.Loader.doList(Loader.java:2144)
             ... 123 more
            


            2007-03-14 10:14:52,656 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not execute query [select portalobje0_.PK as PK57_, portalobje0_.LISTENER as LISTENER57_, portalobje0_4_.INSTANCE_REF as INSTANCE2_64_, case when portalobje0_1_.PK is not null then 1 when portalobje0_2_.PK is not null then 2 when portalobje0_3_.PK is not null then 3 when portalobje0_4_.PK is not null then 4 when portalobje0_.PK is not null then 0 end as clazz_ from JBP_PORTAL_OBJECT portalobje0_ left outer join JBP_CONTEXT portalobje0_1_ on portalobje0_.PK=portalobje0_1_.PK left outer join JBP_PORTAL portalobje0_2_ on portalobje0_.PK=portalobje0_2_.PK left outer join JBP_PAGE portalobje0_3_ on portalobje0_.PK=portalobje0_3_.PK left outer join JBP_WINDOW portalobje0_4_ on portalobje0_.PK=portalobje0_4_.PK]
            com.sybase.jdbc2.jdbc.SybSQLException: JBP_PORTAL_OBJECT not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
            
             at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2846)
             at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2168)
             at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
             at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220)
             at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203)
             at com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1596)
             at com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1581)
             at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:96)
             at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)
             at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
             at org.hibernate.loader.Loader.getResultSet(Loader.java:1668)
             at org.hibernate.loader.Loader.doQuery(Loader.java:662)
             at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
             at org.hibernate.loader.Loader.doList(Loader.java:2144)
             at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028)
             at org.hibernate.loader.Loader.list(Loader.java:2023)
             at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393)
             at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
             at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
             at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
             at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
             at org.jboss.portal.jems.hibernate.SessionFactoryBinder.doCheck(SessionFactoryBinder.java:297)
             at org.jboss.portal.jems.hibernate.SessionFactoryBinder.startService(SessionFactoryBinder.java:251)
             at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
             at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)
             at org.jboss.portal.jems.as.system.AbstractJBossService.start(AbstractJBossService.java:73)
             at sun.reflect.GeneratedMethodAccessor19.invoke(Unknown Source)
             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
             at java.lang.reflect.Method.invoke(Method.java:585)
             at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
             at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
             at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
             at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
             at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
             at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
             at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
             at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
             at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:995)
             at $Proxy0.start(Unknown Source)
             at org.jboss.system.ServiceController.start(ServiceController.java:417)
             at org.jboss.system.ServiceController.start(ServiceController.java:435)
             at org.jboss.system.ServiceController.start(ServiceController.java:435)
             at org.jboss.system.ServiceController.start(ServiceController.java:435)
             at org.jboss.system.ServiceController.start(ServiceController.java:435)
             at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
             at java.lang.reflect.Method.invoke(Method.java:585)
             at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
             at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
             at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
             at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
             at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
             at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
             at $Proxy4.start(Unknown Source)
             at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
             at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
             at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
             at java.lang.reflect.Method.invoke(Method.java:585)
             at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
             at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
             at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
             at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
             at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
             at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
             at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
             at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
             at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
             at $Proxy157.start(Unknown Source)
             at org.jboss.deployment.XSLSubDeployer.start(XSLSubDeployer.java:197)
             at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
             at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
             at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
             at sun.reflect.GeneratedMethodAccessor59.invoke(Unknown Source)
             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
             at java.lang.reflect.Method.invoke(Method.java:585)
             at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
             at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
             at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
             at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
             at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
             at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
             at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
             at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
             at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
             at $Proxy8.deploy(Unknown Source)
             at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
             at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
             at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
             at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)
             at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
             at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
             at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
             at java.lang.reflect.Method.invoke(Method.java:585)
             at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
             at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
             at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
             at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
             at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
             at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
             at $Proxy0.start(Unknown Source)
             at org.jboss.system.ServiceController.start(ServiceController.java:417)
             at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
             at java.lang.reflect.Method.invoke(Method.java:585)
             at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
             at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
             at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
             at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
             at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
             at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
             at $Proxy4.start(Unknown Source)
             at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
             at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
             at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
             at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
             at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
             at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
             at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
             at java.lang.reflect.Method.invoke(Method.java:585)
             at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
             at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
             at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
             at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
             at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
             at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
             at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
             at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
             at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
             at $Proxy5.deploy(Unknown Source)
             at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
             at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
             at org.jboss.Main.boot(Main.java:200)
             at org.jboss.Main$1.run(Main.java:490)
             at java.lang.Thread.run(Thread.java:595)



            Should I use the 2.4.1 version of jboss portal instead, as I've read that this is a more stable version?

            Also in a completely different topic, what version of jboss portal would work best with jboss-4.0.3sp1? As I am looking into integrating it with that version of the jboss AS.

            Thank you.

            • 3. Re: Switching to Sybase Database in JBoss Portal
              Eugene Abarquez Newbie

              Ok, I tried switching to Sybase using jboss-portal-2.4.1, and I am getting similar errors. Is this a known Sybase DB issue? Or am I just doing something wrong here?

              • 5. Re: Switching to Sybase Database in JBoss Portal
                Eugene Abarquez Newbie

                I am still very much interested for an answer to this, so anyone with any ideas, just let me know. This might be an issue with JBoss Portal being coupled with Sybase. I have tried switching to MySQL 5 and it seemed to work fine. However, we are using Sybase as the database for our old applications, so if we should integrate JBoss Portal, we have to use Sybase too.

                I will check on this thread every once in a while. Thanks in advance.

                • 6. Re: Switching to Sybase Database in JBoss Portal
                  Thomas Heute Master

                  i'm trying to get a hold on a Sybase instance

                  • 7. Re: Switching to Sybase Database in JBoss Portal
                    Eugene Abarquez Newbie

                    Thanks. I am looking forward to your next reply.

                    • 8. Re: Switching to Sybase Database in JBoss Portal
                      Thomas Heute Master

                      I got a hold on it, but the problem doesn't *seem* trivial. I don't have the time to look at it now unfortunately

                      • 9. Re: Switching to Sybase Database in JBoss Portal
                        Eugene Abarquez Newbie

                        Alright then, well let me know when you are able to find a workaround on this issue. I am actually just evaluating Portal for a probable integration with our system. I might have to do actual integration in the future. I will just check on this thread every once in a while. Thanks a lot!

                        • 10. Re: Switching to Sybase Database in JBoss Portal
                          Thomas Heute Master

                          You should subscribe as a watcher on this instead:
                          http://jira.jboss.com/jira/browse/JBPORTAL-1152

                          Because we will probably forget to put on note on this thread ;)