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 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 and Relational Databases
Bookmark "Help :To store a .gif/.jpg file in oracle8" Watch "Help :To store a .gif/.jpg file in oracle8" New topic

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

Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
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.

[This message has been edited by Milind Kulkarni (edited September 05, 2000).]
I agree. Here's the link:
subject: Help :To store a .gif/.jpg file in oracle8
It's not a secret anymore!