| Problem on BIRT viewer on Tomcat [message #249257] | 
Fri, 20 July 2007 21:03   | 
 
Eclipse User  | 
 | 
 | 
   | 
 
Originally posted by: mackingzone.gmail.com 
 
Hi all, 
 
I built a simple report to a jdbc data source(sql server) using the  
eclipse report designer, and now trying to view it through my web viewer.   
But I'm running into problems, Tomcat doesn't seem to allow the viewer to  
connect to the database.  Could anyone shed some lights? 
 
Here is how I deployed the BIRT viewer to my server. 
1) Downloaded the BIRT runtime 2.2 
2) Copy the entire 'WebViewerExample' to my <server>/webapps/ folder (not  
directly under Tomcat though, I modified the server.xml (within Tomcat) to  
point to the viewer (WebViewerExample). 
3) Although I already had my jdbc driver deployed on my server, I couldn't  
figure out how I can modify the classpath to include the jdbc drivers.   
Instead, I followed the instruction, and copied the jdbc drivers into  
< server/webapps/WebViewerExample/WEB-INF/platform/org.eclipse .birt.report.data.oda.jdbc_2.2.0.v20070615/drivers  
folder. 
4) I also modified the catalina.policy to grant the permission for the  
jdbc drivers. 
 
But after all these, I still seem to have problem getting it working  
properly.   
 
Here is the detail log. 
 
 Jul 20, 2007 3:23:37 PM 
org.eclipse.birt.data.engine.odaconsumer.ConnectionManager 
openConnection 
 SEVERE: Cannot open connection. 
 org.eclipse.birt.report.data.oda.jdbc.JDBCException: Failed to get  
connection. 
 SQL error #1: java.security.AccessControlExceptionaccess denied 
(java.net.SocketPermission xxx.0.0.1:1433 connect,resolve) 
 ; 
    com.inet.tds.l: java.security.AccessControlExceptionaccess denied 
(java.net.SocketPermission xxx.0.0.1:1433 connect,resolve) 
       at  
 org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUr l(Connection.java:154) 
       at  
 org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connec tion.java:111) 
       at  
 org.eclipse.datatools.connectivity.oda.consumer.helper.OdaCo nnection.open(OdaConnection.java:235) 
       at  
 org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o penConnection(ConnectionManager.java:149) 
       at  
 org.eclipse.birt.data.engine.executor.DataSource.newConnecti on(DataSource.java:134) 
       at  
 org.eclipse.birt.data.engine.executor.DataSource.open(DataSo urce.java:121) 
       at  
 org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiD ataSource(DataSourceRuntime.java:214) 
       at  
 org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSour ce(QueryExecutor.java:265) 
       at  
 org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu tion(QueryExecutor.java:210) 
       at  
 org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:486) 
       at  
 org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:161) 
       at  
 org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute (PreparedOdaDSQuery.java:142) 
       at  
 org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.execute(DataRequestSessionImpl.java:423) 
       at  
 org.eclipse.birt.report.engine.data.dte.DataGenerationEngine .doExecuteQuery(DataGenerationEngine.java:149) 
       at  
 org.eclipse.birt.report.engine.data.dte.DataGenerationEngine .doExecuteQuery(DataGenerationEngine.java:111) 
       at  
 org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:178) 
       at  
 org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1678) 
       at  
 org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:82) 
       at  
 org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:61) 
       at  
 org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportItemExecutor.execute(WrappedReportItemExecutor.java:4 5) 
       at  
 org.eclipse.birt.report.engine.internal.executor.emitter.Rep ortItemEmitterExecutor.execute(ReportItemEmitterExecutor.jav a:45) 
       at  
 org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportItemExecutor.execute(WrappedReportItemExecutor.java:4 5) 
       at  
 org.eclipse.birt.report.engine.internal.executor.dup.Suppres sDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor .java:42) 
       at  
 org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutChildren(HTMLBlockStackingLM.java:63) 
       at  
 org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:171) 
       at  
 org.eclipse.birt.report.engine.layout.html.HTMLInlineStackin gLM.resumeLayout(HTMLInlineStackingLM.java:94) 
       at  
 org.eclipse.birt.report.engine.layout.html.HTMLInlineStackin gLM.layoutChildren(HTMLInlineStackingLM.java:138) 
       at  
 org.eclipse.birt.report.engine.layout.html.HTMLRowLM.layoutC hildren(HTMLRowLM.java:41) 
       at  
 org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:171) 
       at  
 org.eclipse.birt.report.engine.layout.html.HTMLRowLM.layout( HTMLRowLM.java:31) 
       at  
 org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutChildren(HTMLBlockStackingLM.java:68) 
       at  
 org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layou tChildren(HTMLTableLM.java:81) 
       at  
 org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:171) 
       at  
 org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:142) 
       at  
 org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:84) 
       at  
 org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:90) 
       at  
 org.eclipse.birt.report.engine.presentation.ReportDocumentBu ilder.build(ReportDocumentBuilder.java:186) 
       at  
 org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTas k.java:227) 
       at  
 org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask. java:87) 
       at  
 org.eclipse.birt.report.service.ReportEngineService.runRepor t(Unknown 
Source) 
       at  
 org.eclipse.birt.report.service.BirtViewerReportService.runR eport(Unknown 
Source) 
       at  
 org.eclipse.birt.report.service.actionhandler.BirtRunReportA ctionHandler.__execute(Unknown 
Source) 
       at  
 org.eclipse.birt.report.service.actionhandler.BirtChangePara meterActionHandler.runReport(Unknown 
Source) 
       at  
 org.eclipse.birt.report.service.actionhandler.AbstractChange ParameterActionHandler.__execute(Unknown 
Source) 
       at  
 org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown 
