Another thought is that most JDBC drivers allow you to set a default schema
as a driver property.  Using this approach, you could write all your SQL
without any schema at all and change to the proper schema based on driver
properties in the datasource.

Jeff Butler

On Nov 13, 2007 10:09 AM, Niels Beekman <[EMAIL PROTECTED]> wrote:

>  I think the schema in question is a DB-schema which afaik, is only
> injectable using the configuration file solution, because iBATIS does not
> modify the SQL statements you write in any way.
>
>
>
> Niels
>  ------------------------------
>
> *From:* Carlos de Luna Saenz [mailto:[EMAIL PROTECTED]
> *Sent:* dinsdag 13 november 2007 16:56
> *To:* [email protected]
> *Subject:* Re: Setting schema name
>
>
>
> Yes, use something like this:
>
> <?xml version="1.0" encoding="UTF-8"?>
>
> <!DOCTYPE sqlMap
>
> PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
>
> "dtd/sql-map-2.dtd">
>
> and put your file inside the dtd directory... i have a resource directory
> that eclipse recognize as a source directory.
>
> Greetings
>
> ----- Mensaje original ----
> De: "[EMAIL PROTECTED]" <
> [EMAIL PROTECTED]>
> Para: [email protected]
> Enviado: martes, 13 de noviembre, 2007 3:01:03
> Asunto: Setting schema name
>
>
> Hi,
>
> Is there a way to set the schema name using some Java code instead of
> setting it inside the iBatis configuration file?
>
> Walter
>
>
>
>
>  ------------------------------
>
>
> Comparte video en la ventana de tus mensajes (y también tus fotos de
> Flickr).
> Usa el nuevo Yahoo! Messenger versión Beta.
> Visita http://e1.beta.messenger.yahoo.com/
>

Reply via email to