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 <[EMAIL PROTECTED]> 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?
>