Source) 
       at  
 org.eclipse.birt.report.soapengine.processor.AbstractBaseDoc umentProcessor.__executeAction(Unknown 
Source) 
       at  
 org.eclipse.birt.report.soapengine.processor.AbstractBaseCom ponentProcessor.executeAction(Unknown 
Source) 
       at  
 org.eclipse.birt.report.soapengine.processor.BirtDocumentPro cessor.handleChangeParameter(Unknown 
Source) 
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
       at  
 sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java:39) 
       at  
 sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:25) 
       at java.lang.reflect.Method.invoke(Method.java:585) 
       at  
 org.eclipse.birt.report.soapengine.processor.AbstractBaseCom ponentProcessor.process(Unknown 
Source) 
       at  
 org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingI mpl.getUpdatedObjects(Unknown 
Source) 
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
       at  
 sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java:39) 
       at  
 sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:25) 
       at java.lang.reflect.Method.invoke(Method.java:585) 
       at  
 org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCP rovider.java:397) 
       at  
 org.apache.axis.providers.java.RPCProvider.processMessage(RP CProvider.java:186) 
       at  
 org.apache.axis.providers.java.JavaProvider.invoke(JavaProvi der.java:323) 
       at  
 org.apache.axis.strategies.InvocationStrategy.visit(Invocati onStrategy.java:32) 
       at  org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) 
       at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) 
       at  
 org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService .java:453) 
       at  org.apache.axis.server.AxisServer.invoke(AxisServer.java:281 ) 
       at  
 org.apache.axis.transport.http.AxisServlet.doPost(AxisServle t.java:699) 
       at  
 org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherSer vlet.doPost(Unknown 
Source) 
       at  javax.servlet.http.HttpServlet.service(HttpServlet.java:709) 
       at  
 org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327) 
       at  javax.servlet.http.HttpServlet.service(HttpServlet.java:802) 
       at sun.reflect.GeneratedMethodAccessor208.invoke(Unknown Source) 
       at  
 sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:25) 
       at java.lang.reflect.Method.invoke(Method.java:585) 
       at  
 org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil .java:243) 
       at java.security.AccessController.doPrivileged(Native Method) 
       at  javax.security.auth.Subject.doAsPrivileged(Subject.java:517) 
       at  
 org.apache.catalina.security.SecurityUtil.execute(SecurityUt il.java:275) 
       at  
 org.apache.catalina.security.SecurityUtil.doAsPrivilege(Secu rityUtil.java:161) 
       at  
 org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:245) 
       at  
 org.apache.catalina.core.ApplicationFilterChain.access$000(A pplicationFilterChain.java:50) 
       at  
 org.apache.catalina.core.ApplicationFilterChain$1.run(Applic ationFilterChain.java:156) 
       at java.security.AccessController.doPrivileged(Native Method) 
       at  
 org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:152) 
       at  
 blackboard.platform.servlet.ContentTypeFilter.doFilter(Conte ntTypeFilter.java:56) 
       at sun.reflect.GeneratedMethodAccessor211.invoke(Unknown Source) 
       at  
 sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:25) 
       at java.lang.reflect.Method.invoke(Method.java:585) 
       at  
 org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil .java:243) 
       at java.security.AccessController.doPrivileged(Native Method) 
       at  javax.security.auth.Subject.doAsPrivileged(Subject.java:517) 
       at  
 org.apache.catalina.security.SecurityUtil.execute(SecurityUt il.java:275) 
       at  
 org.apache.catalina.security.SecurityUtil.doAsPrivilege(Secu rityUtil.java:217) 
       at  
 org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:197) 
       at  
 org.apache.catalina.core.ApplicationFilterChain.access$000(A pplicationFilterChain.java:50) 
       at  
 org.apache.catalina.core.ApplicationFilterChain$1.run(Applic ationFilterChain.java:156) 
       at java.security.AccessController.doPrivileged(Native Method) 
       at  
 org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:152) 
       at  
 blackboard.platform.servlet.RequestSessionFilter.handleReque st(RequestSessionFilter.java:314) 
       at  
 blackboard.platform.servlet.RequestSessionFilter.doFilter(Re questSessionFilter.java:152) 
       at sun.reflect.GeneratedMethodAccessor210.invoke(Unknown Source) 
       at  
 sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:25) 
       at java.lang.reflect.Method.invoke(Method.java:585) 
       at  
 org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil .java:243) 
       at java.security.AccessController.doPrivileged(Native Method) 
       at  javax.security.auth.Subject.doAsPrivileged(Subject.java:517) 
       at  
 org.apache.catalina.security.SecurityUtil.execute(SecurityUt il.java:275) 
       at  
 org.apache.catalina.security.SecurityUtil.doAsPrivilege(Secu rityUtil.java:217) 
       at  
 org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:197) 
       at  
 org.apache.catalina.core.ApplicationFilterChain.access$000(A pplicationFilterChain.java:50) 
       at  
 org.apache.catalina.core.ApplicationFilterChain$1.run(Applic ationFilterChain.java:156) 
       at java.security.AccessController.doPrivileged(Native Method) 
       at  
 org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:152) 
       at  
 org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213) 
       at  
 org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178) 
       at  
 org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126) 
       at  
 org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105) 
       at  
 org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107) 
       at  
 org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148) 
       at  
 org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler. java:199) 
       at  
 org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.ja va:282) 
       at  org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java :754) 
       at  
 org.apache.jk.common.ChannelSocket.processConnection(Channel Socket.java:684) 
       at  
 org.apache.jk.common.ChannelSocket$SocketConnection.runIt(Ch annelSocket.java:876) 
       at  
 org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:684) 
       at java.lang.Thread.run(Thread.java:595) 
 Caused by: com.inet.tds.l: java.security.AccessControlExceptionaccess 
