Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 146
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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).]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic