• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

HOW TO Upload files to db (postgres) using java/jdbc

 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi, I am new to this and i want to upload some files to my database but i simple can't figure out how to...can anyone give me an example on how to upload a file(binary data) using java and jdbc to my database...
Thank you
Eduardo
 
author & internet detective
Posts: 41860
908
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Eduardo,
Welcome to JavaRanch!

Uploading files to the database server is the same as uploading to any other machine. Then you can run the database import utility to get the files into the database.
 
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
By "upload", do you mean to store it as a whole? If so, that's what BLOB type attribute are for. That's supported by the Statement and ResultSet classes, so if you have the file contents in your Java code, it shouldn't be too difficult. What do you have so far?

As an aside, storing binary file contents in a DB isn't always the best way to do it. Have you considered storing the file in the file system, and only keeping the path to the file in the DB?
 
Ranch Hand
Posts: 47
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Here is the sample code

import java.io.*;
import java.sql.*;
public class ImageStoreDatabase{
public static void main(String args[]){
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection
("jdbc:oracle:thin:@localhost:1521:sid","scott","tiger");
PreparedStatement pstmt=con.prepareStatement("insert into image values
(?,?)");
FileInputStream fis=new FileInputStream("file name");
pstmt.setInt(1,21);
pstmt.setBinaryStream(2,fis,fis.available());
pstmt.executeUpdate();
}catch(Exception e){}
finally{
//pstmt.close();
}
}
}
and the table of the structure goes like this
create table image(id number(5),image blob);
 
Get off me! Here, read this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic