Estou tentando conectar o Pentaho Server a um banco de dados Firebird via JDBC com as configurações abaixo:
Generic Database - Native (JDBC)
Custom Connection URL: jdbc:firebirdsql:localhost/3050:banco\teste.FDB
Custom Driver Class Name: org.firebirdsql.jdbc.FBDriver
UserName: SYSDBA
Password: masterkey
Porém o banco não conecta e aparece o seguinte erro:
Sorry, something went wrong. Please try again or contact your system administrator.
Alguém poderia ajudar
Desde já agradeço a atenção,
Fred
Oii Frederico, tudo bem?
No Pentaho Data Integration a conexão está ok pelo JDBC? Se tiver como ver o log do TomCat também, lá pode indicar o que pode ser o erro.
Me avise qualquer coisa :)
Olá Maria, tudo bem e contigo?
Sim, a conexão com o PDI está funcionando perfeitamente, inclusive com o report-designer também funciona perfeitamente.
Segue o Log do Tom Cat: 16-Nov-2020 17:33:16.160 GRAVE [http-nio-8080-exec-1] com.sun.jersey.spi.container.ContainerResponse.mapMappableContainerException The exception contained within MappableContainerException could not be mapped to a response, re-throwing to the HTTP container java.lang.NoClassDefFoundError: Could not initialize class org.firebirdsql.gds.impl.GDSFactory at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:108) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) 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:1185) at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106) at org.pentaho.platform.plugin.services.connections.sql.SQLConnection.initDataSource(SQLConnection.java:585) at org.pentaho.platform.plugin.services.connections.sql.SQLConnection.connect(SQLConnection.java:600) at org.pentaho.platform.plugin.services.connections.sql.SQLConnection.setProperties(SQLConnection.java:111) at org.pentaho.platform.engine.services.connection.PentahoConnectionFactory.getConnection(PentahoConnectionFactory.java:126) at org.pentaho.platform.dataaccess.datasource.wizard.service.impl.ConnectionServiceImpl.testConnection(ConnectionServiceImpl.java:323) at org.pentaho.platform.dataaccess.datasource.wizard.service.impl.ConnectionService.testConnection(ConnectionService.java:240) 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.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205) at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at ...
tive que cortar a parte final para aceitar a msg
Mais uma vez, Grato pela atenção
Fred