Re: Does Camel JPA component implement it's own connection pooling?

2013-02-01 Thread Chris Wolf
(); em.persist(entity); } }); On Jan 31, 2013, at 5:49 PM, Chris Wolf cwolf.a...@gmail.com wrote: James, Ok, now using TransactionTemplate, but I'm back to where I was - the same apparent connection leak, only now the code is hideous with all those nested

Re: Does Camel JPA component implement it's own connection pooling?

2013-02-01 Thread Chris Wolf
that out, that would be great. I've already posted on the openjpa users list about that, but nothing from there yet... On Fri, Feb 1, 2013 at 10:39 AM, Chris Wolf cwolf.a...@gmail.com wrote: James, I just replied to your message from last night - I got it working by using your latest

Re: Does Camel JPA component implement it's own connection pooling?

2013-02-01 Thread Chris Wolf
saves me so much time, because I don't get these little weird hiccups (I get others ;). This stuff has been tested by lots of folks before me. :) James On Feb 1, 2013, at 10:39 AM, Chris Wolf cwolf.a...@gmail.com wrote: James, I just replied to your message from last night - I got

Re: Does Camel JPA component implement it's own connection pooling?

2013-02-01 Thread Chris Wolf
, I'll agree. Unfortunately, for a lot of the channels, you have to jack them all the way up to TRACE to get them to give you anything. On Feb 1, 2013, at 10:51 AM, Chris Wolf cwolf.a...@gmail.com wrote: Just to clarify, for me, these logging settings work: property name=openjpa.Log value

Re: Does Camel JPA component implement it's own connection pooling?

2013-01-31 Thread Chris Wolf
On Sat, Jan 26, 2013 at 3:43 AM, Claus Ibsen claus.ib...@gmail.com wrote: On Fri, Jan 25, 2013 at 9: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

Re: Does Camel JPA component implement it's own connection pooling?

2013-01-31 Thread Chris Wolf
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

Re: Does Camel JPA component implement it's own connection pooling?

2013-01-31 Thread Chris Wolf
(); } On Thu, Jan 31, 2013 at 12:34 PM, James Carman ja...@carmanconsulting.com wrote: What does your route look like? On Thu, Jan 31, 2013 at 11:58 AM, Chris Wolf cwolf.a...@gmail.com wrote: I have further determined that it's an OpenJPA issue (or user error, but how can that be?) ;) I

Re: Does Camel JPA component implement it's own connection pooling?

2013-01-31 Thread Chris Wolf
://www.dadbm.com/2011/11/oracle-listener-refused-connection-ora-12519-troubleshooting/ Maybe its a database failure. Can you have a look at this? HTH, Matthias Am 31.01.2013 um 18:48 schrieb Chris Wolf cwolf.a...@gmail.com: James, Here is what it looks like. At first, I was using the jpa

Re: Does Camel JPA component implement it's own connection pooling?

2013-01-31 Thread Chris Wolf
31, 2013 at 2:28 PM, Chris Wolf cwolf.a...@gmail.com wrote: Howdy Matthias, Yes, in an earlier post to this thread, I mentioned that 120 connections were being opened (the max). So, yes, the max connections limit is being hit. I observe this by tailing the TNS listener log c:/app/userId

Re: Does Camel JPA component implement it's own connection pooling?

2013-01-31 Thread Chris Wolf
, 2013 at 2:35 PM, Chris Wolf cwolf.a...@gmail.com wrote: Right, I looked into that but the Spring docs say that JpaTemplate is deprecated in favor of native JPA APIs. http://static.springsource.org/spring/docs/3.1.x/javadoc-api/org/springframework/orm/jpa/JpaTemplate.html I am using OpenJPA-2.1

Re: Does Camel JPA component implement it's own connection pooling?

2013-01-31 Thread Chris Wolf
, 2013 at 3:02 PM, James Carman ja...@carmanconsulting.com wrote: Do you have a gist of your test scaffold? I'm curious now :) On Thu, Jan 31, 2013 at 2:59 PM, Chris Wolf cwolf.a...@gmail.com wrote: Sure, I can look into that. I also narrowed down the issue while stepping through my code while

