This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC 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

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
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.

Christopher Elkins, SCJP Java 2 Platform
Jeanne Boyarsky
internet detective

Joined: May 26, 2003
Posts: 30068

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

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
subject: java.sql.Blob 4K restriction
Similar Threads
tomcat connection pool - oracle blob
Big G
Making Contacts
Not able to insert image more than 4K in Database
Send Email using JMS