[OFBiz] Users - DB2 strange behaviour

Javrishvili, Giorgi (Key-Work) giorgi.javrishvili at key-work.de
Wed Sep 21 07:08:56 EDT 2005 

Hi everybody!

I need to compare query results from 2 different DBs. For that I have
implemented one service that does following:
It goes to the specified directory, reads sql files and executes each on
the appropriate DB. One DB in sql server(no problems with that) and the
other  - IBM DB2. And here is a problem(I even don't know how to
formulate it better): When the service executes query for DB2 - it
causes java.lang.OutOfMemoryError. But it happens only ON FIRST CALL OF
SERVICE!!! I mean, when I call in once more next time(and once more...)
it's working fine - no errors anymore.
So, has anyone had the same problem?

Not sure if it helps, but here is all the info that is needed, I think:

Here are entries for DS and appropriate helper in entityengine.xml:
	
    <delegator name="default" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
distributed-cache-clear-enabled="false">
        <group-map group-name="org.ofbiz"
datasource-name="AGS_OFBiz_DS"/>
        <group-map group-name="de.keywork.extranet"
datasource-name="AGS_EXTRANET_DS"/>
    </delegator>
. . . .

    <datasource name="AGS_EXTRANET_DS"
            helper-class="org.ofbiz.entity.datasource.GenericHelperDAO" 
            schema-name="ags"
            field-type-name="db2"
            check-on-start="true"
            add-missing-on-start="true"
            join-style="ansi"
            use-fk-initially-deferred="false">
        <read-data reader-name="seed"/>
        <read-data reader-name="demo"/>
        <read-data reader-name="ext"/>
        
        <inline-jdbc 
                jdbc-driver="COM.ibm.db2.jdbc.app.DB2Driver"
                jdbc-uri="jdbc:db2:D_AGS_EX"
                jdbc-username="extranet"
                jdbc-password="xf6pw!m12"
                pool-minsize="2"
                pool-maxsize="20"/>
    </datasource>

Here are messages and exceptions during execution:

2005-09-21 12:05:33,846  INFO [            TechToolServices:379]
Starting sql results compare...
2005-09-21 12:05:35,706  WARN [         XAConnectionFactory:121] no
xares in rms for con
org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAConnectionImpl at 163956
2005-09-21 12:06:35,378  INFO [                        jotm:765] set
rollback only (tx=bb14:38:0:0163aef82db679c6a5...a57413:)
2005-09-21 12:07:16,846 DEBUG [           ServiceDispatcher:380] [[Sync
service failed...- total:0.0,since last(Begin):0.0]] - 'catalog /
executeQueriesInDirectory'
2005-09-21 12:07:16,846 ERROR [           ServiceDispatcher:382]
---- exception report
----------------------------------------------------------
Service [executeQueriesInDirectory] threw an unexpected exception/error
Exception: org.ofbiz.service.GenericServiceException
Message: Service target threw an unexpected exception (null)
---- stack trace
---------------------------------------------------------------
org.ofbiz.service.GenericServiceException: Service target threw an
unexpected exception (null)
org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaE
ngine.java:113)
org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.j
ava:63)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:338)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:212)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:110)
org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.ja
va:276)
org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:400
)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:24
0)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:189)
org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:85)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:237)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:214)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:178)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:126)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:105)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:107)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:526
)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
48)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:82
5)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
onnection(Http11Protocol.java:738)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
.java:526)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
erWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:684)
java.lang.Thread.run(Thread.java:534)
java.lang.OutOfMemoryError
------------------------------------------------------------------------
--------

2005-09-21 12:07:16,846 ERROR [             TransactionUtil:295]
---- exception report
----------------------------------------------------------
[TransactionUtil.rollback]
Exception: java.lang.Exception
Message: Stack Trace
---- stack trace
---------------------------------------------------------------
java.lang.Exception: Stack Trace
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.ja
va:294)
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.ja
va:276)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:385)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:212)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:110)
org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.ja
va:276)
org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:400
)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:24
0)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:189)
org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:85)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:237)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:214)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:178)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:126)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:105)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:107)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:526
)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
48)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:82
5)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
onnection(Http11Protocol.java:738)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
.java:526)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
erWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:684)
java.lang.Thread.run(Thread.java:534)
------------------------------------------------------------------------
--------

2005-09-21 12:07:16,862  INFO [             TransactionUtil:304]
[TransactionUtil.rollback] transaction rolled back
2005-09-21 12:07:16,862  INFO [             TransactionUtil:249]
[TransactionUtil.commit] Not committing transaction, status is
STATUS_NO_TRANSACTION
2005-09-21 12:07:16,862 ERROR [         ServiceEventHandler:292]
---- exception report
----------------------------------------------------------
Service invocation error
Exception: org.ofbiz.service.GenericServiceException
Message: Service target threw an unexpected exception (null)
---- stack trace
---------------------------------------------------------------
org.ofbiz.service.GenericServiceException: Service target threw an
unexpected exception (null)
org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaE
ngine.java:113)
org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.j
ava:63)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:338)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:212)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:110)
org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.ja
va:276)
org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:400
)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:24
0)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:189)
org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:85)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:237)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:214)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:178)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:126)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:105)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:107)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:526
)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
48)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:82
5)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
onnection(Http11Protocol.java:738)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
.java:526)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
erWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:684)
java.lang.Thread.run(Thread.java:534)
java.lang.OutOfMemoryError
------------------------------------------------------------------------
--------

2005-09-21 12:07:16,893 DEBUG [                     UtilXml:242] XML
Read 0.015s: jndi:/0.0.0.0/tech_tools/WEB-INF/controller.xml

Thank you very much in advance!

More information about the Users mailing list