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 Exercising with BLOBS 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 "Exercising with BLOBS" Watch "Exercising with BLOBS" New topic

Exercising with BLOBS

Carol Murphy
village idiot

Joined: Mar 15, 2001
Posts: 1202
My daddy gave me a subscription to JavaPro magazine, and in the Jan/Feb 04
issue there is an article by JohnO'Donohue about using JDBC to manage big ol' datatypes. Trying to keep my JDBC skills from atrophying, I tried to work through the code examples, but something ain't working.
I didn't do 3 things exactly like the example, but I'm not sure the problem lies there.
1) I didn't download the most recent version of MySQL Connector/J. Instead, I kept the version I used for the JDBC Cattle Drive assignments.
2) I didn't create the special package for the class files, I put them in the default package.
3) I changed the value stored in the String variable that gets passed to Class.forName() so it works with the driver I've got.
I was able to create a table using Java and JDBC, so I know that part is working, and mysql is talking to JDBC and Java, but the Servlets that should upload the BLOB to the database and echo the upload back to the browser don't work. Has anyone seen this article? Any ideas?
Dana Hanna
Ranch Hand

Joined: Feb 28, 2003
Posts: 227
An answer is impossible without knowing the Exception that you are getting.
I agree. Here's the link:
subject: Exercising with BLOBS
It's not a secret anymore!