Run a simple remote process
Romanocry
New Altair Community Member
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
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
0
Answers
-
Hello,
I still have the same problem.
Does anyone have a solution ?
Best regards,
0 -
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,
Simon0 -
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 more0 -
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
And here is the error message when I try to run a remote process :
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 more2012-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.
I hope it can help
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.0 -
Hi,
is that RA 1.2.002?
http://sourceforge.net/projects/rapidanalytics/files/RapidAnalytics%20Community%20Edition/1.2/
Best,
Simon0 -
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 installer0 -
Hi,
thanks for reporting. Well package the postgres JDBC4 driver on 1.2.004.
Best,
Simon0