ReportServer Forum

sveinp

Member

Registered: 2013-05-23

ReportServer & PostgreSQL

Hi.

I have just started to look at ReportServer, downloaded it last night and now I am playing around a bit. It looks very promising, thank you for making it available.

We use PostgreSQL 9.2. I am having difficulties defining Dynamic Lists. The error seems to be "Cannot change transaction read-only property in the middle of a transaction" - Stacktrace:

May 23, 2013 11:40:14 AM net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor invoke
INFO: Intercepted NonFatalException
net.datenwerke.rs.core.service.reportmanager.exceptions.DatabaseConnectionException: Could not close connection.
        at net.datenwerke.rs.base.service.datasources.table.impl.TableDBDataSource.close(TableDBDataSource.java:333)
        at net.datenwerke.rs.base.service.reportengines.table.SimpleDataSupplier.getData(SimpleDataSupplier.java:418)
        at net.datenwerke.rs.base.service.reportengines.table.SimpleDataSupplier.getData(SimpleDataSupplier.java:391)
        at net.datenwerke.rs.base.service.reportengines.table.SimpleDataSupplier.getColumnNames(SimpleDataSupplier.java:314)
        at net.datenwerke.rs.base.server.datasources.BaseDatasourceRpcServiceImpl.loadColumnDefinition(BaseDatasourceRpcServiceImpl.java:117)
        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(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.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:637)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        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:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: Cannot change transaction read-only property in the middle of a transaction.
        at org.postgresql.jdbc2.AbstractJdbc2Connection.setReadOnly(AbstractJdbc2Connection.java:617)
        at com.jolbox.bonecp.ConnectionHandle.setReadOnly(ConnectionHandle.java:1279)
        at com.jolbox.bonecp.ConnectionHandle.<init>(ConnectionHandle.java:254)
        at com.jolbox.bonecp.ConnectionHandle.recreateConnectionHandle(ConnectionHandle.java:273)
        at com.jolbox.bonecp.ConnectionHandle.close(ConnectionHandle.java:476)
        at net.datenwerke.rs.base.service.datasources.table.impl.TableDBDataSource.close(TableDBDataSource.java:331)

Svein

Thorsten J. Krause

Guest

Re: ReportServer & PostgreSQL

Hi Svein,

it seems we broke something in our transaction handling when using postgres.
For now, you can disable connection pooling to work around this.

To do so, edit the file reportserver.properties (in the WEB-INF/classes directory) and set the property

    rs.db.useconnectionpool
   
to false.

We will fix this as soon as possible; I think a new version will be available tomorrow.

Cheers,
Thorsten

sveinp

Member

Registered: 2013-05-23

Re: ReportServer & PostgreSQL

Thank you, that worked

Thorsten J. Krause

Guest

Re: ReportServer & PostgreSQL

Hi,

the bug has been fixed and the patched version (4836) is being uploaded to sourceforge right now.

Cheers,
Thorsten