Curious if anyone can shed light on this... Using Camel JPA to poll Oracle. On startup, high CPU and memory consumption is observed; profiler shows oracle driver spending A LOT of time in getColumnIndex(), not much else, ultimately causes OOM. Camel 2.15.3/Java 8/RHEL 7.1
2016-03-31 07:40:35,955 WARN JpaConsumer - Consumer Consumer[jpa://org.apache.camel.sfx.dto.Team_Contact__c?consumeDelete=true&consumer.delay=5000&consumer.query=select+o+from+org.apache.camel.sfx.dto.Team_Contact__c+o+where+o.inSFX+not+in+%281%29] failed polling endpoint: Endpoint[jpa://org.apache.camel.sfx.dto.Team_Contact__c?consumeDelete=true&consumer.delay=5000&consumer.query=select+o+from+org.apache.camel.sfx.dto.Team_Contact__c+o+where+o.inSFX+not+in+%281%29]. Will try again at next poll. Caused by: [java.lang.OutOfMemoryError - Java heap space] java.lang.OutOfMemoryError: Java heap space 2016-03-31 07:40:24,489 INFO JdbcCoordinatorImpl - HHH000106: Forcing container resource cleanup on transaction completion 2016-03-31 07:40:24,495 ERROR TransactionSynchronizationUtils - TransactionSynchronization.afterCompletion threw exception 2016-03-31 07:43:48,498 WARN JpaConsumer - Consumer Consumer[jpa://org.apache.camel.sfxdto.Contact?consumeDelete=true&consumer.delay=5000&consumer.query=select+o+from+org.apache.camel.sfx.dto.Contact+o+where+o.inSFX+not+in+%281%29] failed polling endpoint: Endpoint[jpa://org.apache.camel.salesforce.dto.Contact?consumeDelete=true&consumer.delay=5000&consumer.query=select+o+from+org.apache.camel.sfx.dto.Contact+o+where+o.inSFX+not+in+%281%29]. Will try again at next poll. Caused by: [javax.persistence.TransactionRequiredException - no transaction is in progress] javax.persistence.TransactionRequiredException: no transaction is in progress -- View this message in context: http://camel.465427.n5.nabble.com/Camel-JPA-consumer-causing-Out-of-Memory-when-polling-table-tp5780168.html Sent from the Camel - Users mailing list archive at Nabble.com.
