ibatis-user-cs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tony Wang" <tw...@quatrogroup.com>
Subject Default Schema Name
Date Fri, 16 Mar 2007 19:45:57 GMT
Hi,

 

My application login user is not a schema owner, every time I have to prefix
a table name

by the schema to write a SQL statement, for example:

 

                        SELECT * FROM SCHEMA_USER.USERS;

                        SELECT * FROM SCHEMA_USER.DUAL;

 

I wish I can specify the schema name in a config file and iBatis apply it to
the SQL statements.

This will not only save a lot of typing, but also ease the migration from
one database to another 

(I am planning to support not only Oracle, but also SQL server soon after
the Oracle version completes)

 

 

Thanks,

 

Tony

 


Mime
View raw message