Re: Does Camel JPA component implement it's own connection pooling?

2013-01-31 Thread Chris Wolf
you're also managing your own transactions. Perhaps just use Spring for the transaction management. On Thu, Jan 31, 2013 at 2:35 PM, Chris Wolf cwolf.a...@gmail.com wrote: Right, I looked into that but the Spring docs say that JpaTemplate is deprecated in favor of native JPA APIs. http

Does Camel JPA component implement it's own connection pooling?

2013-01-25 Thread Chris Wolf
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

Re: Does Camel JPA component implement it's own connection pooling?

2013-01-25 Thread Chris Wolf
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

Re: How to do conditional entity persistence in JPA Consumer

2013-01-22 Thread Chris Wolf
simpler to do it in this way instead of modeling a Camel route which query the database first, use a CBR to route the message and update/create an entity. Best, Christian On Mon, Jan 21, 2013 at 8:56 PM, Chris Wolf cwolf.a...@gmail.com wrote: Hello Christian, So forget about the jpa: endpoint

How to do conditional entity persistence in JPA Consumer

2013-01-21 Thread Chris Wolf
I recently changed a schema to be more normalized by factoring out a column of type varchar2 that takes one of only a few dozen, but long values, so I created a lookup table for these strings and replaced the sting-valued column in the main entity with a foreign-key valued column, referencing the

Re: How to do conditional entity persistence in JPA Producer

2013-01-21 Thread Chris Wolf
(corrected Subject:) On Mon, Jan 21, 2013 at 12:11 PM, Chris Wolf cwolf.a...@gmail.com wrote: I recently changed a schema to be more normalized by factoring out a column of type varchar2 that takes one of only a few dozen, but long values, so I created a lookup table for these strings

Re: How to do conditional entity persistence in JPA Consumer

2013-01-21 Thread Chris Wolf
in a single bean... Best, Christian Sent from a mobile device Am 21.01.2013 18:12 schrieb Chris Wolf cwolf.a...@gmail.com: I recently changed a schema to be more normalized by factoring out a column of type varchar2 that takes one of only a few dozen, but long values, so I created a lookup

Re: Route Dependency in XML DSL + JPA

2013-01-19 Thread Chris Wolf
On Fri, Jan 18, 2013 at 9:09 AM, Gershaw, Geoffrey geoffrey.gers...@credit-suisse.com wrote: Hello, Thanks for your reply. This strategy appears not to work. Using the jpa component in the to endpoint tries to store the entity in the message body into the db. This results in a null pointer. I

Re: JPA Component Behavior

2013-01-19 Thread Chris Wolf
for consumption, etc. E.g. maybe have some sort of pluggable IndicateConsumedStrategy and provide a few strategies, per the suggestions, above. -Chris On Sat, Jan 19, 2013 at 1:42 AM, Chris Wolf cwolf.a...@gmail.com wrote: On Fri, Jan 18, 2013 at 12:01 PM, Gershaw, Geoffrey geoffrey.gers

Re: unmarshall csv problem with bindy

2013-01-16 Thread Chris Wolf
On Wed, Jan 16, 2013 at 3:44 AM, Claus Ibsen claus.ib...@gmail.com wrote: On Tue, Jan 15, 2013 at 9:33 PM, Chris Wolf cwolf.a...@gmail.com wrote: I tried doing some CSV parsing with bindy and had some issues due to variable length records in the same file and other format weirdness. I ended up

