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 Pham Anh Tuan <an...@ichi-corp.jp> on 2006/06/22 03:27:28 UTC
[HELP] Does iBatis support multi DB ?
Hi all,
I wonder can I use iBatis in a web app which uses multi datasource (DB) ?
help me, thanks in advance!
bowlkhin
Re: UNSCRIBE
Posted by Larry Meadors <lm...@apache.org>.
user-java-unsubscribe@ibatis.apache.org is your friend, use it.
On 6/21/06, Makunda Thapa <ma...@hotmail.com> wrote:
> UNSCRIBE THIS USER GROUP
>
> _________________________________________________________________
> Express yourself instantly with MSN Messenger! Download today - it's FREE!
> http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>
>
Re: [HELP] Does iBatis support multi DB ?
Posted by Clinton Begin <cl...@gmail.com>.
Yeah, 1 millon records would be a bad idea regardless of iBATIS or any other
technology you're using.
iBATIS supports pagination through queryForList() using offset and length
type parameters to ensure you only get back a certain number of rows. But
DO NOT use PaginatedList for such a thing.
More importantly, SQL has a neat feature called a "WHERE" clause. ;-) Use
it. Don't ever return that many rows.
Really though, unless you're building the next Google....I'd really wonder
why you'd ever have or need 1 Million rows in an OLTP system.... (which I'm
assuming if you're using Tomcat -- it's not a reporting or ETL program).
Anyway, just some things to think about.
Clinton
On 6/21/06, Pham Anh Tuan <an...@ichi-corp.jp> wrote:
>
> oh, thank you, Clinton :)
>
> I have one more question, if there's one query which retrieve 1 million
> records, what happens?, will my web application be out of heap space :? I
> use Tomcat
>
> thanks in advance :)
>
> ----- Original Message -----
> *From:* Clinton Begin <cl...@gmail.com>
> *To:* user-java@ibatis.apache.org
> *Sent:* Thursday, June 22, 2006 8:36 AM
> *Subject:* Re: [HELP] Does iBatis support multi DB ?
>
> Yes, the same way JDBC supports multiple databases.
>
> SQL Maps doesn't do anything special, but there's no reason you can't use
> it with multiple databases in a single application.
>
> The DAO framework though, does allow you to configure multiple database
> contexts within a single DAO factory.
>
> Cheers,
> Clinton
>
> On 6/21/06, Pham Anh Tuan <an...@ichi-corp.jp> wrote:
> >
> > Hi all,
> >
> > I wonder can I use iBatis in a web app which uses multi datasource (DB)
> > ?
> >
> > help me, thanks in advance!
> >
> > bowlkhin
> >
>
>
UNSCRIBE
Posted by Makunda Thapa <ma...@hotmail.com>.
UNSCRIBE THIS USER GROUP
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
Re: [HELP] Does iBatis support multi DB ?
Posted by Pham Anh Tuan <an...@ichi-corp.jp>.
oh, thank you, Clinton :)
I have one more question, if there's one query which retrieve 1 million records, what happens?, will my web application be out of heap space :? I use Tomcat
thanks in advance :)
----- Original Message -----
From: Clinton Begin
To: user-java@ibatis.apache.org
Sent: Thursday, June 22, 2006 8:36 AM
Subject: Re: [HELP] Does iBatis support multi DB ?
Yes, the same way JDBC supports multiple databases.
SQL Maps doesn't do anything special, but there's no reason you can't use it with multiple databases in a single application.
The DAO framework though, does allow you to configure multiple database contexts within a single DAO factory.
Cheers,
Clinton
On 6/21/06, Pham Anh Tuan <an...@ichi-corp.jp> wrote:
Hi all,
I wonder can I use iBatis in a web app which uses multi datasource (DB) ?
help me, thanks in advance!
bowlkhin
Re: [HELP] Does iBatis support multi DB ?
Posted by Clinton Begin <cl...@gmail.com>.
Yes, the same way JDBC supports multiple databases.
SQL Maps doesn't do anything special, but there's no reason you can't use it
with multiple databases in a single application.
The DAO framework though, does allow you to configure multiple database
contexts within a single DAO factory.
Cheers,
Clinton
On 6/21/06, Pham Anh Tuan <an...@ichi-corp.jp> wrote:
>
> Hi all,
>
> I wonder can I use iBatis in a web app which uses multi datasource (DB) ?
>
> help me, thanks in advance!
>
> bowlkhin
>