*
The moose likes JDBC and the fly likes Help :To store a .gif/.jpg file in oracle8 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Help :To store a .gif/.jpg file in oracle8" Watch "Help :To store a .gif/.jpg file in oracle8" New topic
Author

Help :To store a .gif/.jpg file in oracle8

Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
hi
i want to store a .gif/.jpg in the database(oracle8)was using blob datatype in the database. An image gets stored in the database if I insert a small .gif/.jpg file but throws SQLException for big images ,
I will appreciate you if you reply me as soon as possible.
ravi gali
Milind Kulkarni
Ranch Hand

Joined: Jun 01, 2000
Posts: 146
Hi Ravi,
What is the size of file you are trying to insert into the db?
Another alternative could be to convert image file into a byte array and store it as LONGVARBINARY (JDBC Type) which is a LONG RAW type in Oracle dbms.
Regards,
Milind


[This message has been edited by Milind Kulkarni (edited September 05, 2000).]
 
wood burning stoves
 
subject: Help :To store a .gif/.jpg file in oracle8