This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
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 OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA 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