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

Reply via email to