Return-Path: Delivered-To: apmail-ibatis-dev-archive@www.apache.org Received: (qmail 35888 invoked from network); 28 Jul 2006 07:37:41 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 28 Jul 2006 07:37:41 -0000 Received: (qmail 70980 invoked by uid 500); 28 Jul 2006 07:37:41 -0000 Delivered-To: apmail-ibatis-dev-archive@ibatis.apache.org Received: (qmail 70889 invoked by uid 500); 28 Jul 2006 07:37:40 -0000 Mailing-List: contact dev-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@ibatis.apache.org Delivered-To: mailing list dev@ibatis.apache.org Received: (qmail 70878 invoked by uid 99); 28 Jul 2006 07:37:40 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 28 Jul 2006 00:37:40 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [219.118.179.206] (HELO socrates.interlect.co.jp) (219.118.179.206) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 28 Jul 2006 00:37:38 -0700 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message Subject: RE: Mapping objects from CSV files. (.Net) MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C6B218.A716B8E2" Date: Fri, 28 Jul 2006 16:37:17 +0900 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Mapping objects from CSV files. (.Net) thread-index: AcayEM+KZFbX/fc/S6ee2WsiStQp3AABly6Q From: "Per Magne Bjornerud" To: X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N This is a multi-part message in MIME format. ------_=_NextPart_001_01C6B218.A716B8E2 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I think my main problem is understanding how I specify the datasource at run time. At the moment, I'm only using a hardcoded value in my sqlMap.config, like the tutorial, and don't know where to start looking to do it any other way. =20 Do you have any links to documentation about how I can dynamically set the datasource for my SqlMapper?=20 =20 I'll ponder it over the weekend. Thanks for the info so far :) =20 --=20 Per Magne =20 =20 ________________________________ From: Gilles Bayon [mailto:ibatis.net@gmail.com]=20 Sent: Friday, July 28, 2006 15:41 To: dev@ibatis.apache.org Subject: Re: Mapping objects from CSV files. (.Net) =20 You just have to use the CSV file as a database (forget that the DataSource is flat file, you are just using an ADO.NET OLEDB provider as Access). =20 set the connection sting set the sql statement in your mapping file set you parameter map, result map and go --=20 Cheers, Gilles Wish List =20 ------_=_NextPart_001_01C6B218.A716B8E2 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I think my main problem is understanding how I = specify the datasource at run time. At the moment, I’m only using a = hardcoded value in my sqlMap.config, like the tutorial, and don’t know where = to start looking to do it any other way.

Do you have any links to documentation about = how I can dynamically set the datasource for my SqlMapper? =

I’ll ponder it over the weekend. Thanks = for the info so far :)

Per Magne

From: Gilles Bayon [mailto:ibatis.net@gmail.com]
Sent: Friday, July 28, = 2006 15:41
To: = dev@ibatis.apache.org
Subject: Re: Mapping = objects from CSV files. (.Net)

You just have to use the CSV file as a = database (forget that the DataSource is flat file, you are just using an ADO.NET OLEDB provider as = Access).

set the connection = sting

set the sql statement in your mapping = file

set you parameter map, result = map

and go

--
Cheers,
Gilles

Wish List

------_=_NextPart_001_01C6B218.A716B8E2--