public   class  Test  extends  JFrame
{
     public   static   void  main(String[] args)
    {
         new  Test();
    }

     public  Test()
    {
         try 
        {
            Connection con =  null ;
            BLOB blob;
            OutputStream out =  null ;
            FileInputStream in =  null ;
             try 
            {
                con = getConnect();

                blob = BLOB.createTemporary(con, true, BLOB.DURATION_SESSION);
                out = blob.getBinaryOutputStream();
                in =  new  FileInputStream( new  File("src\\imag\\orange.jpg"));
                 int  length;
                 int  chunkSize = blob.getChunkSize();
                 byte [] buf =  new   byte [chunkSize];
                 while  ((length = in.read(buf)) != - 1 )
                {
                    out.write(buf,  0 , length);
                }
                PreparedStatement stmt = con.prepareStatement("INSERT INTO can4ecc_test "
                        + "VALUES(?, ?)");
                stmt.setBlob( 1 , blob);               
                stmt.setString( 2 , "sasa21");
                stmt.execute();
                stmt.close();
                con.close();
                test1();

            }
             finally 
            {
                 if  (in !=  null )
                {
                    in.close();
                }

                 if  (con !=  null )
                {
                    con.close();
                }
            }

        }
         catch  (Exception e)
        {
            e.printStackTrace();
        }
    }

     public   void  test1()
    {
         try 
        {
            //
            Connection con = getConnect();
            Statement stmt = con.createStatement();
            ResultSet result = stmt.executeQuery("Select image From can4ecc_test ");
            result.next();
            Blob blob = result.getBlob("image");
            InputStream in = blob.getBinaryStream();
            ByteArrayOutputStream out =  new  ByteArrayOutputStream();
             byte [] bytes =  new   byte [ 1024 ];
             int  l;
             while  ((l = in.read(bytes)) != - 1 )
            {
                out.write(bytes,  0 , bytes.length);
            }
            ImageIcon icon =  new  ImageIcon(out.toByteArray());
            JLabel label =  new  JLabel(icon);
            getContentPane().add(label);
            setSize( 200 ,  200 );
            setVisible(true);
            stmt.close();
            con.close();

        }
         catch  (Exception e)
        {
            e.printStackTrace();
        }
    }



     public  Connection getConnect()
    {
        Exception ex =  null ;
        Connection connection =  null ;
         try 
        {
            //Load driver
            String driver = "oracle.jdbc.driver.OracleDriver";
             Class .forName(driver);
            //
            String url = "jdbc:oracle:thin:@oracle:1521:dbg101";
            String user = "student";
            String password = "student";
            connection = DriverManager.getConnection(url, user, password);
            System.out.println("We connect:  " + connection);

        }
         catch  (ClassNotFoundException e)
        {
            e.printStackTrace();
        }
         catch  (SQLException e)
        {
            ex = e;
        }
         if  (ex !=  null )
        {

        }

         return  connection;
    }


}