Return-Path: 
 <user-java-return-11088-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 53861 invoked from network); 20 Mar 2007 14:48:00 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 20 Mar 2007 14:48:00 -0000
Received: (qmail 14189 invoked by uid 500); 20 Mar 2007 14:48:03 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 14143 invoked by uid 500); 20 Mar 2007 14:48:03 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 14107 invoked by uid 99); 20 Mar 2007 14:48:02 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 Mar 2007 07:48:02 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=SPF_PASS,UNPARSEABLE_RELAY
X-Spam-Check-By: apache.org
Received-SPF: pass (herse.apache.org: domain of clamey@localmatters.com
 designates 216.241.189.144 as permitted sender)
Received: from [216.241.189.144] (HELO mailhost01.ad.corp.localmatters.com)
 (216.241.189.144)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 Mar 2007 07:47:51 -0700
Received: from 10.203.252.6 ([10.203.252.6]) by
 mailhost01.ad.corp.localmatters.com ([10.200.4.32]) with Microsoft Exchange
 Server HTTP-DAV ;
 Tue, 20 Mar 2007 14:43:24 +0000
Received: from dev02lt by webmail.localmatters.com; 20 Mar 2007 08:47:23 -0600
Subject: Re: Abator generated SqlMap.xml files
From: Chris Lamey <clamey@localmatters.com>
Reply-To: clamey@localmatters.com
To: user-java@ibatis.apache.org
In-Reply-To: <c593b8750703200517o226e04b4v96a2d17ed726f00e@mail.gmail.com>
References: <82E9651E-127F-45F3-90B9-BD827D1665C0@ociweb.com>
	 <c593b8750703200517o226e04b4v96a2d17ed726f00e@mail.gmail.com>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Organization: Local Matters, Inc.
Date: Tue, 20 Mar 2007 08:47:23 -0600
Message-Id: <1174402043.9292.3.camel@localhost.localdomain>
Mime-Version: 1.0
X-Mailer: Evolution 2.6.3 (2.6.3-1.fc5.5) 
X-Virus-Checked: Checked by ClamAV on apache.org

I use Postgres with Abator and don't have the db name in the
$TABLE_SqlMap.xml file names.  Here's what one of my table elements
looks like:

    <table schema="" tableName="SUGGESTION"
domainObjectName="Suggestion">
        <property name="useActualColumnNames" value="false"/>
    </table>

The schema is then specified on the JDBC URL
(connectionURL="jdbc:postgresql://localhost/suggestions"), like Jeff
said.

Cheers,
Chris

On Tue, 2007-03-20 at 07:17 -0500, Jeff Butler wrote:
> Abator only uses the catalog and schema in the file names if you
> specify them in your configuration.  I don't know Postgres, but with
> SQL Server you can leave the catalog out of the <table> configuration
> elements and specify the default database name on the connection URL.
>  
> Jeff Butler
> 
>  
> On 3/19/07, Mark Volkmann <mark@ociweb.com> wrote: 
>         When I run Abator against a MySQL database I get files with
>         names
>         like {table-name}_SqlMap.xml.
>         When I run against Postgres or SQL Server I get files with
>         names like 
>         {database_name}_{table-name}_SqlMap.xml.
>         Is there anything I can do to get Abator to not add the
>         database name
>         prefix for Postgres and SQL Server so I don't have to change
>         my code
>         when the database type changes? 
>