denied (java.net.SocketPermission 127.0.0.1:1433 connect,resolve) 
       at com.inet.tds.w.createSQLException(Unknown Source) 
       at com.inet.tds.TdsDriver.a(Unknown Source) 
       at com.inet.tds.TdsDriver.connect(Unknown Source) 
       at  
 org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager$Wrap pedDriver.connect(JDBCDriverManager.java:787) 
       at  java.sql.DriverManager.getConnection(DriverManager.java:525) 
       at  java.sql.DriverManager.getConnection(DriverManager.java:140) 
       at  
 org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doCo nnect(JDBCDriverManager.java:185) 
       at  
 org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getC onnection(JDBCDriverManager.java:146) 
       at  
 org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUr l(Connection.java:150) 
       ... 125 more
 |  
 |  
  | 
| Re: Problem on BIRT viewer on Tomcat [message #249369 is a reply to message #249257] | 
Mon, 23 July 2007 11:10    | 
 
Eclipse User  | 
 | 
 | 
   | 
 
Originally posted by: jasonweathersby.alltel.net 
 
Ethan, 
 
This obviously looks like a permission problem. 
What did you modify in the catalina.policy? 
 
Jason 
 
Ethan T wrote: 
> Hi all, 
>  
> I built a simple report to a jdbc data source(sql server) using the  
> eclipse report designer, and now trying to view it through my web  
> viewer.  But I'm running into problems, Tomcat doesn't seem to allow the  
> viewer to connect to the database.  Could anyone shed some lights? 
>  
> Here is how I deployed the BIRT viewer to my server. 
> 1) Downloaded the BIRT runtime 2.2 
> 2) Copy the entire 'WebViewerExample' to my <server>/webapps/ folder  
> (not directly under Tomcat though, I modified the server.xml (within  
> Tomcat) to point to the viewer (WebViewerExample). 
> 3) Although I already had my jdbc driver deployed on my server, I  
> couldn't figure out how I can modify the classpath to include the jdbc  
> drivers.  Instead, I followed the instruction, and copied the jdbc  
> drivers into  
> < server/webapps/WebViewerExample/WEB-INF/platform/org.eclipse .birt.report.data.oda.jdbc_2.2.0.v20070615/drivers  
> folder. 
> 4) I also modified the catalina.policy to grant the permission for the  
> jdbc drivers. 
>  
> But after all these, I still seem to have problem getting it working  
> properly.  
> Here is the detail log. 
>  
> Jul 20, 2007 3:23:37 PM 
> org.eclipse.birt.data.engine.odaconsumer.ConnectionManager 
> openConnection 
> SEVERE: Cannot open connection. 
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: Failed to get  
> connection. 
> SQL error #1: java.security.AccessControlExceptionaccess denied 
> (java.net.SocketPermission xxx.0.0.1:1433 connect,resolve) 
> ; 
>    com.inet.tds.l: java.security.AccessControlExceptionaccess denied 
> (java.net.SocketPermission xxx.0.0.1:1433 connect,resolve) 
>       at  
>  org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUr l(Connection.java:154)  
>  
>       at  
>  org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connec tion.java:111) 
>       at  
>  org.eclipse.datatools.connectivity.oda.consumer.helper.OdaCo nnection.open(OdaConnection.java:235)  
>  
>       at  
>  org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o penConnection(ConnectionManager.java:149)  
>  
>       at  
>  org.eclipse.birt.data.engine.executor.DataSource.newConnecti on(DataSource.java:134)  
>  
>       at  
>  org.eclipse.birt.data.engine.executor.DataSource.open(DataSo urce.java:121) 
>       at  
>  org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiD ataSource(DataSourceRuntime.java:214)  
>  
>       at  
>  org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSour ce(QueryExecutor.java:265)  
>  
>       at  
>  org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu tion(QueryExecutor.java:210)  
>  
>       at  
>  org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:486)  
>  
>       at  
>  org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:161)  
>  
>       at  
>  org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute (PreparedOdaDSQuery.java:142)  
>  
>       at  
>  org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.execute(DataRequestSessionImpl.java:423)  
>  
>       at  
>  org.eclipse.birt.report.engine.data.dte.DataGenerationEngine .doExecuteQuery(DataGenerationEngine.java:149)  
>  
>       at  
>  org.eclipse.birt.report.engine.data.dte.DataGenerationEngine .doExecuteQuery(DataGenerationEngine.java:111)  
>  
>       at  
>  org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:178)  
>  
>       at  
>  org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1678)  
>  
>       at  
>  org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:82)  
>  
>       at  
>  org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:61)  
>  
>       at  
>  org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportItemExecutor.execute(WrappedReportItemExecutor.java:4 5)  
>  
>       at  
>  org.eclipse.birt.report.engine.internal.executor.emitter.Rep ortItemEmitterExecutor.execute(ReportItemEmitterExecutor.jav a:45)  
>  
>       at  
>  org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportItemExecutor.execute(WrappedReportItemExecutor.java:4 5)  
>  
>       at  
>  org.eclipse.birt.report.engine.internal.executor.dup.Suppres sDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor .java:42)  
>  
>       at  
>  org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutChildren(HTMLBlockStackingLM.java:63)  
>  
>       at  
>  org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:171)  
>  
>       at  
>  org.eclipse.birt.report.engine.layout.html.HTMLInlineStackin gLM.resumeLayout(HTMLInlineStackingLM.java:94)  
>  
>       at  
>  org.eclipse.birt.report.engine.layout.html.HTMLInlineStackin gLM.layoutChildren(HTMLInlineStackingLM.java:138)  
>  
>       at  
>  org.eclipse.birt.report.engine.layout.html.HTMLRowLM.layoutC hildren(HTMLRowLM.java:41)  
>  
>       at  
>  org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:171)  
>  
>       at  
>  org.eclipse.birt.report.engine.layout.html.HTMLRowLM.layout( HTMLRowLM.java:31)  
>  
>       at  
>  org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutChildren(HTMLBlockStackingLM.java:68)  
>  
>       at  
>  org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layou tChildren(HTMLTableLM.java:81)  
>  
>       at  
>  org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:171)  
>  
>       at  
>  org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:142)  
>  
>       at  
>  org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:84)  
>  
>       at  
>  org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:90)  
>  
>       at  
>  org.eclipse.birt.report.engine.presentation.ReportDocumentBu ilder.build(ReportDocumentBuilder.java:186)  
>  
>       at  
>  org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTas k.java:227) 
>       at  
>  org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask. java:87) 
>       at  
>  org.eclipse.birt.report.service.ReportEngineService.runRepor t(Unknown 
> Source) 
>       at  
>  org.eclipse.birt.report.service.BirtViewerReportService.runR eport(Unknown 
> Source) 
>       at  
>  org.eclipse.birt.report.service.actionhandler.BirtRunReportA ctionHandler.__execute(Unknown  
>  
> Source) 
>       at  
>  org.eclipse.birt.report.service.actionhandler.BirtChangePara meterActionHandler.runReport(Unknown  
>  
> Source) 
>       at  
>  org.eclipse.birt.report.service.actionhandler.AbstractChange ParameterActionHandler.__execute(Unknown  
>  
> Source) 
>       at  
>  org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown  
>  
> Source) 
>       at  
>  org.eclipse.birt.report.soapengine.processor.AbstractBaseDoc umentProcessor.__executeAction(Unknown  
>  
> Source) 
>       at  
>  org.eclipse.birt.report.soapengine.processor.AbstractBaseCom ponentProcessor.executeAction(Unknown  
>  
> Source) 
>       at  
>  org.eclipse.birt.report.soapengine.processor.BirtDocumentPro cessor.handleChangeParameter(Unknown  
>  
> Source) 
>       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
>       at  
>  sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java:39)  
>  
>       at  
>  sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:25)  
>  
>       at java.lang.reflect.Method.invoke(Method.java:585) 
>       at  
>  org.eclipse.birt.report.soapengine.processor.AbstractBaseCom ponentProcessor.process(Unknown  
>  
> Source) 
>       at  
>  org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingI mpl.getUpdatedObjects(Unknown  
>  
> Source) 
>       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
>       at  
>  sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java:39)  
>  
>       at  
>  sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:25)  
>  
>       at java.lang.reflect.Method.invoke(Method.java:585) 
>       at  
>  org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCP rovider.java:397)  
>  
>       at  
>  org.apache.axis.providers.java.RPCProvider.processMessage(RP CProvider.java:186)  
>  
>       at  
>  org.apache.axis.providers.java.JavaProvider.invoke(JavaProvi der.java:323) 
>       at  
>  org.apache.axis.strategies.InvocationStrategy.visit(Invocati onStrategy.java:32)  
>  
>       at  org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) 
>       at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) 
>       at  
>  org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService .java:453) 
>       at  org.apache.axis.server.AxisServer.invoke(AxisServer.java:281 ) 
>       at  
>  org.apache.axis.transport.http.AxisServlet.doPost(AxisServle t.java:699) 
>       at  
>  org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherSer vlet.doPost(Unknown  
>  
> Source) 
>       at  javax.servlet.http.HttpServlet.service(HttpServlet.java:709) 
>       at  
>  org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)  
>  
>       at  javax.servlet.http.HttpServlet.service(HttpServlet.java:802) 
>       at sun.reflect.GeneratedMethodAccessor208.invoke(Unknown Source) 
>       at  
>  sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:25)  
>  
>       at java.lang.reflect.Method.invoke(Method.java:585) 
>       at  
>  org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil .java:243) 
>       at java.security.AccessController.doPrivileged(Native Method) 
>       at  javax.security.auth.Subject.doAsPrivileged(Subject.java:517) 
>       at  
>  org.apache.catalina.security.SecurityUtil.execute(SecurityUt il.java:275) 
>       at  
>  org.apache.catalina.security.SecurityUtil.doAsPrivilege(Secu rityUtil.java:161)  
>  
>       at  
>  org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:245)  
>  
>       at  
>  org.apache.catalina.core.ApplicationFilterChain.access$000(A pplicationFilterChain.java:50)  
>  
>       at  
>  org.apache.catalina.core.ApplicationFilterChain$1.run(Applic ationFilterChain.java:156)  
>  
>       at java.security.AccessController.doPrivileged(Native Method) 
>       at  
>  org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:152)  
>  
>       at  
>  blackboard.platform.servlet.ContentTypeFilter.doFilter(Conte ntTypeFilter.java:56)  
>  
>       at sun.reflect.GeneratedMethodAccessor211.invoke(Unknown Source) 
>       at  
>  sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:25)  
>  
>       at java.lang.reflect.Method.invoke(Method.java:585) 
>       at  
>  org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil .java:243) 
>       at java.security.AccessController.doPrivileged(Native Method) 
>       at  javax.security.auth.Subject.doAsPrivileged(Subject.java:517) 
>       at  
>  org.apache.catalina.security.SecurityUtil.execute(SecurityUt il.java:275) 
>       at  
>  org.apache.catalina.security.SecurityUtil.doAsPrivilege(Secu rityUtil.java:217)  
>  
>       at  
>  org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:197)  
>  
>       at  
>  org.apache.catalina.core.ApplicationFilterChain.access$000(A pplicationFilterChain.java:50)  
>  
>       at  
>  org.apache.catalina.core.ApplicationFilterChain$1.run(Applic ationFilterChain.java:156)  
>  
>       at java.security.AccessController.doPrivileged(Native Method) 
>       at  
>  org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:152)  
>  
>       at  
>  blackboard.platform.servlet.RequestSessionFilter.handleReque st(RequestSessionFilter.java:314)  
>  
>       at  
>  blackboard.platform.servlet.RequestSessionFilter.doFilter(Re questSessionFilter.java:152)  
>  
>       at sun.reflect.GeneratedMethodAccessor210.invoke(Unknown Source) 
>       at  
>  sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:25)  
>  
>       at java.lang.reflect.Method.invoke(Method.java:585) 
>       at  
>  org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil .java:243) 
>       at java.security.AccessController.doPrivileged(Native Method) 
>       at  javax.security.auth.Subject.doAsPrivileged(Subject.java:517) 
>       at  
>  org.apache.catalina.security.SecurityUtil.execute(SecurityUt il.java:275) 
>       at  
>  org.apache.catalina.security.SecurityUtil.doAsPrivilege(Secu rityUtil.java:217)  
>  
>       at  
>  org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:197)  
>  
>       at  
>  org.apache.catalina.core.ApplicationFilterChain.access$000(A pplicationFilterChain.java:50)  
>  
>       at  
>  org.apache.catalina.core.ApplicationFilterChain$1.run(Applic ationFilterChain.java:156)  
>  
>       at java.security.AccessController.doPrivileged(Native Method) 
>       at  
>  org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:152)  
>  
>       at  
>  org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)  
>  
>       at  
>  org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)  
>  
>       at  
>  org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)  
>  
>       at  
>  org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)  
>  
>       at  
>  org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)  
>  
>       at  
>  org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148) 
>       at  
>  org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler. java:199) 
>       at  
>  org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.ja va:282) 
>       at  org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java :754) 
>       at  
>  org.apache.jk.common.ChannelSocket.processConnection(Channel Socket.java:684)  
>  
>       at  
>  org.apache.jk.common.ChannelSocket$SocketConnection.runIt(Ch annelSocket.java:876)  
>  
>       at  
>  org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:684)  
>  
>       at java.lang.Thread.run(Thread.java:595) 
> Caused by: com.inet.tds.l: java.security.AccessControlExceptionaccess 
> denied (java.net.SocketPermission 127.0.0.1:1433 connect,resolve) 
>       at com.inet.tds.w.createSQLException(Unknown Source) 
>       at com.inet.tds.TdsDriver.a(Unknown Source) 
>       at com.inet.tds.TdsDriver.connect(Unknown Source) 
>       at  
>  org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager$Wrap pedDriver.connect(JDBCDriverManager.java:787)  
>  
>       at  java.sql.DriverManager.getConnection(DriverManager.java:525) 
>       at  java.sql.DriverManager.getConnection(DriverManager.java:140) 
>       at  
>  org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doCo nnect(JDBCDriverManager.java:185)  
>  
>       at  
>  org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getC onnection(JDBCDriverManager.java:146)  
>  
>       at  
>  org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUr l(Connection.java:150)  
>  
>       ... 125 more 
>
 |  
 |  
  | 
 | 
