1 2 3 Previous Next 31 Replies Latest reply on Jun 13, 2007 12:57 AM by sonalk. Go to original post
      • 15. Re: from hibernate to sybase
        prabhat.jha

        You dont have jdbc driver jar in lib folder. I think it will help you a lot if you go through portal document once.

        Please put jar containing com.sybase.jdbc2.jdbc.SybaseDataSource in jboss-4.0.5-GA/server/default/lib and this error will go away.

        • 16. Re: from hibernate to sybase
          sonalk.

          I have a jar called jconn2.jar in my jboss/server/default/lib folder.
          Is it the correct jar???

          • 17. Re: from hibernate to sybase
            prabhat.jha

            Well, the best way to find will be to look into jar and see if it has the class you are using.

            • 18. Re: from hibernate to sybase
              sonalk.

              I have already checked that. Its is there.

              • 19. Re: from hibernate to sybase
                sonalk.

                Hello,
                Now I m getting Connection refused error.


                Errors------



                --- MBeans waiting for other MBeans ---
                ObjectName: portal:service=Hibernate
                State: FAILED
                Reason: org.jboss.util.NestedSQLException: Could not create connection; - nest
                ed throwable: (java.sql.SQLException: JZ006: Caught IOException: java.net.Connec
                tException: Connection refused: connect); - nested throwable: (org.jboss.resourc
                e.JBossResourceException: Could not create connection; - nested throwable: (java
                .sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connect
                ion refused: connect))
                I Depend On:
                jboss.jca:name=PortalDS,service=DataSourceBinding
                Depends On Me:
                portal:service=Module,type=IdentityServiceController

                ObjectName: portal:service=Hibernate,type=Instance
                State: FAILED
                Reason: org.jboss.util.NestedSQLException: Could not create connection; - nest
                ed throwable: (java.sql.SQLException: JZ006: Caught IOException: java.net.Connec
                tException: Connection refused: connect); - nested throwable: (org.jboss.resourc
                e.JBossResourceException: Could not create connection; - nested throwable: (java
                .sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connect
                ion refused: connect))
                I Depend On:
                jboss.jca:name=PortalDS,service=DataSourceBinding
                Depends On Me:
                portal:container=Instance

                ObjectName: portal:service=Hibernate,type=PortalObject
                State: FAILED
                Reason: org.jboss.util.NestedSQLException: Could not create connection; - nest
                ed throwable: (java.sql.SQLException: JZ006: Caught IOException: java.net.Connec
                tException: Connection refused: connect); - nested throwable: (org.jboss.resourc
                e.JBossResourceException: Could not create connection; - nested throwable: (java
                .sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connect
                ion refused: connect))
                I Depend On:
                jboss.jca:name=PortalDS,service=DataSourceBinding
                Depends On Me:
                portal:container=PortalObject

                ObjectName: portal:service=Hibernate,type=Portlet
                State: FAILED
                Reason: org.jboss.util.NestedSQLException: Could not create connection; - nest
                ed throwable: (java.sql.SQLException: JZ006: Caught IOException: java.net.Connec
                tException: Connection refused: connect); - nested throwable: (org.jboss.resourc
                e.JBossResourceException: Could not create connection; - nested throwable: (java
                .sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connect
                ion refused: connect))
                I Depend On:
                jboss.jca:name=PortalDS,service=DataSourceBinding
                Depends On Me:
                portal:service=PersistenceManager,type=Producer

                --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
                ObjectName: portal:service=Hibernate
                State: FAILED
                Reason: org.jboss.util.NestedSQLException: Could not create connection; - nest
                ed throwable: (java.sql.SQLException: JZ006: Caught IOException: java.net.Connec
                tException: Connection refused: connect); - nested throwable: (org.jboss.resourc
                e.JBossResourceException: Could not create connection; - nested throwable: (java
                .sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connect
                ion refused: connect))
                I Depend On:
                jboss.jca:name=PortalDS,service=DataSourceBinding
                Depends On Me:
                portal:service=Module,type=IdentityServiceController

                ObjectName: portal:service=Hibernate,type=PortalObject
                State: FAILED
                Reason: org.jboss.util.NestedSQLException: Could not create connection; - nest
                ed throwable: (java.sql.SQLException: JZ006: Caught IOException: java.net.Connec
                tException: Connection refused: connect); - nested throwable: (org.jboss.resourc
                e.JBossResourceException: Could not create connection; - nested throwable: (java
                .sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connect
                ion refused: connect))
                I Depend On:
                jboss.jca:name=PortalDS,service=DataSourceBinding
                Depends On Me:
                portal:container=PortalObject

                ObjectName: portal:service=Hibernate,type=Portlet
                State: FAILED
                Reason: org.jboss.util.NestedSQLException: Could not create connection; - nest
                ed throwable: (java.sql.SQLException: JZ006: Caught IOException: java.net.Connec
                tException: Connection refused: connect); - nested throwable: (org.jboss.resourc
                e.JBossResourceException: Could not create connection; - nested throwable: (java
                .sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connect
                ion refused: connect))
                I Depend On:
                jboss.jca:name=PortalDS,service=DataSourceBinding
                Depends On Me:
                portal:service=PersistenceManager,type=Producer

                ObjectName: portal:service=Hibernate,type=Instance
                State: FAILED
                Reason: org.jboss.util.NestedSQLException: Could not create connection; - nest
                ed throwable: (java.sql.SQLException: JZ006: Caught IOException: java.net.Connec
                tException: Connection refused: connect); - nested throwable: (org.jboss.resourc
                e.JBossResourceException: Could not create connection; - nested throwable: (java
                .sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connect
                ion refused: connect))
                I Depend On:
                jboss.jca:name=PortalDS,service=DataSourceBinding
                Depends On Me:
                portal:container=Instance


                Why is that coming??

                • 20. Re: from hibernate to sybase
                  prabhat.jha

                  That's something you have to figure out on your side. Do you have firewall blocking this? Is sybase running on that port? Can you see that port being used?

                  • 21. Re: from hibernate to sybase
                    sonalk.

                    hello,
                    There is some progress. Now i can connect to the database but when I type in the url localhost:8080/portal/portal then I can see the 1st page of login and all, But when I try to login it gives Null pointer exception.
                    Why is that coming? IS it bcoz the tables are not getting created properly ??
                    Thanks.

                    • 22. Re: from hibernate to sybase
                      sonalk.


                      To support of my previous reply....

                      This is what i m getting as an error----------


                      13:01:20,017 WARN [JDBCExceptionReporter] SQL Error: 2706, SQLState: 42W33
                      13:01:20,017 ERROR [JDBCExceptionReporter] ASA Error -141: Table 'JBP_INSTANCE'
                      not found
                      13:01:20,017 ERROR [PortletAppDeployment] Error when creating instances
                      org.hibernate.exception.SQLGrammarException: could not execute query
                      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
                      ava:67)
                      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
                      er.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.ja
                      va: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.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.j
                      ava:780)
                      at org.jboss.portal.core.impl.model.instance.PersistentInstanceContainer
                      .lookupNoCache(PersistentInstanceContainer.java:544)
                      at org.jboss.portal.core.impl.model.instance.PersistentInstanceContainer
                      .lookup(PersistentInstanceContainer.java:508)
                      at org.jboss.portal.core.impl.model.instance.PersistentInstanceContainer
                      .org$jboss$portal$core$impl$model$instance$PersistentInstanceContainer$getDefini
                      tion$aop(PersistentInstanceContainer.java:250)
                      at org.jboss.portal.core.impl.model.instance.PersistentInstanceContainer
                      $getDefinition_7158034184799190936.invokeNext(PersistentInstanceContainer$getDef
                      inition_7158034184799190936.java)
                      at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)
                      at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java
                      :195)
                      at org.jboss.portal.core.impl.model.instance.PersistentInstanceContainer
                      $getDefinition_7158034184799190936.invokeNext(PersistentInstanceContainer$getDef
                      inition_7158034184799190936.java)
                      at org.jboss.portal.core.impl.model.instance.PersistentInstanceContainer
                      .getDefinition(PersistentInstanceContainer.java)
                      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
                      java:39)
                      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
                      sorImpl.java:25)
                      at java.lang.reflect.Method.invoke(Method.java:324)
                      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
                      er.java:155)
                      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractIntercept
                      or.java:133)
                      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelM
                      BeanOperationInterceptor.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 $Proxy105.getDefinition(Unknown Source)
                      at org.jboss.portal.core.deployment.jboss.PortletAppDeployment.org$jboss
                      $portal$core$deployment$jboss$PortletAppDeployment$handleInstance$aop(PortletApp
                      Deployment.java:381)
                      at org.jboss.portal.core.deployment.jboss.PortletAppDeployment.access$1(
                      PortletAppDeployment.java)
                      at org.jboss.portal.core.deployment.jboss.PortletAppDeployment$handleIns
                      tance_2257800355530988303.invokeNext(PortletAppDeployment$handleInstance_2257800
                      355530988303.java)
                      at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
                      at org.jboss.aspects.tx.TxInterceptor$RequiresNew.invoke(TxInterceptor.j
                      ava:262)
                      at org.jboss.portal.core.deployment.jboss.PortletAppDeployment$handleIns
                      tance_2257800355530988303.invokeNext(PortletAppDeployment$handleInstance_2257800
                      355530988303.java)
                      at org.jboss.portal.core.deployment.jboss.PortletAppDeployment.handleIns
                      tance(PortletAppDeployment.java)
                      at org.jboss.portal.core.deployment.jboss.PortletAppDeployment.createIns
                      tances(PortletAppDeployment.java:340)
                      at org.jboss.portal.core.deployment.jboss.PortletAppDeployment.buildInst
                      ances(PortletAppDeployment.java:322)
                      at org.jboss.portal.core.deployment.jboss.PortletAppDeployment.start(Por
                      tletAppDeployment.java:99)
                      at org.jboss.portal.server.deployment.jboss.DeploymentContext.start(Depl
                      oymentContext.java:99)
                      at org.jboss.portal.server.deployment.jboss.PortalDeploymentInfoContext.
                      start(PortalDeploymentInfoContext.java:211)
                      at org.jboss.portal.server.deployment.jboss.ServerDeployer.start(ServerD
                      eployer.java:217)
                      at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
                      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
                      at sun.reflect.GeneratedMethodAccessor241.invoke(Unknown Source)
                      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
                      sorImpl.java:25)
                      at java.lang.reflect.Method.invoke(Method.java:324)
                      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
                      er.java:155)
                      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractIntercept
                      or.java:133)
                      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelM
                      BeanOperationInterceptor.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 $Proxy146.deploy(Unknown Source)
                      at org.jboss.portal.server.deployment.jboss.ServerDeployer.deploy(Server
                      Deployer.java:259)
                      at sun.reflect.GeneratedMethodAccessor247.invoke(Unknown Source)
                      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
                      sorImpl.java:25)
                      at java.lang.reflect.Method.invoke(Method.java:324)
                      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
                      er.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 $Proxy115.deploy(Unknown Source)
                      at org.jboss.portal.server.deployment.WebAppAdapter.deploy(WebAppAdapter
                      .java:54)
                      at org.jboss.portal.server.deployment.WebAppIntercepter.handleNotificati
                      on(WebAppIntercepter.java:160)
                      at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
                      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
                      sorImpl.java:25)
                      at java.lang.reflect.Method.invoke(Method.java:324)
                      at org.jboss.mx.notification.NotificationListenerProxy.invoke(Notificati
                      onListenerProxy.java:153)
                      at $Proxy148.handleNotification(Unknown Source)
                      at org.jboss.mx.util.JBossNotificationBroadcasterSupport.handleNotificat
                      ion(JBossNotificationBroadcasterSupport.java:127)
                      at org.jboss.mx.util.JBossNotificationBroadcasterSupport.sendNotificatio
                      n(JBossNotificationBroadcasterSupport.java:108)
                      at org.jboss.deployment.SubDeployerSupport.emitNotification(SubDeployerS
                      upport.java:340)
                      at org.jboss.deployment.SubDeployerSupport.start(SubDeployerSupport.java
                      :308)
                      at org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java:48
                      2)
                      at sun.reflect.GeneratedMethodAccessor97.invoke(Unknown Source)
                      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
                      sorImpl.java:25)
                      at java.lang.reflect.Method.invoke(Method.java:324)
                      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
                      er.java:155)
                      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractIntercept
                      or.java:133)
                      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelM
                      BeanOperationInterceptor.java:142)
                      at org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor
                      .java:97)
                      at org.jboss.system.InterceptorServiceMBeanSupport.invokeNext(Intercepto
                      rServiceMBeanSupport.java:238)
                      at org.jboss.ws.integration.jboss.DeployerInterceptor.start(DeployerInte
                      rceptor.java:92)
                      at org.jboss.deployment.SubDeployerInterceptorSupport$XMBeanInterceptor.
                      start(SubDeployerInterceptorSupport.java:188)
                      at org.jboss.deployment.SubDeployerInterceptor.invoke(SubDeployerInterce
                      ptor.java:95)
                      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 $Proxy132.start(Unknown Source)
                      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.GeneratedMethodAccessor27.invoke(Unknown Source)
                      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
                      sorImpl.java:25)
                      at java.lang.reflect.Method.invoke(Method.java:324)
                      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
                      er.java:155)
                      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractIntercept
                      or.java:133)
                      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelM
                      BeanOperationInterceptor.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(URLDeploymen
                      tScanner.java:421)
                      at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentS
                      canner.java:634)
                      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.
                      doScan(AbstractDeploymentScanner.java:263)
                      at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(A
                      bstractDeploymentScanner.java:336)
                      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanS
                      upport.java:289)
                      at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMB
                      eanSupport.java:245)
                      at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
                      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
                      sorImpl.java:25)
                      at java.lang.reflect.Method.invoke(Method.java:324)
                      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
                      er.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(ServiceControl
                      ler.java:978)
                      at $Proxy0.start(Unknown Source)
                      at org.jboss.system.ServiceController.start(ServiceController.java:417)
                      at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source)
                      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
                      sorImpl.java:25)
                      at java.lang.reflect.Method.invoke(Method.java:324)
                      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
                      er.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(DelegatingMethodAcces
                      sorImpl.java:25)
                      at java.lang.reflect.Method.invoke(Method.java:324)
                      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
                      er.java:155)
                      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractIntercept
                      or.java:133)
                      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelM
                      BeanOperationInterceptor.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:536)
                      Caused by: com.sybase.jdbc2.jdbc.SybSQLException: ASA Error -141: Table 'JBP_INS
                      TANCE' not found
                      at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:3178)
                      at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2481)
                      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:1611)
                      at com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:159
                      6)
                      at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeQuery(SybPreparedSt
                      atement.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(Lo
                      ader.java:224)
                      at org.hibernate.loader.Loader.doList(Loader.java:2144)
                      ... 166 more

                      • 23. Re: from hibernate to sybase
                        sonalk.

                        Hello,
                        All tables are not getting created when first time after creating database I'm starting the server. Thats why I am not able to log in. Why is this problem coming?

                        • 24. Re: from hibernate to sybase
                          prabhat.jha

                          Do you see any error in server\default\log\server.log related to not being able to create a table?

                          I think with syabse, hinbernate many not be picking up dialect correctly. Please try explicitly forcing hibernate dialect in all hibernate.cfg.xml files under jboss-portal.sar. See http://jira.jboss.com/jira/browse/JBPORTAL-304 for more info. I hope this helps.

                          • 25. Re: from hibernate to sybase
                            sonalk.


                            Hi
                            this error is coming in the server.log file when i m trying to login.
                            What does this mean. In my database i could see 26 tables. How many are required??

                            2007-06-12 12:57:59,890 ERROR [org.jboss.portal.server.servlet.PortalServlet] Unexpected exception
                            java.lang.NullPointerException
                            at org.jboss.portal.core.impl.model.CustomizationManagerService.getDashboard(CustomizationManagerService.java:259)
                            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:324)
                            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 $Proxy90.getDashboard(Unknown Source)
                            at org.jboss.portal.core.aspects.controller.PageCustomizerInterceptor.injectDashboardNav(PageCustomizerInterceptor.java:210)
                            at org.jboss.portal.core.aspects.controller.PageCustomizerInterceptor.invoke(PageCustomizerInterceptor.java:135)
                            at org.jboss.portal.core.controller.ControllerInterceptor.invoke(ControllerInterceptor.java:38)
                            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                            at org.jboss.portal.core.aspects.controller.PolicyEnforcementInterceptor.invoke(PolicyEnforcementInterceptor.java:69)
                            at org.jboss.portal.core.controller.ControllerInterceptor.invoke(ControllerInterceptor.java:38)
                            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                            at org.jboss.portal.core.aspects.controller.node.PortalNodeInterceptor.invoke(PortalNodeInterceptor.java:81)
                            at org.jboss.portal.core.controller.ControllerInterceptor.invoke(ControllerInterceptor.java:38)
                            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                            at org.jboss.portal.core.aspects.controller.NavigationalStateInterceptor.invoke(NavigationalStateInterceptor.java:42)
                            at org.jboss.portal.core.controller.ControllerInterceptor.invoke(ControllerInterceptor.java:38)
                            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                            at org.jboss.portal.core.controller.ajax.AjaxInterceptor.invoke(AjaxInterceptor.java:51)
                            at org.jboss.portal.core.controller.ControllerInterceptor.invoke(ControllerInterceptor.java:38)
                            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                            at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:157)
                            at org.jboss.portal.core.controller.ControllerContext.execute(ControllerContext.java:121)
                            at org.jboss.portal.core.model.portal.PortalObjectResponseHandler.processCommandResponse(PortalObjectResponseHandler.java:63)
                            at org.jboss.portal.core.controller.classic.ClassicResponseHandler.processHandlers(ClassicResponseHandler.java:96)
                            at org.jboss.portal.core.controller.classic.ClassicResponseHandler.processCommandResponse(ClassicResponseHandler.java:70)
                            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:324)
                            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 $Proxy81.processCommandResponse(Unknown Source)
                            at org.jboss.portal.core.controller.handler.ResponseHandlerSelector.processCommandResponse(ResponseHandlerSelector.java:72)
                            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:324)
                            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 $Proxy92.processCommandResponse(Unknown Source)
                            at org.jboss.portal.core.controller.Controller.processCommandResponse(Controller.java:264)
                            at org.jboss.portal.core.controller.Controller.processCommand(Controller.java:252)
                            at org.jboss.portal.core.controller.Controller.handle(Controller.java:213)
                            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:324)
                            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 $Proxy93.handle(Unknown Source)
                            at org.jboss.portal.server.RequestControllerDispatcher.invoke(RequestControllerDispatcher.java:51)
                            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:131)
                            at org.jboss.portal.server.aspects.server.ContentTypeInterceptor.invoke(ContentTypeInterceptor.java:68)
                            at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
                            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                            at org.jboss.portal.core.aspects.server.LocaleInterceptor.invoke(LocaleInterceptor.java:93)
                            at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
                            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                            at org.jboss.portal.core.aspects.server.UserInterceptor.invoke(UserInterceptor.java:245)
                            at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
                            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                            at org.jboss.portal.server.aspects.server.SessionInvalidatorInterceptor.invoke(SessionInvalidatorInterceptor.java:84)
                            at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
                            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                            at org.jboss.portal.core.impl.api.user.UserEventInterceptor.invoke(UserEventInterceptor.java:63)
                            at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
                            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                            at org.jboss.portal.core.aspects.server.TransactionInterceptor.org$jboss$portal$core$aspects$server$TransactionInterceptor$invoke$aop(TransactionInterceptor.java:49)
                            at org.jboss.portal.core.aspects.server.TransactionInterceptor$invoke_N5143606530999904530.invokeNext(TransactionInterceptor$invoke_N5143606530999904530.java)
                            at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
                            at org.jboss.aspects.tx.TxInterceptor$RequiresNew.invoke(TxInterceptor.java:262)
                            at org.jboss.portal.core.aspects.server.TransactionInterceptor$invoke_N5143606530999904530.invokeNext(TransactionInterceptor$invoke_N5143606530999904530.java)
                            at org.jboss.portal.core.aspects.server.TransactionInterceptor.invoke(TransactionInterceptor.java)
                            at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
                            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                            at org.jboss.portal.server.aspects.LockInterceptor$InternalLock.invoke(LockInterceptor.java:70)
                            at org.jboss.portal.server.aspects.LockInterceptor.invoke(LockInterceptor.java:131)
                            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                            at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:157)
                            at org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:380)
                            at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
                            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
                            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
                            at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
                            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
                            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
                            at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
                            at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
                            at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
                            at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
                            at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
                            at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
                            at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
                            at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
                            at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
                            at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
                            at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
                            at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
                            at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
                            at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
                            at java.lang.Thread.run(Thread.java:536)
                            2007-06-12 12:57:59,906 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/portal].[PortalServletWithPathMapping]] Servlet.service() for servlet PortalServletWithPathMapping threw exception
                            java.lang.NullPointerException
                            at org.jboss.portal.core.impl.model.CustomizationManagerService.getDashboard(CustomizationManagerService.java:259)
                            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:324)
                            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 $Proxy90.getDashboard(Unknown Source)
                            at org.jboss.portal.core.aspects.controller.PageCustomizerInterceptor.injectDashboardNav(PageCustomizerInterceptor.java:210)
                            at org.jboss.portal.core.aspects.controller.PageCustomizerInterceptor.invoke(PageCustomizerInterceptor.java:135)
                            at org.jboss.portal.core.controller.ControllerInterceptor.invoke(ControllerInterceptor.java:38)
                            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                            at org.jboss.portal.core.aspects.controller.PolicyEnforcementInterceptor.invoke(PolicyEnforcementInterceptor.java:69)
                            at org.jboss.portal.core.controller.ControllerInterceptor.invoke(ControllerInterceptor.java:38)
                            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                            at org.jboss.portal.core.aspects.controller.node.PortalNodeInterceptor.invoke(PortalNodeInterceptor.java:81)
                            at org.jboss.portal.core.controller.ControllerInterceptor.invoke(ControllerInterceptor.java:38)
                            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                            at org.jboss.portal.core.aspects.controller.NavigationalStateInterceptor.invoke(NavigationalStateInterceptor.java:42)
                            at org.jboss.portal.core.controller.ControllerInterceptor.invoke(ControllerInterceptor.java:38)
                            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                            at org.jboss.portal.core.controller.ajax.AjaxInterceptor.invoke(AjaxInterceptor.java:51)
                            at org.jboss.portal.core.controller.ControllerInterceptor.invoke(ControllerInterceptor.java:38)
                            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                            at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:157)
                            at org.jboss.portal.core.controller.ControllerContext.execute(ControllerContext.java:121)
                            at org.jboss.portal.core.model.portal.PortalObjectResponseHandler.processCommandResponse(PortalObjectResponseHandler.java:63)
                            at org.jboss.portal.core.controller.classic.ClassicResponseHandler.processHandlers(ClassicResponseHandler.java:96)
                            at org.jboss.portal.core.controller.classic.ClassicResponseHandler.processCommandResponse(ClassicResponseHandler.java:70)
                            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:324)
                            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 $Proxy81.processCommandResponse(Unknown Source)
                            at org.jboss.portal.core.controller.handler.ResponseHandlerSelector.processCommandResponse(ResponseHandlerSelector.java:72)
                            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:324)
                            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 $Proxy92.processCommandResponse(Unknown Source)
                            at org.jboss.portal.core.controller.Controller.processCommandResponse(Controller.java:264)
                            at org.jboss.portal.core.controller.Controller.processCommand(Controller.java:252)
                            at org.jboss.portal.core.controller.Controller.handle(Controller.java:213)
                            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:324)
                            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 $Proxy93.handle(Unknown Source)
                            at org.jboss.portal.server.RequestControllerDispatcher.invoke(RequestControllerDispatcher.java:51)
                            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:131)
                            at org.jboss.portal.server.aspects.server.ContentTypeInterceptor.invoke(ContentTypeInterceptor.java:68)
                            at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
                            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                            at org.jboss.portal.core.aspects.server.LocaleInterceptor.invoke(LocaleInterceptor.java:93)
                            at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
                            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                            at org.jboss.portal.core.aspects.server.UserInterceptor.invoke(UserInterceptor.java:245)
                            at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
                            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                            at org.jboss.portal.server.aspects.server.SessionInvalidatorInterceptor.invoke(SessionInvalidatorInterceptor.java:84)
                            at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
                            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                            at org.jboss.portal.core.impl.api.user.UserEventInterceptor.invoke(UserEventInterceptor.java:63)
                            at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
                            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                            at org.jboss.portal.core.aspects.server.TransactionInterceptor.org$jboss$portal$core$aspects$server$TransactionInterceptor$invoke$aop(TransactionInterceptor.java:49)
                            at org.jboss.portal.core.aspects.server.TransactionInterceptor$invoke_N5143606530999904530.invokeNext(TransactionInterceptor$invoke_N5143606530999904530.java)
                            at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
                            at org.jboss.aspects.tx.TxInterceptor$RequiresNew.invoke(TxInterceptor.java:262)
                            at org.jboss.portal.core.aspects.server.TransactionInterceptor$invoke_N5143606530999904530.invokeNext(TransactionInterceptor$invoke_N5143606530999904530.java)
                            at org.jboss.portal.core.aspects.server.TransactionInterceptor.invoke(TransactionInterceptor.java)
                            at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
                            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                            at org.jboss.portal.server.aspects.LockInterceptor$InternalLock.invoke(LockInterceptor.java:70)
                            at org.jboss.portal.server.aspects.LockInterceptor.invoke(LockInterceptor.java:131)
                            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                            at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:157)
                            at org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:380)
                            at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
                            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
                            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
                            at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
                            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
                            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
                            at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
                            at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
                            at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
                            at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
                            at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
                            at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
                            at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
                            at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
                            at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
                            at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
                            at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
                            at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
                            at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
                            at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
                            at java.lang.Thread.run(Thread.java:536)

                            Thanks.

                            • 26. Re: from hibernate to sybase
                              mputz

                              You are definitely missing some tables. No use in trying to login before the db schema is set up properly.

                              I'd suggest to clean your database by deleting all tables first. Then follow Prabhats last advice to force Hibernate to use the Sybase dialect by changing this in all hibernate.cfg.xml files you find in jboss-portal.sar. Try to start up with this changes and review the log after that, looking for errors related to tables not being created.

                              • 27. Re: from hibernate to sybase
                                sonalk.


                                In all hibernate.cfg.xml files I have already made an entry of dialect.

                                I have tried both the dialect properties
                                1 : org.hibernate.dialect.SybaseAnywhereDialect
                                2: org.hibernate.dialect.SybaseDialect

                                These errors are coming after that only.

                                • 28. Re: from hibernate to sybase
                                  mputz

                                  ok. have you checked the log which tables were not created?

                                  also, have you looked at the jira issue related to sybase already linked to by Prabhat: http://jira.jboss.com/jira/browse/JBPORTAL-304? You might have the same problem.

                                  • 29. Re: from hibernate to sybase
                                    sonalk.


                                    Could not create table with SQL: CREATE CACHED TABLE JMS_MESSAGES ( MESSAGEID INTEGER NOT NULL, DESTINATION VARCHAR(255) NOT NULL, TXID INTEGER, TXOP CHAR(1), MESSAGEBLOB OBJECT, PRIMARY KEY (MESSAGEID, DESTINATION) )

                                    Could not create table with SQL: CREATE CACHED TABLE JMS_TRANSACTIONS ( TXID INTEGER, PRIMARY KEY (TXID) )

                                    Yes i have checked that post which Prabhat is saying but it did not work.