You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by HEATLAMP <ji...@yahoo.com> on 2008/07/27 23:04:21 UTC
Dynamic DDL with iBatis
I'm a iBATIS novice, evaluating it and other O/R solutions for possible use
in a system where new database tables are created, and existing tables
modified, throughout the processing day. (I know this is a messy thing to
do in any case, but the tables are generated and queried by customers, and
are key to this design.)
It iBATIS a non-starter in a system like this? If not, how do I effect
online schema changes?
Thanks, Jim
--
View this message in context: http://www.nabble.com/Dynamic-DDL-with-iBatis-tp18680516p18680516.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
Re: Dynamic DDL with iBatis
Posted by Clinton Begin <cl...@gmail.com>.
iBATIS doesn't care about the tables as much as it does the inputs and
outputs... if the result set and parameters remain consistent, then you can
dynamically pass the table name(s) as parameters. The number and
organization of tables should remain consistent as well..
Also, realize that the built-in caching may not be suitable for you, so a
custom solution may be beneficial.
Do some testing and see how it goes.
Clinton
On Sun, Jul 27, 2008 at 3:04 PM, HEATLAMP <ji...@yahoo.com> wrote:
>
> I'm a iBATIS novice, evaluating it and other O/R solutions for possible use
> in a system where new database tables are created, and existing tables
> modified, throughout the processing day. (I know this is a messy thing to
> do in any case, but the tables are generated and queried by customers, and
> are key to this design.)
>
> It iBATIS a non-starter in a system like this? If not, how do I effect
> online schema changes?
>
> Thanks, Jim
> --
> View this message in context:
> http://www.nabble.com/Dynamic-DDL-with-iBatis-tp18680516p18680516.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>