Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes JDBC and the fly likes Cannot read a Blob from a CachedRowSet 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 "Cannot read a Blob from a CachedRowSet" Watch "Cannot read a Blob from a CachedRowSet" New topic
Author

Cannot read a Blob from a CachedRowSet

Tomas Nilson
Ranch Hand

Joined: Jan 14, 2002
Posts: 33
Hello!
I have a JSP page that gets a CachedRowSet from a Java Bean (which communicates with my MySQL database).
I have no problems reading things like strings and integers from the CachedRowSet, but I can't read Blobs. I receive a datatype mismatch error when I try to do that.
I do something like:
java.sql.blob b = crs.getBlob("test");
and then it crashes...
Does anyone have any ideas of how to fix this?? Is more information needed??
PLEASE help me!!
/Tom
 
Consider Paul's rocket mass heater.
 
subject: Cannot read a Blob from a CachedRowSet
 
Similar Threads
close on CachedRowSet
CachedRowSet is an abstract class
CachedRowSet is abstract; cannot be instantiated?
Problem with sun.jdbc.rowset.CachedRowSet
Cached RowSet in java Null Pointer Exception