Mailing-List: contact users-help@camel.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@camel.apache.org
Received-SPF: pass (athena.apache.org: domain of james.mk.green@gmail.com
 designates 209.85.217.170 as permitted sender)
MIME-Version: 1.0
Date: Fri, 5 Sep 2014 17:08:32 +0100
Message-ID: 
 <CAMH6+ayaBZwdT98ftSFktxvN6S9+4hqj0if_Q19D0hqhXjFNaQ@mail.gmail.com>
Subject: Camel + Spring + JpaTransactionManager = Hung on SELECT
From: James Green <james.mk.green@gmail.com>
To: users <users@camel.apache.org>
Content-Type: multipart/alternative; boundary=001a11332bac473cfb050253ae97

--001a11332bac473cfb050253ae97
Content-Type: text/plain; charset=UTF-8

We have a maven project that bundles Camel and Spring. The trouble is a
processor receives a message and uses an EntityManager to perform a
database query which hangs completely until a 20s timeout kicks in during
routing.

The hang is during an integration test against an in-memory database with a
single record. We can do the same query within the test itself within a few
milliseconds before calling the camel code which hangs.

We also built a separate integration test that executes the processor
directly (without Camel) and this works fine. So it's only when Camel is
used does the route hang. Debugging switched on, we see HIbernate log the
SELECT query, then nothing before the Camel timeout gets logged.

Unfortunately at this point we're totally baffled. Any ideas gratefully
received.

Versions:
Camel: 2.13.2
Spring: 3.2.10-RELEASE
Spring-data-jpa: 1.6.2
spring-osgi-core: 1.0.2
Hibernate: 3.6.10
hibernate-jpa-2.0-api 1.0.1-FINAL

James

--001a11332bac473cfb050253ae97--