I have further determined that it's an OpenJPA issue (or user error,
but how can that be?) ;)
I will report back when I get to the bottom of it. Thanks a lot,
Chris
On Sat, Jan 26, 2013 at 2:47 AM, Willem Jiang <willem.ji...@gmail.com> wrote:
> Can you share us your camel route? It is important for us to find out the key
> reason of your issue.
>
>
> 发自我的 iPhone
>
> 在 2013-1-26，上午5:22，Chris Wolf <cwolf.a...@gmail.com> 写道：
>
>> On Fri, Jan 25, 2013 at 3:55 PM, Chris Wolf <cwolf.a...@gmail.com> wrote:
>>> I ask because when I use jpa: in producer mode, I get this error:
>>> Caused by: oracle.net.ns.NetException: Listener refused the connection
>>> with the following error:
>>> ORA-12519, TNS:no appropriate service handler found
>>>
>>> Strangely, using jpa: in consumer mode, this does not happen. In the
>>> tnslsnr.log, I observe 120 connections being opened when
>>> running the route with jpa: in producer mode. If I instead use a
>>> custom Processor and do my own JPA persistence code,
>>> the issue does not occur.
>>>
>>> Thanks for any advice,
>>>
>>> Chris
>>
>>
>> I stepped through with the debugger and the problem went away. The
>> point at which a lot of connections were opened was
>> after I stepped over:
>>
>> return jpaTemplate.execute(new JpaCallback<Object>() {
>> public Object doInJpa(EntityManager entityManager)
>> throws PersistenceException {
>> return callback.doInJpa(entityManager);
>> }
>>
>> ..and when running in real time (not debugging) it seems to be running
>> in an AsyncProcessor - I wonder if it's too many worker
>> threads eating up the connections? BTW, this is mt first project
>> using Camel, so forgive the lack of experience...
>>
>>
>> [ad #1 - file:///tmp/local/data] UnmarshallingContext DEBUG
>> EOF reached at line 2007
>> [ad #1 - file:///tmp/local/data] SendProcessor DEBUG
>>>>>> Endpoint[jpa://?persistenceUnit=marketdata] Exchange[null]
>> [ad #1 - file:///tmp/local/data] JpaTransactionManager DEBUG
>> Creating new transaction with name [null]:
>> PROPAGATION_REQUIRED,ISOLATION_DEFAULT
>> 8505 marketdata INFO [Camel (camel-1) thread #1 -
>> file:///tmp/local/data] openjpa.Runtime - Starting OpenJPA 2.2.1
>> 8535 marketdata INFO [Camel (camel-1) thread #1 -
>> file:///tmp/local/data] openjpa.jdbc.JDBC - Using dictionary class
>> "org.apache.openjpa.jdbc.sql.OracleDictionary".
>> [ad #1 - file:///tmp/local/data] JpaTransactionManager DEBUG
>> Opened new EntityManager
>> [org.apache.openjpa.persistence.EntityManagerImpl@798b429b] for JPA
>> transaction
>> [ad #1 - file:///tmp/local/data] JpaTransactionManager DEBUG
>> Initiating transaction commit
>> [ad #1 - file:///tmp/local/data] JpaTransactionManager DEBUG
>> Committing JPA transaction on EntityManager
>> [org.apache.openjpa.persistence.EntityManagerImpl@798b429b]
>> [ad #1 - file:///tmp/local/data] JpaTransactionManager DEBUG
>> Closing JPA EntityManager
>> [org.apache.openjpa.persistence.EntityManagerImpl@798b429b] after
>> transaction
>> [ad #1 - file:///tmp/local/data] EntityManagerFactoryUtils DEBUG
>> Closing JPA EntityManager
