Return-Path: 
 <camel-user-return-3680-apmail-activemq-camel-user-archive=activemq.apache.org@activemq.apache.org>
Delivered-To: apmail-activemq-camel-user-archive@locus.apache.org
Received: (qmail 80743 invoked from network); 8 Oct 2008 04:18:47 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 8 Oct 2008 04:18:47 -0000
Received: (qmail 90801 invoked by uid 500); 8 Oct 2008 04:18:45 -0000
Delivered-To: apmail-activemq-camel-user-archive@activemq.apache.org
Received: (qmail 90782 invoked by uid 500); 8 Oct 2008 04:18:45 -0000
Mailing-List: contact camel-user-help@activemq.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:camel-user-help@activemq.apache.org>
List-Unsubscribe: <mailto:camel-user-unsubscribe@activemq.apache.org>
List-Post: <mailto:camel-user@activemq.apache.org>
List-Id: <camel-user.activemq.apache.org>
Reply-To: camel-user@activemq.apache.org
Delivered-To: mailing list camel-user@activemq.apache.org
Received: (qmail 90771 invoked by uid 99); 8 Oct 2008 04:18:45 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 07 Oct 2008 21:18:45 -0700
X-ASF-Spam-Status: No, hits=0.3 required=10.0
	tests=DNS_FROM_SECURITYSAGE,SPF_PASS,WHOIS_MYPRIVREG
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: local policy)
Received: from [195.69.129.177] (HELO exsmtp01.exserver.dk) (195.69.129.177)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 08 Oct 2008 04:17:40 +0000
Received: from EXVS04.exserver.dk ([10.10.10.84]) by exsmtp01.exserver.dk with
 Microsoft SMTPSVC(6.0.3790.1830);
	 Wed, 8 Oct 2008 06:15:22 +0200
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: RE: a full ibatis example?
Date: Wed, 8 Oct 2008 06:17:27 +0200
Message-ID: <4C1FB9C00D24A140906239533638C4D2058FBF01@EXVS04.exserver.dk>
In-Reply-To: <19857166.post@talk.nabble.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: a full ibatis example?
Thread-Index: AckoeP+vm8Ob4tcMRQepol+8qfi98QAgw1aQ
From: "Claus Ibsen" <ci@silverbullet.dk>
To: <camel-user@activemq.apache.org>
X-OriginalArrivalTime: 08 Oct 2008 04:15:22.0083 (UTC)
 FILETIME=[7B36D330:01C928FC]
X-Virus-Checked: Checked by ClamAV on apache.org

Hi=20

Camel will by default look for SqlMapConfig.xml in the root classpath. =
So you can copy it to src/main/resources

But if you want to provide a "relationship" then you actually need to =
use the IBatisComponent where it has a setter method.

You can define the component in your spring xml

<bean id=3D"ibatis" class=3D"org.apache....IBatisComponent">
    <property name=3D"sqlMapResource" =
value=3D"classpath:WhereIsMyFile.xml"/>
</bean>

The type of sqlMapResource is a spring io Resource so you can have the =
classpath or filepath prefix.=20


Could you try it out and report how it goes. Then I can update our wiki =
documentation for ibatis:
http://activemq.apache.org/camel/ibatis.html


Med venlig hilsen
=20
Claus Ibsen
......................................
Silverbullet
Skovsg=E5rdsv=E6nget 21
8362 H=F8rning
Tlf. +45 2962 7576
Web: www.silverbullet.dk
-----Original Message-----
From: Reda [mailto:matteo.redaelli@libero.it]=20
Sent: 7. oktober 2008 14:36
To: camel-user@activemq.apache.org
Subject: RE: a full ibatis example?


Thanks for your suggestion. If I was able to build a working example I =
would
create a tutorial..;-) But I need more help.

I think I should add in camel-context the relationship between the =
following
route and the iBatis configuration SqlMapConfig.xml

        from("timer://pollTheDatabase?delay=3D10000").
        	to("ibatis:selectAllUsers").
        	bean(new SomeBean());


My project layout is the following

src/main/java/org/apache/camel/example/spring/MyRouteBuilder.java
src/main/java/org/apache/camel/example/spring/User.java
src/main/resources/pirelli/elearning/ibatis/User.xml
src/main/resources/META-INF/spring/camel-context.xml
src/main/resources/SqlMapConfig.xml
src/main/resources/log4j.properties

--=20
View this message in context: =
http://www.nabble.com/a-full-ibatis-example--tp19709868s22882p19857166.ht=
ml
Sent from the Camel - Users mailing list archive at Nabble.com.