Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 62158 invoked from network); 30 Jun 2005 04:08:03 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 30 Jun 2005 04:08:03 -0000 Received: (qmail 21421 invoked by uid 500); 30 Jun 2005 04:08:01 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 21399 invoked by uid 500); 30 Jun 2005 04:08:00 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 21385 invoked by uid 99); 30 Jun 2005 04:08:00 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 Jun 2005 21:08:00 -0700 X-ASF-Spam-Status: No, hits=0.5 required=10.0 tests=HTML_30_40,HTML_MESSAGE,PLING_PLING,RCVD_BY_IP X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of clinton.begin@gmail.com designates 64.233.184.198 as permitted sender) Received: from [64.233.184.198] (HELO wproxy.gmail.com) (64.233.184.198) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 Jun 2005 21:08:03 -0700 Received: by wproxy.gmail.com with SMTP id i23so31928wra for ; Wed, 29 Jun 2005 21:07:59 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:references; b=QK2PWVMqhlsHQbie/M5oZ4b2H7H0iQNSb6tct6YavC7RS0mqgF9qnX5i2PQM+Qiku5SObgaAiBNbrtw4s9lAcUyoVz441q+pHQ+Q+b8o2j18ArGTVI3qDCLhOXhbAaID7Fo3jzSQG07mCYO1uQnOUCTKqfeuU6IH9la/WAnUcqc= Received: by 10.54.40.58 with SMTP id n58mr179099wrn; Wed, 29 Jun 2005 21:07:59 -0700 (PDT) Received: by 10.54.93.11 with HTTP; Wed, 29 Jun 2005 21:07:59 -0700 (PDT) Message-ID: <16178eb1050629210746389cee@mail.gmail.com> Date: Wed, 29 Jun 2005 22:07:59 -0600 From: Clinton Begin Reply-To: cbegin@ibatis.com To: user-java@ibatis.apache.org Subject: Re: Returning Results from queries of a parameterized table name!!! In-Reply-To: <42c30525.27179c0b.4ca7.01c6@mx.gmail.com> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_12601_23683930.1120104479470" References: <42c30525.27179c0b.4ca7.01c6@mx.gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N ------=_Part_12601_23683930.1120104479470 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Can you post the exception? On 6/29/05, Folashade Adeyosoye wrote: >=20 > This works fine, the problem is it throws an exception at the very last > record that it tries to put in the Map. >=20 > What list are you referring to? >=20 > -----Original Message----- > From: Larry Meadors [mailto:larry.meadors@gmail.com] > Sent: Wednesday, June 29, 2005 4:02 PM > To: user-java@ibatis.apache.org > Subject: Re: Returning Results from queries of a parameterized table=20 > name!!! >=20 > Good grief, why are you reinventing the wheel? >=20 > I guess you can iterate through the list, then iterate through the > maps in the list, examining the types of the entries, escaping the > strings/numbers/dates, etc into a text file...but man, that sure seems > like a ton of work. >=20 > Larry >=20 >=20 > On 6/29/05, Folashade Adeyosoye wrote: > > > > > > > > Hi all, > > > > > > > > I the last couple of days I have been spinning my wheel on this.. > > > > > > > > My parameterObject are table names and I can get it to execute > > > > > > > > JAVA > > > > Map hash =3D new HashMap(); > > > > hash =3D (Map)super.getObject("systemDatabaseBackup", > > parameterObject); > > > > > > > > > > > > SQLMAP > > > > > > > > > > > > > > > > Am trying to get all the records from the table and its column names, A= m > > using this as a small database backup utility, I parse the column names > and > > its corresponding values and write these out to a file in a form of=20 > insert > > into $tabel_name$ (1,2,3) value (1a,2a,3a); > > > > > > > > Has anyone done this before? >=20 > ------=_Part_12601_23683930.1120104479470 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
Can you post the exception?


On 6/29/05, Folashade Adeyosoye <= shardayyy@gmail.com> wrote:
This works fine,  the problem is it throws an exception at the ve= ry last
record that it tries to put in the Map.

What list are you= referring to?

-----Original Message-----
From: Larry Meadors [ma= ilto: larry.meadors@gmail.com]
Sent: Wednesday, June 29, 2005 4:02 PM
T= o: user-java@ibatis.apache.o= rg
Subject: Re: Returning Results from queries of a parameterized ta= ble name!!!

Good grief, why are you reinventing the wheel?

I guess you c= an iterate through the list, then iterate through the
maps in the list, = examining the types of the entries, escaping the
strings/numbers/dates, = etc into a text file...but man, that sure seems
like a ton of work.

Larry


On 6/29/05, Folashade Adeyo= soye <shardayyy@gmail.com>= wrote:
>
>
>
> Hi all,
>
>
>
> I the last couple of days I have been spinning my wheel on this..
&= gt;
>
>
> My parameterObject are table names and I can ge= t it to execute
>
>
>
> JAVA
>
> &= nbsp; Map hash =3D new HashMap();
>
>   hash =3D (Map)super.getObject("systemData= baseBackup",
> parameterObject);
>
>
>
>=
>
> SQLMAP
>
>   <select id=3D"s= ystemDatabaseBackup" resultClass=3D" java.util.Map"
> parameterClass=3D"string" remapResult= s=3D"true">
>
>     SELECT * F= ROM $value$
>
>   </select>
>
>
= >
>
>
> Am trying to get all the records from the tabl= e and its column names, Am
> using this as a small database backup utility, I parse the column = names
and
> its corresponding values and write these out to a file= in a form of insert
> into $tabel_name$ (1,2,3) value (1a,2a,3a);
>
>
>
> Has anyone done this before?


------=_Part_12601_23683930.1120104479470--