i would think that the jDBC equivalent of ODBC SQLGetData() and
SQLPutData() will do the trick. Since most db columns are limited in size,
these calls apply to BLOBS. Not sure what the JDBC calls are, but you
have to look into JDBC support for BLOB columns and stuff.
------------------------------------
http://www.fiver.net/~ezhilan
mailto:[EMAIL PROTECTED]
-You never know
------------------------------------
On Thu, 25 Nov 1999, Christian Nateghi wrote:
> Or maybe you should have the servlet allocate more memory in some
> way. Is there a way to truncate the 50mb into smaller pieces? Just
> some thoughts.
>
> Christian Nateghi
>
>
> Date sent: Thu, 25 Nov 1999 11:51:36 +0100
> Send reply to: "A mailing list for discussion about Sun Microsystem's Java
> Servlet API Technology." <[EMAIL PROTECTED]>
> From: Martin Kuba <[EMAIL PROTECTED]>
> Subject: Re: JDBC Retrieval!
> To: [EMAIL PROTECTED]
>
> > John John Tobias wrote:
> > >
> > > Hi All,
> > >
> > > Is there anyone who knows how to retrieve a large amount of data in database
> > > (let's say 30-50MB of data). I am using JDBC to retrieve data from Sybase(My
> > > database Server). But, unfortunately I cannot figure out why my servlet
> > > suddenly causes an Internal Server Error when I'm about to retrieve a large
> > > amount of data. However, my servlet works properly when I'm retrieving 2MB
> > > of data or less.
> > >
> > > I would appreciate it very much if you could help me with this problem.
> > >
> > > Thank's in advance,
> >
> > Maybe the servlet engine timeouts before all the data are retrieved ?
> >
> > Martin
> >
> > --
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > INET, a.s. Mgr. Martin Kuba
> > Kralovopolska 139 e-mail: [EMAIL PROTECTED]
> > 601 12 Brno WWW: http://www.inet.cz/~makub/
> > Czech Republic tel: +420-5-41242414/32
> > --------------------------------------------------------------------
> > PGP fingerprint = D8 57 47 E5 36 D2 C1 A1 C3 48 B2 59 00 58 42 27
> > http://wwwkeys.cz.pgp.net:11371/pks/lookup?op=index&search=makub
> > --------------------------------------------------------------------
> >
> > ___________________________________________________________________________
> > To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> > of the message "signoff SERVLET-INTEREST".
> >
> > Archives: http://archives.java.sun.com/archives/servlet-interest.html
> > Resources: http://java.sun.com/products/servlet/external-resources.html
> > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
