Return-Path: 
 <ibatis-user-java-return-2571-apmail-incubator-ibatis-user-java-archive=incubator.apache.org@incubator.apache.org>
Delivered-To: apmail-incubator-ibatis-user-java-archive@www.apache.org
Received: (qmail 92619 invoked from network); 29 May 2005 10:10:57 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 29 May 2005 10:10:57 -0000
Received: (qmail 47461 invoked by uid 500); 29 May 2005 10:10:55 -0000
Delivered-To: apmail-incubator-ibatis-user-java-archive@incubator.apache.org
Received: (qmail 47447 invoked by uid 500); 29 May 2005 10:10:55 -0000
Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ibatis-user-java@incubator.apache.org
List-Help: <mailto:ibatis-user-java-help@incubator.apache.org>
List-Unsubscribe: <mailto:ibatis-user-java-unsubscribe@incubator.apache.org>
List-Post: <mailto:ibatis-user-java@incubator.apache.org>
List-Id: <ibatis-user-java.incubator.apache.org>
Delivered-To: mailing list ibatis-user-java@incubator.apache.org
Delivered-To: moderator for ibatis-user-java@incubator.apache.org
Received: (qmail 64795 invoked by uid 99); 27 May 2005 12:31:23 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
X-Authentication-Warning: rzis5.rz.tu-bs.de: apache set sender to
 s.legler@tu-bs.de using -f
Message-ID: <1117196805.42971205c34c1@webmail.tu-bs.de>
Date: Fri, 27 May 2005 14:26:45 +0200
From: Steffen Legler <s.legler@tu-bs.de>
To: ibatis-user-java@incubator.apache.org
Subject: Dynamically add sqlMaps to Config.xml
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 3.1
X-Originating-IP: 62.48.69.202
X-PerlMx-Spam: Gauge=IIIIIII, Probability=7%, Report='__CT 0, __CTE 0,
 __CT_TEXT_PLAIN 0, __HAS_MSGID 0, __MIME_VERSION 0, __SANE_MSGID 0'
X-Virus-Checked: Checked
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Hi.

We need to add dynamically sqlMaps to our SqlMapClient.
Please can you implement something like this example in further releases?

Example:
 sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(configReader, props);
 sqlMapClient.addResource(xyz.xml)

Dynamically build SQL-Statements include a lot of spaces when using conditional
Elements like <isEqual>. The Database doesn't care, but for logging it would be
nice to have a well written sql-statement.

<update id="update" parameterClass="class">
 update table set
 <isEqual property="unit_type_selectionId" compareValue="2">
  column=#column#
 </isEqual>
 <isEqual property="unit_type_selectionId" compareValue="2">
  column1=#column#
 </isEqual>
where id=#id#
</update>

Sql-Statement:
         update table set              column=#column#        where id=#id#

Hope its possible to implement this two functions in future releases.

Thanks,
Steffen