| Re: Problem on BIRT viewer on Tomcat [message #249451 is a reply to message #249383] | 
Mon, 23 July 2007 19:45   | 
 
Eclipse User  | 
 | 
 | 
   | 
 
Originally posted by: jasonweathersby.alltel.net 
 
Ethan, 
 
Have you tried using localhost or the machinename instead of the ip address? 
 
Jason 
 
Ethan T wrote: 
>  
> Could you spot anything bad?  Thanks! 
>  
> grant codeBase "file:${app.home}/webapps/-" { 
>   permission java.security.AllPermission; 
> }; 
>  
> grant codeBase  
> " file:${app.home}/webapps/viewerEngine/WEB-INF/platform/plugi ns/org.eclipse.birt.report.data.oda.jdbc_2.2.0.v20070615/oda -jdbc.jar!/- "  
>  
> { 
>   permission java.security.AllPermission; 
>   permission java.net.SocketPermission "xxx.0.0.1:1433", "connect,resolve"; 
> }; 
>  
> grant codeBase  
> " file:${app.home}/webapps/viewerEngine/WEB-INF/platform/plugi ns/org.eclipse.birt.report.data.oda.jdbc_2.2.0.v20070615/dri vers/Merlia.jar!/- "  
>  
> { 
>   permission java.security.AllPermission; 
>   permission java.net.SocketPermission "xxx.0.0.1:1433", "connect,resolve"; 
> }; 
>  
> grant codeBase  
> " file:${app.home}/webapps/viewerEngine/WEB-INF/platform/plugi ns/org.eclipse.birt.report.data.oda.jdbc_2.2.0.v20070615/dri vers/ojdbc14.jar!/- "  
>  
> { 
>   permission java.security.AllPermission; 
>   permission java.net.SocketPermission "xxx.0.0.1:1433", "connect,resolve"; 
> }; 
>  
>  
>  
>
 |  
 |  
  | 
Powered by 
FUDForum. Page generated in 0.02833 seconds