Return-Path: Delivered-To: apmail-ibatis-dev-archive@www.apache.org Received: (qmail 57206 invoked from network); 31 Jul 2006 03:05:34 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 31 Jul 2006 03:05:34 -0000 Received: (qmail 66491 invoked by uid 500); 31 Jul 2006 03:05:33 -0000 Delivered-To: apmail-ibatis-dev-archive@ibatis.apache.org Received: (qmail 66468 invoked by uid 500); 31 Jul 2006 03:05:33 -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 66457 invoked by uid 99); 31 Jul 2006 03:05:33 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 30 Jul 2006 20:05:33 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= 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; Sun, 30 Jul 2006 20:05:32 -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: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Date: Mon, 31 Jul 2006 12:05:10 +0900 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Mapping objects from CSV files. (.Net) thread-index: AcazKZVdTe0Z/0ZxQieVbgTuzRGN0gBI0VSw 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 Thanks, that was the tip I needed to get running. I was trying to create a new DataSource object (and DbProvider became a null value). Setting a new connectionstring seems to be working fine. I've subscribed to the user list and will use it properly from now on. Sorry for the mix-up. --=20 PM=20 -----Original Message----- From: Ron Grabowski [mailto:rongrabowski@yahoo.com]=20 Sent: Sunday, July 30, 2006 01:11 To: dev@ibatis.apache.org Subject: RE: Mapping objects from CSV files. (.Net) The SqlMap.config file requires the dataSource node have a value. What I do is set the connectionString to "..." and after my ISqlMapper instance has been built, I let the application set the real value: sqlMapper.DataSource.ConnectionString =3D getConnectionString(); Does that help? --- Per Magne Bjornerud wrote: > 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 > =20 >=20 > Do you have any links to documentation about how I can dynamically > set > the datasource for my SqlMapper?=20 >=20 > =20 >=20 > I'll ponder it over the weekend. Thanks for the info so far :) >=20 > =20 >=20 > --=20 >=20 > Per Magne >=20 > =20 >=20 > =20 >=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 > =20 >=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 > =20 >=20 > set the connection sting >=20 > set the sql statement in your mapping file >=20 > set you parameter map, result map >=20 > and go >=20 > --=20 > Cheers, > Gilles >=20 > Wish List =20 >=20 >=20