ReportServer Oracle OLAP

Ustinovdl · 2015-12-15 09:12:40

Hello!
Help me connect ReportServer to Oracle, please!
I started Tomcat.
I started the ReportServer.
I put in ojdbc oracle driver into tomcat\webapps\reportserver\WEB-INF\lib
I choose "Administration". Then - "Datasources". Click right button and click on the "Relational Database".
URL: 192.168.139.88:1521
name: reestr
Save and click "Test connection". Receive error - The connection test failed.
Error - Could not open connection to: 192.168.139.88:1521 with user: reestr. java.sql.SQLException: No suitable driver

net.datenwerke.rs.core.service.reportmanager.exceptions.DatabaseConnectionException: Could not open connection to: 192.168.139.88:1521 with user: reestr. java.sql.SQLException: No suitable driver
 at net.datenwerke.rs.base.service.datasources.table.transformers.DatabaseDatasourceTableTransformer.transform(DatabaseDatasourceTableTransformer.java:62)
 at net.datenwerke.rs.base.service.datasources.table.transformers.DatabaseDatasourceTableTransformer.transform(DatabaseDatasourceTableTransformer.java:1)
 at net.datenwerke.rs.core.service.datasourcemanager.datasourcetransformers.DatasourceDefinitionTransformerManager.transform(DatasourceDefinitionTransformerManager.java:49)
 at net.datenwerke.rs.base.service.reportengines.table.SimpleDataSupplier.getData(SimpleDataSupplier.java:118)
 at net.datenwerke.rs.base.service.reportengines.table.SimpleDataSupplier.getData(SimpleDataSupplier.java:113)
 at net.datenwerke.rs.base.service.reportengines.table.SimpleDataSupplier.getData(SimpleDataSupplier.java:105)
 at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl.testConnection(DatasourceTesterRPCServiceImpl.java:86)
 at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$3350407.CGLIB$testConnection$0(<generated>)
 at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$3350407$$FastClassByGuice$$1aedbcaf.invoke(<generated>)
 at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:66)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:110)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)
 at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$3350407.testConnection(<generated>)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:561)
 at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:208)
 at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$3350407.CGLIB$processCall$7(<generated>)
 at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$3350407$$FastClassByGuice$$1aedbcaf.invoke(<generated>)
 at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:110)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)
 at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$3350407.processCall(<generated>)
 at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)
 at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
 at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$3350407.CGLIB$service$13(<generated>)
 at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$3350407$$FastClassByGuice$$1aedbcaf.invoke(<generated>)
 at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:110)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)
 at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$3350407.service(<generated>)
 at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)
 at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)
 at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)
 at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)
 at com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:89)
 at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163)
 at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
 at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)
 at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
 at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:947)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
 at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1009)
 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
 at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1852)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
 at java.lang.Thread.run(Unknown Source)
 Caused by: java.lang.RuntimeException: java.sql.SQLException: No suitable driver
 at net.datenwerke.dbpool.DbC3p0PoolServiceImpl$1.get(DbC3p0PoolServiceImpl.java:158)
 at net.datenwerke.dbpool.DbC3p0PoolServiceImpl$1.get(DbC3p0PoolServiceImpl.java:1)
 at net.datenwerke.rs.base.service.datasources.table.transformers.DatabaseDatasourceTableTransformer.transform(DatabaseDatasourceTableTransformer.java:59)
 ... 73 more
 Caused by: java.sql.SQLException: No suitable driver
 at java.sql.DriverManager.getDriver(Unknown Source)
 at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:240)
 at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:146)
 at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:195)
 at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:211)
 at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086)
 at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)
 at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44)
 at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1810)
 at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648)

How I can to connect to database? Reportserver can independently create OLAP or he need to use any program which can do it?

Arno Mittelbach · 2015-12-15 11:22:47

Hi,

did you put the driver into WEB-INF/lib before or after you've started ReportServer? The driver will only be picked up, if it is there on startup.

Cheers
-Arno

Ustinovdl · 2015-12-15 11:43:57

Before. I have 32b driver. Maybe it's problem?

Ustinovdl · 2015-12-15 11:50:53

Can i use the added dsn?

Last edited by Ustinovdl (2015-12-15 11:51:45)

Arno Mittelbach · 2015-12-15 11:59:23

I missed this before, the URL is not correct. You need to specify a JDBC connection URL. (However, this only helps if ReportServer is able to pick up the database driver.)

The URL should have the following form (from the Oracle documentation):

The syntax for providing the host, port and SID is as follows:
jdbc:oracle:thin:@<hostname>:<port>:<sid>
For example, the following JDBC URL for the thin JDBC driver connects to my-pc.us.oracle.com on port 1521 with SID of orcl:
jdbc:oracle:thin:@my-pc.us.oracle.com:1521:orcl

Ustinovdl · 2015-12-15 12:43:12

Reportserver can independently create OLAP or he need to use any program which can do it?

Arno Mittelbach · 2015-12-15 12:54:08

I am not quite sure, I understand the question. ReportServer supports OLAP reporting via Mondrian. That is, you can create a Mondrian datasource which can then be used as the basis of OLAP reports. See, for example, the foodmart example contained with the demo data.

A different form of OLAP is provided by ReportServer's dynamic list, when you change it to Pivot mode.

Hope this helps.

Regards
-Arno

ReportServer Forum

#1 2015-12-15 09:12:40

ReportServer Oracle OLAP

#2 2015-12-15 11:22:47

Re: ReportServer Oracle OLAP

#3 2015-12-15 11:43:57

Re: ReportServer Oracle OLAP

#4 2015-12-15 11:50:53

Re: ReportServer Oracle OLAP

#5 2015-12-15 11:59:23

Re: ReportServer Oracle OLAP

#6 2015-12-15 12:43:12

Re: ReportServer Oracle OLAP

#7 2015-12-15 12:54:08

Re: ReportServer Oracle OLAP

Board footer