JDBC AND STORING IMAGES/AUDIO/VIEDEO FILES

[Dinesh Kodiyat]

Hi all,
Can some one help me on how to store Binary files(images/audio/viedeo ) files into Oracle9i database from a Java application.I am developing an Asset management system which can create a catalog of above data.Also I shd be able to retrieve them as per a query.
I am using Swing interface at the front end.
Any help will be highly appreciated,
Thanks,
Bye
Dinesh

[prabhat kumar]

use blob fields to store binary data.
i am pasting some code. hope u can figure out hot to to the things..

  
public void LobData(String blobnr,String filename , String strUsername, String strPassword, String strDatabase,OutputStream out) throws Exception
  {
Class.forName("oracle.jdbc.driver.OracleDriver");
    Connection conn =   DriverManager.getConnection("jdbc :-o	 racle:thin:@"+strDatabase, strUsername,strPassword);
conn.setAutoCommit (false);
    Statement stmt = conn.createStatement ();
// Select the lobs   
    ResultSet rset = stmt.executeQuery ("select inhalt from blobdata where blob_nr="+blobnr);
//ResultSet rset = stmt.executeQuery ("select inhalt from blobdata where blob_nr=415");
    while (rset.next ())
    {
      BLOB blob = ((OracleResultSet)rset).getBLOB (1);
      dumpBlob (conn, blob,filename,out);
    }
    rset.close();
    stmt.close();
    conn.close(); 
  }
///
public void dumpBlob (Connection conn, BLOB blob,String filename,OutputStream out)
    throws Exception
  {
    InputStream instream = blob.getBinaryStream();
    byte[] buffer = new byte[10];
    int length = 0;
    while ((length = instream.read(buffer)) != -1)
    {
//System.out.print("Read " + length + " bytes: ");

//FileOutputStream fileOut = new FileOutputStream("U:\\tempdocs\\"+filename,true);
//fileOut.write(buffer, 0, 10);
out.write(buffer, 0, 10);
//for (int i=0; i<length; i++)
//System.out.print(buffer[i]+" ");
//System.out.println();
    }
    instream.close();
  }