Return-Path: 
 <users-return-29448-apmail-camel-users-archive=camel.apache.org@camel.apache.org>
X-Original-To: apmail-camel-users-archive@www.apache.org
Delivered-To: apmail-camel-users-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 70A6F9042
	for <apmail-camel-users-archive@www.apache.org>;
 Wed, 16 May 2012 14:40:25 +0000 (UTC)
Received: (qmail 95677 invoked by uid 500); 16 May 2012 14:40:25 -0000
Delivered-To: apmail-camel-users-archive@camel.apache.org
Received: (qmail 95647 invoked by uid 500); 16 May 2012 14:40:25 -0000
Mailing-List: contact users-help@camel.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@camel.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@camel.apache.org>
List-Post: <mailto:users@camel.apache.org>
List-Id: <users.camel.apache.org>
Reply-To: users@camel.apache.org
Delivered-To: mailing list users@camel.apache.org
Received: (qmail 95638 invoked by uid 99); 16 May 2012 14:40:24 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 16 May 2012 14:40:24 +0000
X-ASF-Spam-Status: No, hits=2.2 required=5.0
	tests=FREEMAIL_ENVFROM_END_DIGIT,SPF_NEUTRAL,URI_HEX
X-Spam-Check-By: apache.org
Received-SPF: neutral (nike.apache.org: 216.139.236.26 is neither permitted
 nor denied by domain of darpan27484@gmail.com)
Received: from [216.139.236.26] (HELO sam.nabble.com) (216.139.236.26)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 16 May 2012 14:40:18 +0000
Received: from [192.168.236.26] (helo=sam.nabble.com)
	by sam.nabble.com with esmtp (Exim 4.72)
	(envelope-from <darpan27484@gmail.com>)
	id 1SUfOP-0005Hm-FA
	for users@camel.apache.org; Wed, 16 May 2012 07:39:57 -0700
Date: Wed, 16 May 2012 07:39:57 -0700 (PDT)
From: dmhatre <darpan27484@gmail.com>
To: users@camel.apache.org
Message-ID: <1337179197460-5710917.post@n5.nabble.com>
In-Reply-To: 
 <CALvzYd-it2qW15xxHSed27ZVucfpHRcjeR3u-ZjuaMjo4T=PmA@mail.gmail.com>
References: <1337098657991-5710187.post@n5.nabble.com>
 <CALvzYd-it2qW15xxHSed27ZVucfpHRcjeR3u-ZjuaMjo4T=PmA@mail.gmail.com>
Subject: Re: Help with error while implementing camel jpa
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hello Christian,
       Thank you for the reply. I got this working. I am not getting this
error no more.
But still I am pasting my code snippet so that you can have a look and let
me know if this is the right way to do the things OR if its right, some
other users who come across this problem can use this.

MY ROUTE:
=================
<route>
  <from
uri="jpa:org.apache.camel.example.spring.DarpanTest?consumer.query=select o
from  
darpantesto&amp;consumeDelete=false&amp;maxMessagesPerPoll=5&amp;maximumResults=5"/>
  <to uri="bean:jpatest?method=readContent"/>
</route>

BEANS:
=================

  <bean id="jpatest" class="org.apache.camel.example.spring.JPATest"/>

  <bean id="jpa" class="org.apache.camel.component.jpa.JpaComponent">
    <property name="entityManagerFactory" ref="entityManagerFactory"/>
  </bean>

  <bean id="transactionTemplate"
class="org.springframework.transaction.support.TransactionTemplate">
    <property name="transactionManager">
      <bean class="org.springframework.orm.jpa.JpaTransactionManager">
        <property name="entityManagerFactory" ref="entityManagerFactory"/>
      </bean>
    </property>
  </bean>

  <bean id="jpaTemplate" class="org.springframework.orm.jpa.JpaTemplate">
    <property name="entityManagerFactory" ref="entityManagerFactory"/>
  </bean>

   <bean id="entityManagerFactory"
class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
    <property name="persistenceUnitName" value="camel"/>
    <property name="jpaVendorAdapter" ref="jpaAdapter"/>
    <property name="dataSource" ref="dataSource" />
  </bean>
  
  <bean id="jpaAdapter"
class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
    <property name="databasePlatform"
value="org.hibernate.dialect.Oracle10gDialect" />
  </bean>
  
  <bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"
/>
    <property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:SWQA" />
    <property name="username" value="" />
    <property name="password" value="" />
 </bean> 

persistence.xml
===============================
<persistence xmlns="http://java.sun.com/xml/ns/persistence"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             version="1.0">

  <persistence-unit name="camel" transaction-type="RESOURCE_LOCAL">
  
    <class>org.apache.camel.example.spring.DarpanTest</class>

    <properties>
      <property name="hibernate.archive.autodetection" value="class"/>
      <property name="hibernate.show_sql" value="true"/>
      <property name="hibernate.format_sql" value="true"/> 
    </properties>

  </persistence-unit>
</persistence>


ENTITY:
=========================
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity(name="darpantest")
@Table(name="darpantest")
public class DarpanTest {

	@Id
	@Column(name="testid")
	private long testid;

	@Column(name="testname")
	private String testname;

    public DarpanTest() {
    }

	public long getTestid() {
		return testid;
	}

	public void setTestid(long testid) {
		this.testid = testid;
	}

	public String getTestname() {
		return testname;
	}

	public void setTestname(String testname) {
		this.testname = testname;
	}
}

BEAN:
======================
public class JPATest {

public void readContent(Exchange test) {
		
		Object obj = test.getIn().getBody();
		DarpanTest d = (DarpanTest)obj;
		System.out.println("########"+d.getTestid()+"#######");
		System.out.println("########"+d.getTestname()+"#########");
	}
}

--
View this message in context: http://camel.465427.n5.nabble.com/Help-with-error-while-implementing-camel-jpa-tp5710187p5710917.html
Sent from the Camel - Users mailing list archive at Nabble.com.