File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes java.sql.Blob   4K restriction Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "java.sql.Blob   4K restriction" Watch "java.sql.Blob   4K restriction" New topic

java.sql.Blob 4K restriction


Joined: Apr 11, 2003
Posts: 2
very simple program to insert into blob using pure java.sql.Blob datatype.

This works fine as long as filesize < 4k .
Any more file size gives SQLException: No more data to read from socket

Tried with jdk1.4 .

Can this be resolved ?

[Edited to remove e-mail. We ask people to use the forum to reply rather than e-mail so all can benefit]
[ July 22, 2005: Message edited by: Jeanne Boyarsky ]
Dirk Schreckmann

Joined: Dec 10, 2001
Posts: 7023
templegod setty,
Welcome to JavaRanch!
We ain't got many rules 'round these parts, but we do got one. Please change your display name to comply with The JavaRanch Naming Policy.
Thanks Pardner! Hope to see you 'round the Ranch!

[How To Ask Good Questions] [JavaRanch FAQ Wiki] [JavaRanch Radio]
Christopher Elkins
Ranch Hand

Joined: Oct 26, 2004
Posts: 45
I'm having the same basic issue. Was there ever a solution posted to this problem? Thanks.
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33124

Not in this thread. I recommend creating a new thread describing the problem you are having (even if it is remarkable similar.) Include which database you are using in that thread.

Many of us won't reply to someone with an invalid display name until they fix it which decreased the chances of Satish getting an answer. You may have better luck.

JDBC Forum Bartender

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: java.sql.Blob 4K restriction
It's not a secret anymore!