Inserting & Retrieving Images from MSSQL

[Ola Daniel]

i am not really sure which forum this should go. Ill try here. I hope I get some direction. I am trying to create a page to upload images to a database and also view this when in the database on one of my JSPs. I am kind of lost. I would appreciate any direction on where to start from - like some kind of reference somewhere.

[Bear Bibeault]

What part are you having trouble with:

Uploading the image?

Storing the image in the DB?

Reading the image from the DB?

Streaming the image to the browser via servlet?

Referencing the image in an image tag?

All of the above?

[ August 29, 2005: Message edited by: Bear Bibeault ]

[Ola Daniel]

I am having trouble reading the Image from the database and streaming the image to the browser. This is the portion of the code that is to retrieve the image from the database.

 
path = request.getSession(false).getServletContext().getRealPath("/attachments");
        java.text.SimpleDateFormat sd = new java.text.SimpleDateFormat();
        sd.applyPattern("yyyy_mmddHH_MMss_SSS");
        String imgName = sd.format(new java.util.Date());        
        fileName = path+"/"+usedID + imgName + "_img_1.png"; 
 
        try {
            Connection conn = ds.getConnection();
            PreparedStatement ps = conn.prepareStatement(sqlStr);
            ps.setString( 1, usedID );
            ResultSet rs = ps.executeQuery();
 
            //list = DataClass.getResultSet(ds, sqlStr);
            File filePath = new File(fileName);
            if(!filePath.exists()){
                filePath.mkdirs();
            } 
            if(rs.next()){
                byte[] bt = rs.getBytes(1);                
                java.io.FileOutputStream fOut = new java.io.FileOutputStream(filePath);
                java.io.DataOutputStream dOut = new java.io.DataOutputStream(fOut);
 
                dOut.write(bt);
                dOut.flush();
                dOut.close();
 
                request.setAttribute("image", filePath.getAbsolutePath());
            } else {
                request.setAttribute("image", "./images/nophoto.gif");
            }
        } catch(SQLException e) {
            System.out.println("ODD: SQLException - "+ e + ": " + e.getMessage());            
        } catch(Exception e) {
            System.out.println("ODD: "+ e + ": " + e.getMessage());            
        } 
 

11:52:32,591 INFO [STDOUT] java.lang.NullPointerException
11:52:32,591 INFO [STDOUT] ODD: java.lang.NullPointerException: null

I am getting the above exception. Help please...

The plan is to write the image from the DB to a file.png and then set an attribute that can be used by the image tag and display the picture on the jsp.
[ August 30, 2005: Message edited by: Ola Daniel ]

[Ola Daniel]

Guys problem solved.. my page is up an running