Perhaps it could help : the DBMS Mckoi ( http://mckoi.com/database/ )
has got a JDBC driver that supports blob streaming over network. Code is
open.
I tried with IBM DB2, and same as Derby, streaming isn't supported with
their JDBC driver. For a so big DBMS, I found it odd.
I'm aiming to try Oracle, but I have some difficulties to use it. Does
anyone knows if the Oracle JDBC supports blob streaming ?
It would be difficult to implement in Derby ? I'm familiar with java
network developpment. I develop in java for 4 years.
Greg
Le mercredi 31 août 2005 à 11:04 -0700, Satheesh Bandaram a écrit :
> Right... Network server currently sends whole datatype over to client.
> While this works for most datatypes, since they are limited in size,
> it may be a problem for clob/blob types. Server needs to be able to
> stream these large datatypes over the wire on demand, so no matter
> whether we have a common client or not, server needs to be enhanced.
>
> Satheesh
>
> Daniel John Debrunner wrote:
> > Michael J. Segel wrote:
> >
> >
> > > On Wednesday 31 August 2005 10:49, Satheesh Bandaram wrote:
> > >
> > >
> > > > Thanks for the offer.. It would really be great to have more developpers
> > > > working on Derby. Join the derby-dev alias to participate in the
> > > > development.
> > > >
> > > > Derby embedded driver already has the capability to stream blob/clob,
> > > > without requiring reading them completely into memory. It would be great
to
> > > > enhance Derby network server and Derby client to support this kind of
> > > > behavior.
> > > >
> > > > Satheesh
> > > >
> > > >
> > > [SNIP]
> > >
> > > This may be a dumb question...
> > >
> > > Maybe its hindsight, but why isn't the Server Framework either a subclass or
> > > an extension to the embedded driver? Someone had posted that the Network
> > > Driver utilized the embedded driver... (Or is that bathtub gin affecting my
> > > memory?)
> > >
> > > I guess it goes more to the point of why not have more focus on a "universal"
> > > driver?
> > >
> >
> > My view
> >
> > http://mail-archives.apache.org/mod_mbox/db-derby-dev/200508.mbox/%3c430A43DE.3060803@debrunners.com%3e
> >
> > Really the two drivers are doing different things, one has to convert
> > requests into messages using DRDA over tcp/ip, the other just calls java
> > methods.
> >
> > Dan.
> >
> >
> >
> >
|