Re: JPA component throwing Attempt to cast instance [Ljava.lang.Object *** PROBLEM SOLVED ***

2013-01-16 Thread Chris Wolf
On Tue, Jan 15, 2013 at 9:11 PM, Babak Vahdat babak.vah...@swissonline.ch wrote: Am 16.01.13 01:07 schrieb Chris Wolf unter cwolf.a...@gmail.com: It was me not RTFM more carefully. Sorry about that. On the main Camel-JPA page it mentions a query option called consumer.resultClass which can

Re: JPA component throwing Attempt to cast instance [Ljava.lang.Object

2013-01-16 Thread Chris Wolf
...@carmanconsulting.com wrote: Are you using the same version of OpenJPA to enhance your classes that you're using at runtime? On Tue, Jan 15, 2013 at 5:11 PM, Chris Wolf cwolf.a...@gmail.com wrote: Babak, Thanks for the detailed reply, but if you look at my first post on this thread, I mentioned

Re: JPA component throwing Attempt to cast instance [Ljava.lang.Object *** PROBLEM SOLVED ***

2013-01-16 Thread Chris Wolf
currently the third variant is not supported at all. Babak Chris Wolf wrote On Tue, Jan 15, 2013 at 9:11 PM, Babak Vahdat lt; babak.vahdat@ gt; wrote: Am 16.01.13 01:07 schrieb Chris Wolf unter lt; cwolf.algo@ gt;: It was me not RTFM more carefully. Sorry about that. On the main

Re: JPA component throwing Attempt to cast instance [Ljava.lang.Object

2013-01-15 Thread Chris Wolf
, Christian On Fri, Jan 11, 2013 at 8:23 PM, Chris Wolf cwolf.a...@gmail.com wrote: I have a JPA endpoint setup as a consumer, just performing a basic query. If I have consumeDelete=false configured, then it works and I see the entities. When consumeDelete=false is not configured (default

Re: unmarshall csv problem with bindy

2013-01-15 Thread Chris Wolf
I tried doing some CSV parsing with bindy and had some issues due to variable length records in the same file and other format weirdness. I ended up using camel-beanio. It's very flexible/configurable and works well. -Chris http://camel.apache.org/beanio.html http://beanio.org On Wed, Jan

Re: JPA component throwing Attempt to cast instance [Ljava.lang.Object

2013-01-11 Thread Chris Wolf
, 2013 at 5:37 PM, Christian Müller christian.muel...@gmail.com wrote: Which version of Camel do you use? Have a look at route policy and/or the quartz component for sheduling routes. Best, Christian Am 11.01.2013 20:23 schrieb Chris Wolf cwolf.a...@gmail.com: I have a JPA endpoint setup

Re: Cannot get came-csv to work ***DISREGARD***

2012-12-14 Thread Chris Wolf
When I checked the sample in chapter 3 of Camel In Action, it reminded me of the dependency camel-csv, which I removed because I was trying something with camel-bindy - after changing my POM back - it worked. Sorry for the noise. On Fri, Dec 14, 2012 at 1:05 PM, Chris Wolf cwolf.a...@gmail.com

Re: Camel and JBoss

2012-10-11 Thread Chris Wolf
Yes. You can load a plain Spring AppContext (with embedded Camel context a/k/a Spring DSL) using JBoss's Spring Deployer, which is available for JBoss 4,5, 6 and 7. https://www.jboss.org/snowdrop I find this is the cleanest method of deploying Camel on JBoss. -Chris On Thu, Oct 11, 2012 at

Re: Jboss 7 and camel -bindy 2.10

2012-10-09 Thread Chris Wolf
Elz, I was making a general suggestion as to a better way to do Camel deployments on JBoss - i.e. not using WAR deployment, but rather Spring AppContext deployment. Sorry for not directly answering your CSV question. If I can, I'll try the Bindy component in one of our JBoss deployments and let

Re: Jboss 7 and camel -bindy 2.10

2012-10-09 Thread Chris Wolf
Claus, Is the Camel-Jboss component supported on JBoss-7? I ask because the documentation page: http://camel.apache.org/camel-jboss.html ...mentions a camel-jboss jar for JBoss 4.x/5.x and different jar for JBoss-6 and no mention of JBoss-7 - and then further down the page, it says, From

Re: Jboss 7 and camel -bindy 2.10

2012-10-08 Thread Chris Wolf
Elz, I would consider a different deployment strategy. Your Camel routes are (architecturally) considered part of the backend tier - so why deploy in a WAR deployment? For JBoss, I found that their Spring Deployer works very well. It's available from JBoss, from their project Snowdrop, which

<    1   2