Options

Run a simple remote process

RomanocryRomanocry Member Posts: 7 Contributor II
edited November 2018 in Help
Hello,

I'm a french engineer starting with RapidAnalytics.

I just try to run a simple remote process from RapidMiner and I get this error message :
com.rapidminer.operator.UserError: Cannot retrieve repository data from entry '//_LOCAL/home/romain/Golf-Testset'. Reason: Cannot stream example set from table es_186: java.sql.SQLFeatureNotSupportedException: Method is not implemented by JDBC driver.

When I browse my data table in RapidAnalytics, I access meta datas but if I try to download datas, I get this :
A server error 500 occurred: javax.servlet.ServletException: Error retrieving data: de.rapidanalytics.entity.RepositoryException: Cannot stream example set from table es_186: java.sql.SQLFeatureNotSupportedException: Method is not implemented by JDBC driver. The error has been recorded.

When I "Show database drivers" on RapidMiner, everyting seems to be ok


Any idea ?

Thank you for your help,
Best regards,

My config :
- Windows 7 x64
- PostgresSQL 9.1
Tagged:

Answers

  • Options
    RomanocryRomanocry Member Posts: 7 Contributor II
    Hello,

    I still have the same problem.
    Does anyone have a solution ?

    Best regards,
  • Options
    fischerfischer Member Posts: 439 Maven
    Hi,

    that's because you are probably using an old JDBC driver. What RA version are you using? We have actually built a workaround for this already, and it should be in the latest release. If it still persists with the latest release, could you post the respective section from server\default\log\server.log when the error occurs?

    Best,
    Simon
  • Options
    RomanocryRomanocry Member Posts: 7 Contributor II
    Hello,

    Thx for your response.
    I try to reinstall RA and stil have the same problem.

    I have RM 5.2.001 & RA 1.2
    I use postgresql-9.1-901.jdbc3.jar driver given with the RA installer

    Here is the error message I get when I try to open a datatable from RM : 

    2012-03-22 16:28:20,011 INFO  [de.rapidanalytics.entity.IOObjectVersion] (http-127.0.0.1-8080-7) Streaming es_184.
    2012-03-22 16:28:20,054 WARNING [de.rapidanalytics.entity.IOObjectVersion] (http-127.0.0.1-8080-7) Cannot stream example set: java.sql.SQLFeatureNotSupportedException: Method is not implemented by JDBC driver: java.sql.SQLFeatureNotSupportedException: Method is not implemented by JDBC driver
    	at org.jboss.resource.adapter.jdbc.WrappedConnection.checkException(WrappedConnection.java:875) [:6.0.0.Final]
    	at org.jboss.resource.adapter.jdbc.WrappedStatement.checkException(WrappedStatement.java:852) [:6.0.0.Final]
    	at org.jboss.resource.adapter.jdbc.WrappedResultSet.checkException(WrappedResultSet.java:1947) [:6.0.0.Final]
    	at org.jboss.resource.adapter.jdbc.jdk6.WrappedResultSetJDK6.isClosed(WrappedResultSetJDK6.java:202) [:6.0.0.Final]
    	at com.rapidminer.example.db.ExampleSetToDB$SubTable.readNextRow(ExampleSetToDB.java:312) [:]
    	at com.rapidminer.example.db.ExampleSetToDB$SubTable.access$8(ExampleSetToDB.java:311) [:]
    	at com.rapidminer.example.db.ExampleSetToDB.streamData(ExampleSetToDB.java:835) [:]
    	at com.rapidminer.example.db.ExampleSetToDB.streamTo(ExampleSetToDB.java:797) [:]
    	at de.rapidanalytics.entity.IOObjectVersion.streamData(IOObjectVersion.java:269) [:]
    	at de.rapidanalytics.web.servlet.AccessEntry.doGet(AccessEntry.java:135) [:]
    	at de.rapidanalytics.web.servlet.EntryServlet.doGet(EntryServlet.java:79) [:]
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) [:1.0.0.Final]
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [:1.0.0.Final]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:324) [:6.0.0.Final]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242) [:6.0.0.Final]
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:312) [:3.1.0.M2]
    	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116) [:3.1.0.M2]
    	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) [:3.1.0.M2]
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) [:3.1.0.M2]
    	at de.rapidanalytics.web.filter.auth.SpringEJBAuthorizationFilter.doFilter(SpringEJBAuthorizationFilter.java:86) [:]
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) [:3.1.0.M2]
    	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:95) [:3.1.0.M2]
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) [:3.1.0.M2]
    	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:79) [:3.1.0.M2]
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) [:3.1.0.M2]
    	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) [:3.1.0.M2]
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) [:3.1.0.M2]
    	at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:170) [:3.1.0.M2]
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) [:3.1.0.M2]
    	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80) [:3.1.0.M2]
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) [:3.1.0.M2]
    	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:165) [:3.1.0.M2]
    	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237) [:3.0.5.RELEASE]
    	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) [:3.0.5.RELEASE]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:274) [:6.0.0.Final]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242) [:6.0.0.Final]
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [:6.0.0.Final]
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) [:6.0.0.Final]
    	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:181) [:6.0.0.Final]
    	at org.jboss.modcluster.catalina.CatalinaContext$RequestListenerValve.event(CatalinaContext.java:285) [:1.1.0.Final]
    	at org.jboss.modcluster.catalina.CatalinaContext$RequestListenerValve.invoke(CatalinaContext.java:261) [:1.1.0.Final]
    	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:88) [:6.0.0.Final]
    	at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:100) [:6.0.0.Final]
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) [:6.0.0.Final]
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [:6.0.0.Final]
    	at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158) [:6.0.0.Final]
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [:6.0.0.Final]
    	at org.jboss.web.tomcat.service.request.ActiveRequestResponseCacheValve.invoke(ActiveRequestResponseCacheValve.java:53) [:6.0.0.Final]
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362) [:6.0.0.Final]
    	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [:6.0.0.Final]
    	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:654) [:6.0.0.Final]
    	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:951) [:6.0.0.Final]
    	at java.lang.Thread.run(Thread.java:662) [:1.6.0_31]
    Caused by: java.lang.AbstractMethodError: org.postgresql.jdbc3.Jdbc3ResultSet.isClosed()Z
    	at org.jboss.resource.adapter.jdbc.jdk6.WrappedResultSetJDK6.isClosed(WrappedResultSetJDK6.java:198) [:6.0.0.Final]
    	... 49 more

    2012-03-22 16:28:20,063 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/RAWS].[de.rapidanalytics.web.servlet.AccessEntry]] (http-127.0.0.1-8080-7) "Servlet.service()" pour la servlet de.rapidanalytics.web.servlet.AccessEntry a généré une exception: java.io.IOException: Cannot stream example set: java.sql.SQLFeatureNotSupportedException: Method is not implemented by JDBC driver
    	at de.rapidanalytics.entity.IOObjectVersion.streamData(IOObjectVersion.java:272) [:]
    	at de.rapidanalytics.web.servlet.AccessEntry.doGet(AccessEntry.java:135) [:]
    	at de.rapidanalytics.web.servlet.EntryServlet.doGet(EntryServlet.java:79) [:]
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) [:1.0.0.Final]
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [:1.0.0.Final]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:324) [:6.0.0.Final]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242) [:6.0.0.Final]
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:312) [:3.1.0.M2]
    	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116) [:3.1.0.M2]
    	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) [:3.1.0.M2]
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) [:3.1.0.M2]
    	at de.rapidanalytics.web.filter.auth.SpringEJBAuthorizationFilter.doFilter(SpringEJBAuthorizationFilter.java:86) [:]
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) [:3.1.0.M2]
    	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:95) [:3.1.0.M2]
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) [:3.1.0.M2]
    	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:79) [:3.1.0.M2]
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) [:3.1.0.M2]
    	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) [:3.1.0.M2]
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) [:3.1.0.M2]
    	at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:170) [:3.1.0.M2]
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) [:3.1.0.M2]
    	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80) [:3.1.0.M2]
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) [:3.1.0.M2]
    	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:165) [:3.1.0.M2]
    	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237) [:3.0.5.RELEASE]
    	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) [:3.0.5.RELEASE]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:274) [:6.0.0.Final]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242) [:6.0.0.Final]
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [:6.0.0.Final]
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) [:6.0.0.Final]
    	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:181) [:6.0.0.Final]
    	at org.jboss.modcluster.catalina.CatalinaContext$RequestListenerValve.event(CatalinaContext.java:285) [:1.1.0.Final]
    	at org.jboss.modcluster.catalina.CatalinaContext$RequestListenerValve.invoke(CatalinaContext.java:261) [:1.1.0.Final]
    	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:88) [:6.0.0.Final]
    	at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:100) [:6.0.0.Final]
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) [:6.0.0.Final]
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [:6.0.0.Final]
    	at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158) [:6.0.0.Final]
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [:6.0.0.Final]
    	at org.jboss.web.tomcat.service.request.ActiveRequestResponseCacheValve.invoke(ActiveRequestResponseCacheValve.java:53) [:6.0.0.Final]
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362) [:6.0.0.Final]
    	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [:6.0.0.Final]
    	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:654) [:6.0.0.Final]
    	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:951) [:6.0.0.Final]
    	at java.lang.Thread.run(Thread.java:662) [:1.6.0_31]
    Caused by: java.sql.SQLFeatureNotSupportedException: Method is not implemented by JDBC driver
    	at org.jboss.resource.adapter.jdbc.WrappedConnection.checkException(WrappedConnection.java:875) [:6.0.0.Final]
    	at org.jboss.resource.adapter.jdbc.WrappedStatement.checkException(WrappedStatement.java:852) [:6.0.0.Final]
    	at org.jboss.resource.adapter.jdbc.WrappedResultSet.checkException(WrappedResultSet.java:1947) [:6.0.0.Final]
    	at org.jboss.resource.adapter.jdbc.jdk6.WrappedResultSetJDK6.isClosed(WrappedResultSetJDK6.java:202) [:6.0.0.Final]
    	at com.rapidminer.example.db.ExampleSetToDB$SubTable.readNextRow(ExampleSetToDB.java:312) [:]
    	at com.rapidminer.example.db.ExampleSetToDB$SubTable.access$8(ExampleSetToDB.java:311) [:]
    	at com.rapidminer.example.db.ExampleSetToDB.streamData(ExampleSetToDB.java:835) [:]
    	at com.rapidminer.example.db.ExampleSetToDB.streamTo(ExampleSetToDB.java:797) [:]
    	at de.rapidanalytics.entity.IOObjectVersion.streamData(IOObjectVersion.java:269) [:]
    	... 44 more
    Caused by: java.lang.AbstractMethodError: org.postgresql.jdbc3.Jdbc3ResultSet.isClosed()Z
    	at org.jboss.resource.adapter.jdbc.jdk6.WrappedResultSetJDK6.isClosed(WrappedResultSetJDK6.java:198) [:6.0.0.Final]
    	... 49 more

  • Options
    RomanocryRomanocry Member Posts: 7 Contributor II
    Here is the error message I get when I try to download datas from RA : 
    2012-03-22 16:33:50,789 WARNING [de.rapidanalytics.web.servlet.AccessEntry] (http-127.0.0.1-8080-7) Error retrieving data: de.rapidanalytics.entity.RepositoryException: Cannot stream example set from table es_184: java.sql.SQLFeatureNotSupportedException: Method is not implemented by JDBC driver: de.rapidanalytics.entity.RepositoryException: Cannot stream example set from table es_184: java.sql.SQLFeatureNotSupportedException: Method is not implemented by JDBC driver
    	at de.rapidanalytics.entity.IOObjectVersion.retrieveExampleSet(IOObjectVersion.java:170) [:]
    	at de.rapidanalytics.web.servlet.AccessEntry.getIOObject(AccessEntry.java:282) [:]
    	at de.rapidanalytics.web.servlet.AccessEntry.doGet(AccessEntry.java:141) [:]
    	at de.rapidanalytics.web.servlet.EntryServlet.doGet(EntryServlet.java:79) [:]
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) [:1.0.0.Final]
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [:1.0.0.Final]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:324) [:6.0.0.Final]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242) [:6.0.0.Final]
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:312) [:3.1.0.M2]
    	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116) [:3.1.0.M2]
    	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) [:3.1.0.M2]
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) [:3.1.0.M2]
    	at de.rapidanalytics.web.filter.auth.SpringEJBAuthorizationFilter.doFilter(SpringEJBAuthorizationFilter.java:86) [:]
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) [:3.1.0.M2]
    	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:95) [:3.1.0.M2]
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) [:3.1.0.M2]
    	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100) [:3.1.0.M2]
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) [:3.1.0.M2]
    	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:79) [:3.1.0.M2]
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) [:3.1.0.M2]
    	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) [:3.1.0.M2]
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) [:3.1.0.M2]
    	at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35) [:3.1.0.M2]
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) [:3.1.0.M2]
    	at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187) [:3.1.0.M2]
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) [:3.1.0.M2]
    	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) [:3.1.0.M2]
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) [:3.1.0.M2]
    	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80) [:3.1.0.M2]
    	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) [:3.1.0.M2]
    	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:165) [:3.1.0.M2]
    	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237) [:3.0.5.RELEASE]
    	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) [:3.0.5.RELEASE]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:274) [:6.0.0.Final]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242) [:6.0.0.Final]
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [:6.0.0.Final]
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) [:6.0.0.Final]
    	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:181) [:6.0.0.Final]
    	at org.jboss.modcluster.catalina.CatalinaContext$RequestListenerValve.event(CatalinaContext.java:285) [:1.1.0.Final]
    	at org.jboss.modcluster.catalina.CatalinaContext$RequestListenerValve.invoke(CatalinaContext.java:261) [:1.1.0.Final]
    	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:88) [:6.0.0.Final]
    	at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:100) [:6.0.0.Final]
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) [:6.0.0.Final]
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [:6.0.0.Final]
    	at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158) [:6.0.0.Final]
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [:6.0.0.Final]
    	at org.jboss.web.tomcat.service.request.ActiveRequestResponseCacheValve.invoke(ActiveRequestResponseCacheValve.java:53) [:6.0.0.Final]
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362) [:6.0.0.Final]
    	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [:6.0.0.Final]
    	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:654) [:6.0.0.Final]
    	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:951) [:6.0.0.Final]
    	at java.lang.Thread.run(Thread.java:662) [:1.6.0_31]
    Caused by: java.sql.SQLFeatureNotSupportedException: Method is not implemented by JDBC driver
    	at org.jboss.resource.adapter.jdbc.WrappedConnection.checkException(WrappedConnection.java:875) [:6.0.0.Final]
    	at org.jboss.resource.adapter.jdbc.WrappedStatement.checkException(WrappedStatement.java:852) [:6.0.0.Final]
    	at org.jboss.resource.adapter.jdbc.WrappedResultSet.checkException(WrappedResultSet.java:1947) [:6.0.0.Final]
    	at org.jboss.resource.adapter.jdbc.jdk6.WrappedResultSetJDK6.isClosed(WrappedResultSetJDK6.java:202) [:6.0.0.Final]
    	at com.rapidminer.example.db.ExampleSetToDB$SubTable.readNextRow(ExampleSetToDB.java:312) [:]
    	at com.rapidminer.example.db.ExampleSetToDB$SubTable.access$8(ExampleSetToDB.java:311) [:]
    	at com.rapidminer.example.db.ExampleSetToDB.readDataFromDB(ExampleSetToDB.java:954) [:]
    	at com.rapidminer.example.db.ExampleSetToDB.readFromDB(ExampleSetToDB.java:734) [:]
    	at de.rapidanalytics.entity.IOObjectVersion.retrieveExampleSet(IOObjectVersion.java:168) [:]
    	... 51 more
    Caused by: java.lang.AbstractMethodError: org.postgresql.jdbc3.Jdbc3ResultSet.isClosed()Z
    	at org.jboss.resource.adapter.jdbc.jdk6.WrappedResultSetJDK6.isClosed(WrappedResultSetJDK6.java:198) [:6.0.0.Final]
    	... 56 more

    And here is the error message when I try to run a remote process : 
    2012-03-22 16:45:05,253 SEVERE [com.rapidminer.Process.1] (QuartzScheduler_Worker-3) Process failed: com.rapidminer.operator.UserError: Cannot retrieve repository data from entry '//_LOCAL/home/romain/Golf'. Reason: Cannot stream example set from table es_184: java.sql.SQLFeatureNotSupportedException: Method is not implemented by JDBC driver.: com.rapidminer.operator.UserError: Cannot retrieve repository data from entry '//_LOCAL/home/romain/Golf'. Reason: Cannot stream example set from table es_184: java.sql.SQLFeatureNotSupportedException: Method is not implemented by JDBC driver.
    	at com.rapidminer.Process.loadInitialData(Process.java:736) [:]
    	at com.rapidminer.operator.EnterpriseProcess.loadInitialData(EnterpriseProcess.java:119) [:]
    	at com.rapidminer.Process.run(Process.java:909) [:]
    	at com.rapidminer.Process.run(Process.java:848) [:]
    	at com.rapidminer.Process.run(Process.java:807) [:]
    	at com.rapidminer.Process.run(Process.java:802) [:]
    	at de.rapidanalytics.execution.AbstractProcessExecutor.runProcessNow(AbstractProcessExecutor.java:103) [:]
    	at de.rapidanalytics.execution.SimpleProcessExecutor.execute(SimpleProcessExecutor.java:49) [:]
    	at de.rapidanalytics.execution.ProcessExecutionDispatcher.dispatch(ProcessExecutionDispatcher.java:152) [:]
    	at de.rapidanalytics.ejb.ProcessJobEJBImpl.executeJob(ProcessJobEJBImpl.java:178) [:]
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [:1.6.0_31]
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [:1.6.0_31]
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [:1.6.0_31]
    	at java.lang.reflect.Method.invoke(Method.java:597) [:1.6.0_31]
    	at org.jboss.aop.joinpoint.MethodInvocation.invokeTarget(MethodInvocation.java:122) [jboss-aop.jar:2.2.1.GA]
    	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:111) [jboss-aop.jar:2.2.1.GA]
    	at org.jboss.ejb3.interceptors.container.ContainerMethodInvocationWrapper.invokeNext(ContainerMethodInvocationWrapper.java:72) [:1.1.3]
    	at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.invoke(InterceptorSequencer.java:76) [:1.1.3]
    	at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.aroundInvoke(InterceptorSequencer.java:62) [:1.1.3]
    	at sun.reflect.GeneratedMethodAccessor405.invoke(Unknown Source) [:1.6.0_31]
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [:1.6.0_31]
    	at java.lang.reflect.Method.invoke(Method.java:597) [:1.6.0_31]
    	at org.jboss.aop.advice.PerJoinpointAdvice.invoke(PerJoinpointAdvice.java:174) [jboss-aop.jar:2.2.1.GA]
    	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
    	at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.fillMethod(InvocationContextInterceptor.java:74) [:1.1.3]
    	at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_fillMethod_1727220232.invoke(InvocationContextInterceptor_z_fillMethod_1727220232.java) [:]
    	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
    	at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.setup(InvocationContextInterceptor.java:90) [:1.1.3]
    	at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_setup_1727220232.invoke(InvocationContextInterceptor_z_setup_1727220232.java) [:]
    	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
    	at org.jboss.ejb3.async.impl.interceptor.AsynchronousServerInterceptor.invoke(AsynchronousServerInterceptor.java:128) [:1.7.17]
    	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
    	at org.jboss.ejb3.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:62) [:1.7.17]
    	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
    	at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:56) [:1.7.17]
    	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
    	at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47) [:1.7.17]
    	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
    	at org.jboss.ejb3.tx.StatelessBMTInterceptor.handleInvocation(StatelessBMTInterceptor.java:106) [:1.0.3]
    	at org.jboss.ejb3.tx.BMTInterceptor.invoke(BMTInterceptor.java:55) [:1.0.3]
    	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
    	at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:68) [:1.7.17]
    	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
    	at org.jboss.ejb3.core.context.SessionInvocationContextAdapter.proceed(SessionInvocationContextAdapter.java:95) [:1.7.17]
    	at org.jboss.ejb3.tx2.impl.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:247) [:0.0.1]
    	at org.jboss.ejb3.tx2.impl.CMTTxInterceptor.required(CMTTxInterceptor.java:349) [:0.0.1]
    	at org.jboss.ejb3.tx2.impl.CMTTxInterceptor.invoke(CMTTxInterceptor.java:209) [:0.0.1]
    	at org.jboss.ejb3.tx2.aop.CMTTxInterceptorWrapper.invoke(CMTTxInterceptorWrapper.java:52) [:0.0.1]
    	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
    	at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76) [:1.0.0.GA]
    	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
    	at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42) [:1.0.3]
    	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
    	at org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invoke(Ejb3AuthenticationInterceptorv2.java:182) [:1.7.17]
    	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
    	at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:41) [:1.7.17]
    	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
    	at org.jboss.ejb3.BlockContainerShutdownInterceptor.invoke(BlockContainerShutdownInterceptor.java:67) [:1.7.17]
    	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
    	at org.jboss.ejb3.core.context.CurrentInvocationContextInterceptor.invoke(CurrentInvocationContextInterceptor.java:47) [:1.7.17]
    	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
    	at org.jboss.aspects.currentinvocation.CurrentInvocationInterceptor.invoke(CurrentInvocationInterceptor.java:67) [:1.0.1]
    	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
    	at org.jboss.ejb3.interceptor.EJB3TCCLInterceptor.invoke(EJB3TCCLInterceptor.java:86) [:1.7.17]
    	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
    	at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:392) [:1.7.17]
    	at org.jboss.ejb3.remoting.IsLocalInterceptor.invokeLocal(IsLocalInterceptor.java:88) [:1.7.17]
    	at org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor.java:75) [:1.7.17]
    	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
    	at org.jboss.ejb3.async.impl.interceptor.AsynchronousClientInterceptor.invoke(AsynchronousClientInterceptor.java:143) [:1.7.17]
    	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
    	at org.jboss.aspects.remoting.PojiProxy.invoke(PojiProxy.java:62) [:1.0.1.GA]
    	at $Proxy213.invoke(Unknown Source)	at org.jboss.ejb3.proxy.impl.handler.session.SessionProxyInvocationHandlerBase.invoke(SessionProxyInvocationHandlerBase.java:185) [:1.0.11]
    	at $Proxy212.executeJob(Unknown Source)	at de.rapidanalytics.web.tools.ProcessExecutionJob.execute(ProcessExecutionJob.java:75)
    	at org.quartz.core.JobRunShell.run(JobRunShell.java:216) [:6.0.0.Final]
    	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549) [:6.0.0.Final]
    Caused by: com.rapidminer.repository.RepositoryException: Cannot stream example set from table es_184: java.sql.SQLFeatureNotSupportedException: Method is not implemented by JDBC driver
    	at de.rapidanalytics.entity.RepositoryException.makeRMException(RepositoryException.java:80) [:]
    	at com.rapidminer.repository.enterprise.EnterpriseIOObjectEntry.retrieveData(EnterpriseIOObjectEntry.java:63) [:]
    	at com.rapidminer.Process.loadInitialData(Process.java:727) [:]
    	... 77 more
    Caused by: de.rapidanalytics.entity.RepositoryException: Cannot stream example set from table es_184: java.sql.SQLFeatureNotSupportedException: Method is not implemented by JDBC driver
    	at de.rapidanalytics.entity.IOObjectVersion.retrieveIOObject(IOObjectVersion.java:182) [:]
    	at com.rapidminer.repository.enterprise.EnterpriseIOObjectEntry.retrieveData(EnterpriseIOObjectEntry.java:59) [:]
    	... 78 more
    Caused by: java.sql.SQLFeatureNotSupportedException: Method is not implemented by JDBC driver
    	at org.jboss.resource.adapter.jdbc.WrappedConnection.checkException(WrappedConnection.java:875) [:6.0.0.Final]
    	at org.jboss.resource.adapter.jdbc.WrappedStatement.checkException(WrappedStatement.java:852) [:6.0.0.Final]
    	at org.jboss.resource.adapter.jdbc.WrappedResultSet.checkException(WrappedResultSet.java:1947) [:6.0.0.Final]
    	at org.jboss.resource.adapter.jdbc.jdk6.WrappedResultSetJDK6.isClosed(WrappedResultSetJDK6.java:202) [:6.0.0.Final]
    	at com.rapidminer.example.db.ExampleSetToDB$SubTable.readNextRow(ExampleSetToDB.java:312) [:]
    	at com.rapidminer.example.db.ExampleSetToDB$SubTable.access$8(ExampleSetToDB.java:311) [:]
    	at com.rapidminer.example.db.ExampleSetToDB.readDataFromDB(ExampleSetToDB.java:954) [:]
    	at com.rapidminer.example.db.ExampleSetToDB.readFromDB(ExampleSetToDB.java:734) [:]
    	at com.rapidminer.example.db.ExampleSetToDB.readFromDB(ExampleSetToDB.java:744) [:]
    	at de.rapidanalytics.entity.IOObjectVersion.retrieveIOObject(IOObjectVersion.java:180) [:]
    	... 79 more
    Caused by: java.lang.AbstractMethodError: org.postgresql.jdbc3.Jdbc3ResultSet.isClosed()Z
    	at org.jboss.resource.adapter.jdbc.jdk6.WrappedResultSetJDK6.isClosed(WrappedResultSetJDK6.java:198) [:6.0.0.Final]
    	... 85 more

    2012-03-22 16:45:05,280 SEVERE [com.rapidminer.Process.1] (QuartzScheduler_Worker-3) Here:           Process[0] (Process)
               subprocess 'Main Process'
                 +- Decision Tree[0] (Decision Tree)
    2012-03-22 16:45:05,441 INFO  [de.rapidanalytics.ejb.ProcessJobEJBImpl] (QuartzScheduler_Worker-3) Completed execution of process /home/romain/proc
    2012-03-22 16:45:05,441 INFO  [de.rapidanalytics.ejb.ProcessJobEJBImpl] (QuartzScheduler_Worker-3) Marking process as completed with exception com.rapidminer.operator.UserError: Cannot retrieve repository data from entry '//_LOCAL/home/romain/Golf'. Reason: Cannot stream example set from table es_184: java.sql.SQLFeatureNotSupportedException: Method is not implemented by JDBC driver.
    2012-03-22 16:45:05,540 INFO  [de.rapidanalytics.ejb.SchedulerEJBImpl] (QuartzScheduler_Worker-3) Marking process execution parameters /home/romain/proc, id 201 as completed.
    I hope it can help
  • Options
    fischerfischer Member Posts: 439 Maven
    Hi,

    is that RA 1.2.002?

    http://sourceforge.net/projects/rapidanalytics/files/RapidAnalytics%20Community%20Edition/1.2/

    Best,
    Simon
  • Options
    RomanocryRomanocry Member Posts: 7 Contributor II
    Thank you, now everything is working.

    I had the version 1.2.000

    How I solved it :
    - Install of the 1.2.002 version
    - Using postgresql-9.1-901.jdbc4.jar instead of the postgresql-9.1-901.jdbc3.jar driver given with the installer
  • Options
    fischerfischer Member Posts: 439 Maven
    Hi,

    thanks for reporting. Well package the postgres JDBC4 driver on 1.2.004.

    Best,
    Simon
Sign In or Register to comment.