ReportServer Forum

karolina

Member

Registered: 2014-08-09

cannot connect to Firebird datasource

Hello,

I started to test Reportserver and I tried to connect a firebird database as data source. I followed all the instructions described here

However, when I test a connection (or try to execute a query in a report that refers to this data source), I get:
Error
500 The call failed on the server; see server log for details Statuscode: 500 EncodedResponse: The call failed on the server; see server log for details

The log details from catalina.out:

Aug 11, 2014 12:07:32 AM net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor invoke
INFO: Intercepted NonFatalException
com.google.gwt.user.server.rpc.UnexpectedException: Service method 'public abstract boolean net.datenwerke.rs.adminutils.client.datasourcetester.rpc.DatasourceTesterRPCService.testConnection(net.datenwerke.rs.base.client.datasources.dto.DatabaseDatasourceDto) throws net.datenwerke.gxtdto.client.servercommunication.exceptions.ServerCallFailedException' threw an unexpected exception: java.lang.NoClassDefFoundError: javax/resource/ResourceException
    at com.google.gwt.user.server.rpc.RPC.encodeResponseForFailure(RPC.java:389)
    at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:579)
    at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:208)
    at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:110)
    at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
    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:641)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
    at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:110)
    at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
    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:225)
    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:168)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NoClassDefFoundError: javax/resource/ResourceException
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:190)
    at net.datenwerke.dbpool.DbC3p0PoolServiceImpl.createPool(DbC3p0PoolServiceImpl.java:183)
    at net.datenwerke.dbpool.DbC3p0PoolServiceImpl.getConnectionFromPool(DbC3p0PoolServiceImpl.java:122)
    at net.datenwerke.dbpool.DbC3p0PoolServiceImpl.getConnection(DbC3p0PoolServiceImpl.java:65)
    at net.datenwerke.dbpool.MetaPoolService.getConnection(MetaPoolService.java:98)
    at net.datenwerke.rs.base.service.datasources.table.transformers.DatabaseDatasourceTableTransformer.transform(DatabaseDatasourceTableTransformer.java:59)
    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 com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:66)
    at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:110)
    at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:561)
    ... 34 more
Caused by: java.lang.ClassNotFoundException: javax.resource.ResourceException
    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1711)
    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1556)
    ... 55 more

from localhost_access.log:

83.18.20.6 - - [11/Aug/2014:00:07:32 +0200] "POST /reportserver/reportserver/convenience_datasourcetester HTTP/1.1" 500 57

I tested connetions to this database using different fdb clients and they worked.

Any ideas how to fix it?

karolina

Thorsten J. Krause

datenwerke

Registered: 2012-02-15

Website

Re: cannot connect to Firebird datasource

Hi Karolina,

I can't test it myself right now, but from the error message I'd guess you missed the connector-api...jar file when copying the jaybird files to your WEB-INF/lib directory.

Cheers,
Thorsten

karolina

Member

Registered: 2014-08-09

Re: cannot connect to Firebird datasource

Thanks - It works now
BTW: adding jaybird-full-2.2.5.jar instead of jaybird-2.2.5.jar + connector-api.jar works too

Karolina