2 Replies Latest reply on Nov 21, 2006 5:57 AM by Jan Francsi

    How to connect to an extern Oracle Database?

    Jan Francsi Newbie

      Hello,

      I am about to begin the programming of a portlet. It should get some adressbook data out of an extern oracle Database.

      Here comes the problem:
      Connection in standard Java is easy, but if I try to use the same code inside a portlet, it comes with a nice long error code.

      Can any one please tell me how to establishe this connection?

      Here is the code of the connection class:

      import java.sql.Connection;
      import java.sql.DriverManager;
      import java.sql.ResultSet;
      import java.sql.Statement;


      public class dbConnection {

      public String getConnection() {
      try {
      DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
      String sDriverName = "jdbc:oracle:thin:@127.0.0.1:1522:XE";
      Connection connection = DriverManager.getConnection(sDriverName, "HR", "hr");
      connection.setAutoCommit(false);
      Statement statement = connection.createStatement();
      String sSQL = "select FIRST_NAME from EMPLOYEES where LAST_NAME = 'Patel'";
      ResultSet result = statement.executeQuery(sSQL);
      return "done";
      } catch(Exception e){
      return "error";
      }

      }

      }

      And here is the error message:

      org.jboss.portal.core.command.CommandException: org.jboss.portal.portlet.PortletInvokerException: javax.servlet.ServletException: Servlet execution threw an exception
      at org.jboss.portal.core.command.RenderWindowCommand.execute(RenderWindowCommand.java:118)
      at org.jboss.portal.core.command.ControllerCommand.dispatch(ControllerCommand.java:91)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:140)
      at org.jboss.portal.core.aspects.controller.EventBroadcasterInterceptor.invoke(EventBroadcasterInterceptor.java:171)
      at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.aspects.controller.PageNavigationInterceptor.invoke(PageNavigationInterceptor.java:80)
      at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.aspects.controller.PolicyEnforcementInterceptor.invoke(PolicyEnforcementInterceptor.java:79)
      at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.aspects.controller.PortalNodeInterceptor.invoke(PortalNodeInterceptor.java:59)
      at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:171)
      at org.jboss.portal.core.command.CommandContext.execute(CommandContext.java:102)
      at org.jboss.portal.core.command.ExecutionContext.execute(ExecutionContext.java:91)
      at org.jboss.portal.core.command.CommandContext.chain(CommandContext.java:148)
      at org.jboss.portal.core.command.MarkupCommand.renderPortletWindow(MarkupCommand.java:463)
      at org.jboss.portal.core.command.RenderPageCommand.renderFragments(RenderPageCommand.java:76)
      at org.jboss.portal.core.command.MarkupCommand.execute(MarkupCommand.java:340)
      at org.jboss.portal.core.command.ControllerCommand.dispatch(ControllerCommand.java:91)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:140)
      at org.jboss.portal.core.aspects.controller.EventBroadcasterInterceptor.invoke(EventBroadcasterInterceptor.java:171)
      at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.aspects.controller.PageNavigationInterceptor.invoke(PageNavigationInterceptor.java:80)
      at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.aspects.controller.PolicyEnforcementInterceptor.invoke(PolicyEnforcementInterceptor.java:79)
      at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.aspects.controller.PortalNodeInterceptor.invoke(PortalNodeInterceptor.java:59)
      at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:171)
      at org.jboss.portal.core.command.CommandContext.execute(CommandContext.java:102)
      at org.jboss.portal.core.command.ExecutionContext.execute(ExecutionContext.java:91)
      at org.jboss.portal.core.command.ExecutionContext.execute(ExecutionContext.java:78)
      at org.jboss.portal.core.CoreController.handle(CoreController.java:126)
      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.JMXInvocationHandler.invoke(JMXInvocationHandler.java:287)
      at $Proxy139.handle(Unknown Source)
      at org.jboss.portal.server.ServerInvocation.dispatch(ServerInvocation.java:79)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:140)
      at org.jboss.portal.server.aspects.server.NavigationInterceptor.invoke(NavigationInterceptor.java:64)
      at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.server.aspects.server.ContentTypeInterceptor.invoke(ContentTypeInterceptor.java:65)
      at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.aspects.server.LocaleInterceptor.invoke(LocaleInterceptor.java:74)
      at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.aspects.server.UserInterceptor.invoke(UserInterceptor.java:174)
      at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.server.aspects.server.SessionInvalidatorInterceptor.invoke(SessionInvalidatorInterceptor.java:92)
      at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      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:275)
      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:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:171)
      at org.jboss.portal.server.servlet.PortalServlet.process(PortalServlet.java:294)
      at org.jboss.portal.server.servlet.PortalServlet.doGet(PortalServlet.java:172)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
      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:432)
      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.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:595)
      org.jboss.portal.portlet.PortletInvokerException: javax.servlet.ServletException: Servlet execution threw an exception
      at org.jboss.portal.portlet.aspects.portlet.ContextDispatcherInterceptor.invoke(ContextDispatcherInterceptor.java:89)
      at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.portlet.aspects.portlet.ContextTrackerInterceptor.invoke(ContextTrackerInterceptor.java:50)
      at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.portlet.aspects.portlet.SecureTransportInterceptor.invoke(SecureTransportInterceptor.java:65)
      at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.portlet.aspects.portlet.ValveInterceptor.invoke(ValveInterceptor.java:61)
      at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:171)
      at org.jboss.portal.portlet.container.PortletContainerInvoker.invoke(PortletContainerInvoker.java:114)
      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 $Proxy61.invoke(Unknown Source)
      at org.jboss.portal.portlet.state.producer.StatefulPortletInvoker.invoke(StatefulPortletInvoker.java:249)
      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 $Proxy63.invoke(Unknown Source)
      at org.jboss.portal.federation.impl.FederatedPortletInvokerService.invoke(FederatedPortletInvokerService.java:139)
      at org.jboss.portal.federation.impl.FederatingPortletInvokerService.invoke(FederatingPortletInvokerService.java:155)
      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 $Proxy65.invoke(Unknown Source)
      at org.jboss.portal.portlet.test.TestPortletInvoker$1.dispatch(TestPortletInvoker.java:63)
      at org.jboss.portal.portlet.invocation.PortletInvocation.dispatch(PortletInvocation.java:242)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:140)
      at org.jboss.portal.portlet.aspects.portlet.PortalSessionSynchronizationInterceptor.invoke(PortalSessionSynchronizationInterceptor.java:85)
      at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.portlet.aspects.portlet.ConsumerCacheInterceptor.invoke(ConsumerCacheInterceptor.java:93)
      at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.model.instance.InstanceSecurityInterceptor.invoke(InstanceSecurityInterceptor.java:83)
      at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:171)
      at org.jboss.portal.portlet.test.TestPortletInvoker.invoke(TestPortletInvoker.java:123)
      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 $Proxy47.invoke(Unknown Source)
      at org.jboss.portal.core.impl.model.instance.InstanceImpl.invoke(InstanceImpl.java:273)
      at org.jboss.portal.core.command.RenderWindowCommand.execute(RenderWindowCommand.java:108)
      at org.jboss.portal.core.command.ControllerCommand.dispatch(ControllerCommand.java:91)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:140)
      at org.jboss.portal.core.aspects.controller.EventBroadcasterInterceptor.invoke(EventBroadcasterInterceptor.java:171)
      at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.aspects.controller.PageNavigationInterceptor.invoke(PageNavigationInterceptor.java:80)
      at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.aspects.controller.PolicyEnforcementInterceptor.invoke(PolicyEnforcementInterceptor.java:79)
      at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.aspects.controller.PortalNodeInterceptor.invoke(PortalNodeInterceptor.java:59)
      at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:171)
      at org.jboss.portal.core.command.CommandContext.execute(CommandContext.java:102)
      at org.jboss.portal.core.command.ExecutionContext.execute(ExecutionContext.java:91)
      at org.jboss.portal.core.command.CommandContext.chain(CommandContext.java:148)
      at org.jboss.portal.core.command.MarkupCommand.renderPortletWindow(MarkupCommand.java:463)
      at org.jboss.portal.core.command.RenderPageCommand.renderFragments(RenderPageCommand.java:76)
      at org.jboss.portal.core.command.MarkupCommand.execute(MarkupCommand.java:340)
      at org.jboss.portal.core.command.ControllerCommand.dispatch(ControllerCommand.java:91)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:140)
      at org.jboss.portal.core.aspects.controller.EventBroadcasterInterceptor.invoke(EventBroadcasterInterceptor.java:171)
      at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.aspects.controller.PageNavigationInterceptor.invoke(PageNavigationInterceptor.java:80)
      at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.aspects.controller.PolicyEnforcementInterceptor.invoke(PolicyEnforcementInterceptor.java:79)
      at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.aspects.controller.PortalNodeInterceptor.invoke(PortalNodeInterceptor.java:59)
      at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:171)
      at org.jboss.portal.core.command.CommandContext.execute(CommandContext.java:102)
      at org.jboss.portal.core.command.ExecutionContext.execute(ExecutionContext.java:91)
      at org.jboss.portal.core.command.ExecutionContext.execute(ExecutionContext.java:78)
      at org.jboss.portal.core.CoreController.handle(CoreController.java:126)
      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.JMXInvocationHandler.invoke(JMXInvocationHandler.java:287)
      at $Proxy139.handle(Unknown Source)
      at org.jboss.portal.server.ServerInvocation.dispatch(ServerInvocation.java:79)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:140)
      at org.jboss.portal.server.aspects.server.NavigationInterceptor.invoke(NavigationInterceptor.java:64)
      at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.server.aspects.server.ContentTypeInterceptor.invoke(ContentTypeInterceptor.java:65)
      at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.aspects.server.LocaleInterceptor.invoke(LocaleInterceptor.java:74)
      at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.aspects.server.UserInterceptor.invoke(UserInterceptor.java:174)
      at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.server.aspects.server.SessionInvalidatorInterceptor.invoke(SessionInvalidatorInterceptor.java:92)
      at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      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:275)
      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:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:171)
      at org.jboss.portal.server.servlet.PortalServlet.process(PortalServlet.java:294)
      at org.jboss.portal.server.servlet.PortalServlet.doGet(PortalServlet.java:172)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
      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:432)
      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.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:595)
      javax.servlet.ServletException: Servlet execution threw an exception
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:275)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
      at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:539)
      at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499)
      at org.jboss.portal.portlet.impl.spi.AbstractRequestContext.include(AbstractRequestContext.java:193)
      at org.jboss.portal.portlet.aspects.portlet.ContextDispatcherInterceptor$1.include(ContextDispatcherInterceptor.java:68)
      at org.jboss.portal.server.servlet.CommandServlet.include(CommandServlet.java:84)
      at org.jboss.portal.portlet.aspects.portlet.ContextDispatcherInterceptor.invoke(ContextDispatcherInterceptor.java:74)
      at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.portlet.aspects.portlet.ContextTrackerInterceptor.invoke(ContextTrackerInterceptor.java:50)
      at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.portlet.aspects.portlet.SecureTransportInterceptor.invoke(SecureTransportInterceptor.java:65)
      at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.portlet.aspects.portlet.ValveInterceptor.invoke(ValveInterceptor.java:61)
      at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:171)
      at org.jboss.portal.portlet.container.PortletContainerInvoker.invoke(PortletContainerInvoker.java:114)
      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 $Proxy61.invoke(Unknown Source)
      at org.jboss.portal.portlet.state.producer.StatefulPortletInvoker.invoke(StatefulPortletInvoker.java:249)
      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 $Proxy63.invoke(Unknown Source)
      at org.jboss.portal.federation.impl.FederatedPortletInvokerService.invoke(FederatedPortletInvokerService.java:139)
      at org.jboss.portal.federation.impl.FederatingPortletInvokerService.invoke(FederatingPortletInvokerService.java:155)
      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 $Proxy65.invoke(Unknown Source)
      at org.jboss.portal.portlet.test.TestPortletInvoker$1.dispatch(TestPortletInvoker.java:63)
      at org.jboss.portal.portlet.invocation.PortletInvocation.dispatch(PortletInvocation.java:242)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:140)
      at org.jboss.portal.portlet.aspects.portlet.PortalSessionSynchronizationInterceptor.invoke(PortalSessionSynchronizationInterceptor.java:85)
      at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.portlet.aspects.portlet.ConsumerCacheInterceptor.invoke(ConsumerCacheInterceptor.java:93)
      at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.model.instance.InstanceSecurityInterceptor.invoke(InstanceSecurityInterceptor.java:83)
      at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:171)
      at org.jboss.portal.portlet.test.TestPortletInvoker.invoke(TestPortletInvoker.java:123)
      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 $Proxy47.invoke(Unknown Source)
      at org.jboss.portal.core.impl.model.instance.InstanceImpl.invoke(InstanceImpl.java:273)
      at org.jboss.portal.core.command.RenderWindowCommand.execute(RenderWindowCommand.java:108)
      at org.jboss.portal.core.command.ControllerCommand.dispatch(ControllerCommand.java:91)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:140)
      at org.jboss.portal.core.aspects.controller.EventBroadcasterInterceptor.invoke(EventBroadcasterInterceptor.java:171)
      at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.aspects.controller.PageNavigationInterceptor.invoke(PageNavigationInterceptor.java:80)
      at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.aspects.controller.PolicyEnforcementInterceptor.invoke(PolicyEnforcementInterceptor.java:79)
      at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.aspects.controller.PortalNodeInterceptor.invoke(PortalNodeInterceptor.java:59)
      at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:171)
      at org.jboss.portal.core.command.CommandContext.execute(CommandContext.java:102)
      at org.jboss.portal.core.command.ExecutionContext.execute(ExecutionContext.java:91)
      at org.jboss.portal.core.command.CommandContext.chain(CommandContext.java:148)
      at org.jboss.portal.core.command.MarkupCommand.renderPortletWindow(MarkupCommand.java:463)
      at org.jboss.portal.core.command.RenderPageCommand.renderFragments(RenderPageCommand.java:76)
      at org.jboss.portal.core.command.MarkupCommand.execute(MarkupCommand.java:340)
      at org.jboss.portal.core.command.ControllerCommand.dispatch(ControllerCommand.java:91)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:140)
      at org.jboss.portal.core.aspects.controller.EventBroadcasterInterceptor.invoke(EventBroadcasterInterceptor.java:171)
      at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.aspects.controller.PageNavigationInterceptor.invoke(PageNavigationInterceptor.java:80)
      at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.aspects.controller.PolicyEnforcementInterceptor.invoke(PolicyEnforcementInterceptor.java:79)
      at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.aspects.controller.PortalNodeInterceptor.invoke(PortalNodeInterceptor.java:59)
      at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:171)
      at org.jboss.portal.core.command.CommandContext.execute(CommandContext.java:102)
      at org.jboss.portal.core.command.ExecutionContext.execute(ExecutionContext.java:91)
      at org.jboss.portal.core.command.ExecutionContext.execute(ExecutionContext.java:78)
      at org.jboss.portal.core.CoreController.handle(CoreController.java:126)
      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.JMXInvocationHandler.invoke(JMXInvocationHandler.java:287)
      at $Proxy139.handle(Unknown Source)
      at org.jboss.portal.server.ServerInvocation.dispatch(ServerInvocation.java:79)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:140)
      at org.jboss.portal.server.aspects.server.NavigationInterceptor.invoke(NavigationInterceptor.java:64)
      at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.server.aspects.server.ContentTypeInterceptor.invoke(ContentTypeInterceptor.java:65)
      at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.aspects.server.LocaleInterceptor.invoke(LocaleInterceptor.java:74)
      at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.aspects.server.UserInterceptor.invoke(UserInterceptor.java:174)
      at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.server.aspects.server.SessionInvalidatorInterceptor.invoke(SessionInvalidatorInterceptor.java:92)
      at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      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:275)
      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:37)
      at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:171)
      at org.jboss.portal.server.servlet.PortalServlet.process(PortalServlet.java:294)
      at org.jboss.portal.server.servlet.PortalServlet.doGet(PortalServlet.java:172)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
      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:432)
      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.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:595)


      Thanks,
      Jan

        • 1. Re: How to connect to an extern Oracle Database?
          Peter Johnson Master

          Unfortunately, the exception stack trace gives no clue as to the root cause (there is usually as "caused by" stack trace following geneic exception such as "servlet threw exception".

          Regardless of that, I think that a different approach would be better. Try this. Create a *-ds.xml file that describes your data source. So all of the information you have regarding the driver name and connection would go there. Then change your code to do:

          InitialContext ic = new InitialContext();
          DataSource ds = (DataSource)ic.lookup("java:ds-jndi-name");
          Connection conn = ds.getConnection();

          where ds-jndi-name is the value of < jndi-name > in the *-ds.xml file.

          • 2. Re: How to connect to an extern Oracle Database?
            Jan Francsi Newbie

            Thanks...

            yes, that was the solution. Now I get my data out of the database.

            CYA,
            Jan