Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Run a simple remote process

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

Find more posts tagged with

AI Studio

Server

Accepted answers

All comments

Romanocry

Hello,

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

Best regards,

fischer

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

Romanocry

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

Romanocry

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

fischer

Hi,

is that RA 1.2.002?

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

Best,
Simon

Romanocry

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

fischer

Hi,

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

Best,
Simon