Rhino, I'm on 1.5 also, just too early for 1.6. I was really looking to not have to re-invent the wheel with this program. I figured that with all the catalog web pages out there, someone must be storing images in their database and displaying them in HTML. Guess I was wrong ;-( I have the images in the database already so that part is taken care of. I would like to see your FetchBlobs. If you read my earlier post to David, I got another servlet started just to handle just the images but ran into a (temporary) snag. I will continue working on it tomorrow. Thanks
Calvin Rhino wrote the following on 5/17/2006 4:13 PM: > The current version of Java is indeed 1.5. However, the java 1.6 beta is > now available and a few people are using it - but now me. > > I'm still not clear how we can help you. > > I understand that you will be getting the pictures from a blob column in > the database but you say that you don't have a blob column yet and > therefore you will not have any blob data in the table either. If you're > asking how to get the photos into the database, I can only guess with > respect to Oracle. I've never worked with Oracle. Then again, I've found > MySQL and DB2 to be very similar and I know all the major relational > databases have a lot of similarities since they are written to the same > standards so I'm pretty sure that a program that works for DB2 or MySQL > will work with minimal changes with Oracle. > > I've got a little prototype Java program, StoreBlobs, that stores a blob > in a table column but I just checked and the database is DB2 and it's > for a rather old version of JDBC (1.22) so I'm using a JDBC-1.22-centric > way of storing the data, i.e. I'm using setBytes() rather than > setBlobs(). I've just checked and I don't even have the database any > more; that means I don't know what the table definition was and > therefore I have no way of reliably recreating the table so that I can > run the code again or try variations of the code. > > Wait! I just checked the server and have a slightly newer version of > StoreBlobs that is storing a blob in a MySQL table and using setBlobs() > to do it. The table still exists. I've just run it and proven that the > program still works. I also have a program, FetchBlobs, that retrieves > the blob from the database as well. FetchBlobs writes the blob to the > file system so that another program can display it on a standard HTML > page. You'd have to modify that bit of the code; instead of writing the > newly fetch Blob to the file system, you'd have to somehow make it into > an object that the servlet could display. I'm really not sure what form > that code would have to take. > > If either or both of those two prototype programs would help you, let me > know and I'll post some snippets or even the entire programs. (They're > small.) As for writing out the blob out in the response, someone else > will have to help you with that. > > -- > Rhino >
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
