Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 27145 invoked from network); 25 Dec 2005 19:45:26 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 25 Dec 2005 19:45:26 -0000 Received: (qmail 18392 invoked by uid 500); 25 Dec 2005 19:45:25 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 18358 invoked by uid 500); 25 Dec 2005 19:45:24 -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 18347 invoked by uid 99); 25 Dec 2005 19:45:23 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 25 Dec 2005 11:45:23 -0800 X-ASF-Spam-Status: No, hits=0.5 required=10.0 tests=DNS_FROM_RFC_ABUSE X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [68.142.207.234] (HELO web32607.mail.mud.yahoo.com) (68.142.207.234) by apache.org (qpsmtpd/0.29) with SMTP; Sun, 25 Dec 2005 11:45:22 -0800 Received: (qmail 97549 invoked by uid 60001); 25 Dec 2005 19:45:01 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=3zpjJl5KHCaWdF/AbOuSmNqj4NdL0VVDA38pDpQMKMItuPuQnGhK2J7idZLkn9Mc/QXmHYrTXT3mgQvXDIn3hd7fDotyGZL36yTXHM773jqRQNZsjczsSpFbIe0W20drDh0qwHFq9uvpP1y8Gx47u4YTcCD4miDqglbHh9kAckY= ; Message-ID: <20051225194501.97540.qmail@web32607.mail.mud.yahoo.com> Received: from [65.30.71.168] by web32607.mail.mud.yahoo.com via HTTP; Sun, 25 Dec 2005 11:45:01 PST Date: Sun, 25 Dec 2005 11:45:01 -0800 (PST) From: Paul Benedict Subject: Re: specify the database schema in sqlMap? To: user-java@ibatis.apache.org In-Reply-To: <006201c60937$26229650$8400a8c0@thurm> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Thurm, With iBATIS, you control the query. You only need to specify the schema if you're accessing tables outside the application's preset schema. If you're talking to other schemas, then yes you will have to write out the schema - but 99% of the time I never had to. I usually deal with one schema. Paul __________________________________________ Yahoo! DSL � Something to write home about. Just $16.99/mo. or less. dsl.yahoo.com