Mondrian postgres connection fail

johnf · 2023-06-09 17:01:02

I'm getting a this error, "SQLException: No suitable driver found for jdbc:postgres://localhost:5432/logs_test" when trying to connect to a postgres DB for a mondrian datasource. The connection I set up directly to the postgres server with the same url, username and password works fine.

postgres connection:

Database: postgresql (from dropdown)
Username: postgres
URL: jdbc:postgresql://localhost:5432/logs_test

mondrian connection:

Username: postgres
URL: jdbc:mondrian:Jdbc=jdbc:postgres://localhost:5432/logs_test

Properties:
type=OLAP
name=logs
driver=mondrian.olap4j.MondrianOlap4jDriver
jdbcDrivers=org.postgresql.Driver

schema: test cube made from pentaho schema workbench

Here is the error details:
net.datenwerke.rs.adminutils.client.datasourcetester.ConnectionTestFailedException: Connection test failed in datasource "logs": Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:postgres://localhost:5432/logs_test; JdbcUser=postgres
 at net.datenwerke.rs.saiku.service.saiku.OlapUtilServiceImpl.testConnection(OlapUtilServiceImpl.java:613)
 at net.datenwerke.rs.saiku.server.rest.SaikuRpcServiceImpl.testConnection(SaikuRpcServiceImpl.java:137)
 at net.datenwerke.rs.saiku.server.rest.SaikuRpcServiceImpl$$EnhancerByGuice$$1748744172.GUICE$TRAMPOLINE(<generated>)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:74)
 at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:64)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:75)
 at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:112)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:75)
 at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:75)
 at com.google.inject.internal.InterceptorStackCallback.invoke(InterceptorStackCallback.java:55)
 at net.datenwerke.rs.saiku.server.rest.SaikuRpcServiceImpl$$EnhancerByGuice$$1748744172.testConnection(<generated>)
 at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.base/java.lang.reflect.Method.invoke(Method.java:566)
 at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:587)
 at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:333)
 at net.datenwerke.rs.saiku.server.rest.SaikuRpcServiceImpl$$EnhancerByGuice$$1748744172.GUICE$TRAMPOLINE(<generated>)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:74)
 at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:112)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:75)
 at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:75)
 at com.google.inject.internal.InterceptorStackCallback.invoke(InterceptorStackCallback.java:55)
 at net.datenwerke.rs.saiku.server.rest.SaikuRpcServiceImpl$$EnhancerByGuice$$1748744172.processCall(<generated>)
 at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:303)
 at net.datenwerke.rs.saiku.server.rest.SaikuRpcServiceImpl$$EnhancerByGuice$$1748744172.GUICE$TRAMPOLINE(<generated>)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:74)
 at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:112)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:75)
 at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:75)
 at com.google.inject.internal.InterceptorStackCallback.invoke(InterceptorStackCallback.java:55)
 at net.datenwerke.rs.saiku.server.rest.SaikuRpcServiceImpl$$EnhancerByGuice$$1748744172.processCall(<generated>)
 at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:373)
 at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:555)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
 at net.datenwerke.rs.saiku.server.rest.SaikuRpcServiceImpl$$EnhancerByGuice$$1748744172.GUICE$TRAMPOLINE(<generated>)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:74)
 at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:112)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:75)
 at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:75)
 at com.google.inject.internal.InterceptorStackCallback.invoke(InterceptorStackCallback.java:55)
 at net.datenwerke.rs.saiku.server.rest.SaikuRpcServiceImpl$$EnhancerByGuice$$1748744172.service(<generated>)
 at com.google.inject.servlet.ServletDefinition.doServiceImpl(ServletDefinition.java:290)
 at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:280)
 at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:184)
 at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:89)
 at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:85)
 at com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:94)
 at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:82)
 at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:121)
 at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:133)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
 at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:673)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
 at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390)
 at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
 at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926)
 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
 at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
 at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
 at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
 at java.base/java.lang.Thread.run(Thread.java:834)
 Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:postgres://localhost:5432/logs_test; JdbcUser=postgres
 at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:1002)
 at mondrian.olap.Util.newInternal(Util.java:2486)
 at mondrian.olap.Util.newError(Util.java:2502)
 at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:245)
 at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:188)
 at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:216)
 at mondrian.rolap.RolapSchemaPool.createRolapSchema(RolapSchemaPool.java:295)
 at mondrian.rolap.RolapSchemaPool.getByKey(RolapSchemaPool.java:228)
 at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:167)
 at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:73)
 at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:161)
 at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:93)
 at mondrian.olap.DriverManager.getConnection(DriverManager.java:113)
 at mondrian.olap.DriverManager.getConnection(DriverManager.java:69)
 at mondrian.olap4j.MondrianOlap4jConnection.<init>(MondrianOlap4jConnection.java:165)
 at mondrian.olap4j.FactoryJdbc4Plus$AbstractConnection.<init>(FactoryJdbc4Plus.java:323)
 at mondrian.olap4j.FactoryJdbc41Impl$MondrianOlap4jConnectionJdbc41.<init>(FactoryJdbc41Impl.java:118)
 at mondrian.olap4j.FactoryJdbc41Impl.newConnection(FactoryJdbc41Impl.java:32)
 at mondrian.olap4j.MondrianOlap4jDriver.connect(MondrianOlap4jDriver.java:97)
 at net.datenwerke.rs.saiku.service.saiku.OlapUtilServiceImpl.getOlapConnection(OlapUtilServiceImpl.java:343)
 at net.datenwerke.rs.saiku.service.saiku.OlapUtilServiceImpl.testConnection(OlapUtilServiceImpl.java:609)
 ... 74 more
 Caused by: java.sql.SQLException: No suitable driver found for jdbc:postgres://localhost:5432/logs_test
 at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:702)
 at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189)
 at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:78)
 at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
 at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1188)
 at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
 at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:227)
 ... 91 more

eduardo · 2023-06-12 08:05:33

Hi johnf,

can you pls post a screenshot of your general info here: administration -> system console -> general info

you can use http://imgbb.com for this.

Regards,
Eduardo

johnf · 2023-06-12 12:10:55

Hi Eduardo,

here are screenshots of the general info,

Thanks,
John

https://ibb.co/54WTyxX
https://ibb.co/jbVk08V
https://ibb.co/25qFfmQ

johnf · 2023-06-12 12:19:34

Sorry,

I found my issue. I was using jdbc:mondrian:Jdbc=jdbc:postgres instead of jdbc:mondrian:Jdbc=jdbc:postgresql.

Thanks.

ReportServer Forum

#1 2023-06-09 17:01:02

Mondrian postgres connection fail

#2 2023-06-12 08:05:33

Re: Mondrian postgres connection fail

#3 2023-06-12 12:10:55

Re: Mondrian postgres connection fail

#4 2023-06-12 12:19:34

Re: Mondrian postgres connection fail

Board footer