Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: domain of clamey@localmatters.com
 designates 216.241.189.144 as permitted sender)
User-Agent: Microsoft-Entourage/11.3.6.070618
Date: Wed, 18 Jun 2008 10:23:46 -0600
Subject: Re: Check if query exists before executing
From: Christopher Lamey <clamey@localmatters.com>
To: <user-java@ibatis.apache.org>
Message-ID: <C47E92B2.6AD4%clamey@localmatters.com>
Thread-Topic: Check if query exists before executing
Thread-Index: AcjRX66D7OqilD1SEd2tvwAbY5caEQ==
In-Reply-To: <3444c5f90806180825l588e6f9dub529c6d3423059f6@mail.gmail.com>
Mime-version: 1.0
Content-type: text/plain;
	charset="US-ASCII"
Content-transfer-encoding: 7bit

You could look at the database metadata through the Connection:

    sqlMapClient.getCurrentConnection().getMetaData().getDatabaseXXX()

And then use that to call either the Oracle or generic sql.

I personally wouldn't go that route because Oracle might change their
metadata so it'd break your code.

I'd probably go with some kind of application config that's defined along
with the DataSource (JNDI, Spring, properties file, whatever):

database.vendor=Oracle

And then specifically look for that in my code.

On 6/18/08 9:25 AM, "Julio Faerman" <jfaerman@gmail.com> wrote:

> Hello,
> 
> I would like to know if is it possible to check if a query exists
> before executing it.
> For example, if i am using oracle and have a optimezed query for
> oracle, i would like to run:
> 
> sqlMapClient.queryForList("myQuery.oracle");
> 
> if there is no special query for oracle, i would like to run just the
> standard query:
> 
> sqlMapClient.queryForList("myQuery");
> 
> is it possible to do something like "sqlMapClient.exists/contais(query)" ?
> 
> Thank you,
> Julio