aspose file tools*
The moose likes JDBC and the fly likes Image insertion into database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Image insertion into database" Watch "Image insertion into database" New topic

Image insertion into database

Gvn Karthik

Joined: Feb 07, 2011
Posts: 22
I have Oracle 10g Express Edition installed. I'm not able to insert images into the database of size greater than 3kB. I want to insert images of higher sizes say 200kB.

When I checked the size of the image column which is of BLOB type, the size turned out to be 4000. That explains why I was not able to insert an image of higher size.

How do I increase the size of the BLOB field so that I can store bigger images?
Jeanne Boyarsky
internet detective

Joined: May 26, 2003
Posts: 29233

Oracle 10g allows up to 4 gigabytes in a BLOB. The express edition is a different product though and might not allow big files at all.

[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
Blaidd Gwael

Joined: Oct 01, 2009
Posts: 13

Have you read: Oracle ?
Gvn Karthik

Joined: Feb 07, 2011
Posts: 22
I read the stuff from the links above but I could not create the table successfully. How should I modify the following query to suit larger image insertion?

create table images(imageid number(10), photo blob);

I agree. Here's the link:
subject: Image insertion into database
Similar Threads
Binary to string conversion
Image insertion into database through JDBC
Image insertion into database through JPA
Not able to insert image more than 4K in Database
Storing and Retriving Images from DB(Oracle) using JSP/Servlets