При попытке получить данные из второй SQL базы (PostgreSQL) выдает ошибку.
Версия 4.0.6
Конфиг:
<datasource jndi-name="java:jboss/datasources/wfe_db" pool-name="wfe_db"> <connection-url>jdbc:postgresql://ip:5432/db</connection-url> <driver>postgresql</driver> <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> <pool> <min-pool-size>10</min-pool-size> <max-pool-size>100</max-pool-size> <prefill>true</prefill> </pool> <security> <user-name>user</user-name> <password>pass</password> </security> <statement> <prepared-statement-cache-size>32</prepared-statement-cache-size> <share-prepared-statements>true</share-prepared-statements> </statement> </datasource> <datasource jta="false" jndi-name="java:jboss/datasources/wf_data" pool-name="wf_data"> <connection-url>jdbc:postgresql://ip:5432/db2</connection-url> <driver>postgresql</driver> <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> <pool> <min-pool-size>10</min-pool-size> <max-pool-size>100</max-pool-size> <prefill>true</prefill> </pool> <security> <user-name>user</user-name> <password>pass</password> </security> <statement> <prepared-statement-cache-size>32</prepared-statement-cache-size> <share-prepared-statements>true</share-prepared-statements> </statement> </datasource> <drivers> <driver name="postgresql" module="org.postgresql"> <xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class> </driver>
Обработчик:
java:jboss/datasources/wf_data SELECT name FROM files; Переменная для вывода имеет тип: список.
Лог ошибки:
07:50:44,548 ERROR [ru.runa.wfe.service.interceptors.EjbExceptionSupport] (http--мойip-8080-1) ejb call error: ExecutionServiceBean.startProcess(Actor{id=1, name=Administrator, code=-1}, ?????????? ???????, {}): java.lang.RuntimeException: org.postgresql.util.PSQLException: ResultSet not positioned properly, perhaps you need to call next. at com.google.common.base.Throwables.propagate(Throwables.java:160) [guava-14.0.1.jar:] at ru.runa.wfe.lang.ScriptTask.execute(ScriptTask.java:39) [wfe-core-4.0.6.jar:4.0.6-${svn.revision}] at ru.runa.wfe.lang.Node.enter(Node.java:161) [wfe-core-4.0.6.jar:4.0.6-${svn.revision}] at ru.runa.wfe.lang.Transition.take(Transition.java:93) [wfe-core-4.0.6.jar:4.0.6-${svn.revision}] at ru.runa.wfe.lang.Node.leave(Node.java:193) [wfe-core-4.0.6.jar:4.0.6-${svn.revision}] at ru.runa.wfe.execution.ProcessFactory.startProcessInternal(ProcessFactory.java:169) [wfe-core-4.0.6.jar:4.0.6-${svn.revision}] at ru.runa.wfe.execution.ProcessFactory.startProcess(ProcessFactory.java:77) [wfe-core-4.0.6.jar:4.0.6-${svn.revision}] at ru.runa.wfe.execution.logic.ExecutionLogic.startProcess(ExecutionLogic.java:173) [wfe-core-4.0.6.jar:4.0.6-${svn.revision}] at ru.runa.wfe.service.impl.ExecutionServiceBean.startProcess(ExecutionServiceBean.java:93) [wfe-service-4.0.6.jar:] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_b147-icedtea] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_b147-icedtea] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_b147-icedtea] at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_b147-icedtea] at org.jboss.as.ee.component.ManagedReferenceMethodInterceptorFactory$ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptorFactory.java:72) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:374) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] at ru.runa.wfe.service.interceptors.EjbTransactionSupport.invokeWithRetry(EjbTransactionSupport.java:67) [wfe-service-4.0.6.jar:] at ru.runa.wfe.service.interceptors.EjbTransactionSupport.process(EjbTransactionSupport.java:46) [wfe-service-4.0.6.jar:] at sun.reflect.GeneratedMethodAccessor107.invoke(Unknown Source) [:1.7.0_b147-icedtea] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_b147-icedtea] at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_b147-icedtea] at org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptorFactory$ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptorFactory.java:123) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:374) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] at ru.runa.wfe.service.interceptors.PerformanceObserver.process(PerformanceObserver.java:15) [wfe-service-4.0.6.jar:] at sun.reflect.GeneratedMethodAccessor108.invoke(Unknown Source) [:1.7.0_b147-icedtea] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_b147-icedtea] at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_b147-icedtea] at org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptorFactory$ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptorFactory.java:123) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:374) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] at ru.runa.wfe.service.interceptors.EjbExceptionSupport.process(EjbExceptionSupport.java:42) [wfe-service-4.0.6.jar:] at sun.reflect.GeneratedMethodAccessor106.invoke(Unknown Source) [:1.7.0_b147-icedtea] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_b147-icedtea] at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_b147-icedtea] at org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptorFactory$ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptorFactory.java:123) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:36) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] at org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] at org.jboss.as.ejb3.tx.EjbBMTInterceptor.handleInvocation(EjbBMTInterceptor.java:105) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final] at org.jboss.as.ejb3.tx.BMTInterceptor.processInvocation(BMTInterceptor.java:56) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] at org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:32) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] at org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final] at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:173) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final] at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:72) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final] at ru.runa.wfe.service.decl.ExecutionServiceLocal$$$view11.startProcess(Unknown Source) [wfe-service-4.0.6.jar:] at ru.runa.wfe.service.delegate.ExecutionServiceDelegate.startProcess(ExecutionServiceDelegate.java:53) [wfe-service-4.0.6.jar:] at ru.runa.wf.web.action.SubmitStartProcessFormAction.executeProcessFromAction(SubmitStartProcessFormAction.java:68) at ru.runa.wf.web.action.BaseProcessFormAction.execute(BaseProcessFormAction.java:62) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228) at ru.runa.common.web.UTF8RequestProcessor.process(UTF8RequestProcessor.java:41) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462) at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final] at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) at ru.runa.common.web.filter.XSSFilter.doFilter(XSSFilter.java:18) at ru.runa.common.web.filter.HTTPFilterBase.doFilter(HTTPFilterBase.java:50) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) at ru.runa.common.web.filter.HTTPSessionFilter.doFilter(HTTPSessionFilter.java:49) at ru.runa.common.web.filter.HTTPFilterBase.doFilter(HTTPFilterBase.java:50) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) at ru.runa.af.web.filter.NTLMFilter.doFilter(NTLMFilter.java:54) at ru.runa.common.web.filter.HTTPFilterBase.doFilter(HTTPFilterBase.java:50) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:206) [javamelody-core-1.44.0.jar:1.44.0] at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:179) [javamelody-core-1.44.0.jar:1.44.0] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_b147-icedtea] Caused by: org.postgresql.util.PSQLException: ResultSet not positioned properly, perhaps you need to call next. at org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkResultSet(AbstractJdbc2ResultSet.java:2675) at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getObject(AbstractJdbc2ResultSet.java:2508) at org.jboss.jca.adapters.jdbc.WrappedResultSet.getObject(WrappedResultSet.java:1156) at ru.runa.wfe.extension.handler.SQLActionHandler.extractResults(SQLActionHandler.java:149) [wfe-core-4.0.6.jar:4.0.6-${svn.revision}] at ru.runa.wfe.extension.handler.SQLActionHandler.execute(SQLActionHandler.java:133) [wfe-core-4.0.6.jar:4.0.6-${svn.revision}] at ru.runa.wfe.lang.ScriptTask.execute(ScriptTask.java:35) [wfe-core-4.0.6.jar:4.0.6-${svn.revision}]
Исправлено в январе, в версии 4.1.0 должно работать, см. https://sourceforge.net/p/runawfe/discussion/426100/thread/fb90f972/
Спасибо. Что-то просмотрел эту тему.
Log in to post a comment.
При попытке получить данные из второй SQL базы (PostgreSQL) выдает ошибку.
Версия 4.0.6
Конфиг:
Обработчик:
java:jboss/datasources/wf_data
SELECT name FROM files;
Переменная для вывода имеет тип: список.
Лог ошибки:
Last edit: Anton Abrosimov 2014-01-30
Исправлено в январе, в версии 4.1.0 должно работать, см. https://sourceforge.net/p/runawfe/discussion/426100/thread/fb90f972/
Спасибо. Что-то просмотрел эту тему.