ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <lmead...@apache.org>
Subject Re: Ibatis and the blob
Date Mon, 18 Sep 2006 16:04:46 GMT
I would agree if this was not a continuation of the the "Analyze of a
Blob" thread - which from what I understand isn't talking about
serving media from the database, but instead we are talking about
getting fielded data from 20 MB BLOB.

Larry


On 9/18/06, Clinton Begin <clinton.begin@gmail.com> wrote:
>
> Well, to be fair Larry, there is data that is stored in databases that
> cannot be broken up -- not with an RDBMS or with Prevayler or anything else.
>
> Movies, music, images, you know...porn.  j/k ;-)
>
> Seriously though, this is a valid requirement, it's just not something that
> needs to be "mapped" with iBATIS or anything else.   It's data meant for raw
> streaming to the client.
>
> Now, if it's 20MB worth of XML, then I'd be worried.
>
> Cheers,
> Clinton
>
>
>
> On 9/18/06, Larry Meadors < lmeadors@apache.org> wrote:
> > Well, without knowing more of the requirements, it's hard to say, but
> > in almost all cases, the first step would be to break it into
> > managable components and data structures.
> >
> > A 20MB blob is not a data structure.
> >
> > Maybe you are looking for something more like Prevayler.
> >
> > Larry
> >
> >
> > On 9/18/06, soussou97 <dboussebha@yahoo.fr> wrote:
> > >
> > > Hi Larry
> > >
> > > I have realized of performance with Ibatis and JDBC for getting of BLOB,
> in
> > > conclusion when the size is important, Ibatis is not adapted for this
> kind
> > > of situation.
> > > For your question : "Reading a 20M blob to create objects? This just
> sounds
> > > to me like an
> > > application from Hell"
> > > Which solution you propose ?
> > >
> > > Regards;
> > >
> > > Larry Meadors-2 wrote:
> > > >
> > > > Nope.
> > > >
> > > > Why are you using a RowSet?
> > > >
> > > > If I were doing this, I'd use a simple prepared statement to a result
> > > > set to do it.
> > > >
> > > > Reading a 20M blob to create objects? This just sounds to me like an
> > > > application from Hell.
> > > >
> > > > Larry
> > > >
> > > >
> > > > On 9/18/06, soussou97 < dboussebha@yahoo.fr> wrote:
> > > >>
> > > >> Hi Larry;
> > > >>
> > > >> OK I willl ue JDBC + Rowset for getting the blob, have you a example
> or a
> > > >> implementaition ?
> > > >>
> > > >> Regards;
> > > >>
> > > >>
> > > >> Larry Meadors-2 wrote:
> > > >> >
> > > >> > For 20M of data? No.
> > > >> >
> > > >> > Larry
> > > >> >
> > > >> >
> > > >> > On 9/18/06, soussou97 <dboussebha@yahoo.fr> wrote:
> > > >> >>
> > > >> >> Hi;
> > > >> >>
> > > >> >> Please somebody can answer me if  its possible to use Ibatis
(last
> > > >> >> version)
> > > >> >> for getting a big Blob (20 Mo) from a database (Oracle 10)
with of
> the
> > > >> >> good
> > > >> >> performance ?
> > > >> >> If yes which lib (InputStream or sql.Blob) I must to use
for
> > > >> extracting
> > > >> >> the
> > > >> >> data inside of blob (byte []) ?
> > > >> >>
> > > >> >> regards;
> > > >> >> --
> > > >> >> View this message in context:
> > > >> >>
> http://www.nabble.com/Ibatis-and-the-blob-tf2290439.html#a6361369
> > > >> >> Sent from the iBATIS - User - Java mailing list archive at
> Nabble.com.
> > > >> >>
> > > >> >>
> > > >> >
> > > >> >
> > > >>
> > > >> --
> > > >> View this message in context:
> > > >>
> http://www.nabble.com/Ibatis-and-the-blob-tf2290439.html#a6362935
> > > >> Sent from the iBATIS - User - Java mailing list archive at
> Nabble.com.
> > > >>
> > > >>
> > > >
> > > >
> > >
> > > --
> > > View this message in context:
> http://www.nabble.com/Ibatis-and-the-blob-tf2290439.html#a6364829
> > > Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
> > >
> > >
> >
>
>

Mime
View raw message