Image File is getting damaged after read from the sqlserver database

[Levi Mendes]

Hello everyone,

I need create a file from a sqlserver database whose the field is text, when I create the image from the String value or byte[], the image is getting damaged, I dont know the reason, can anyone help me please?
Have you understood?

Are there any error on my code?

My picture is getting so:



My code:

import java.io.BufferedWriter;  
import java.io.File;  
import java.io.FileWriter;  
import java.io.IOException;  
import java.sql.Connection;  
import java.sql.PreparedStatement;  
import java.sql.ResultSet;  
import java.sql.SQLException;  
import javax.swing.JOptionPane;  
  
public class Main {  
  
    public static void main(String[] args) throws SQLException, IOException {  
          
        Thread thread = new Thread(new Runnable() {  
              
            @Override  
            public void run() {  
                try {    
                    String sql = "select cpros, figjpgs from SIGCDPRO where cpros = '010050.03603'";  
                    ConectaBanco conectaBanco = new ConectaBanco();  
                    Connection conn = conectaBanco.getConexao();  
                    PreparedStatement ps = conn.prepareStatement(sql);  
                    ResultSet rs = ps.executeQuery();  
                      
                    while (rs.next()) {  
                        String figjpgsStr = rs.getString("figjpgs");  
                        String cpros = rs.getString("cpros").trim();  
                                          
                        //Works, but the image get damaged
                        writeToFile(cpros, figjpgsStr);                   
                    }  
                      
                    rs.close();  
                    ps.close();  
                    conn.close();  
      
                    JOptionPane.showMessageDialog(null, "End process.");  
                      
                } catch (Exception e) {  
                    e.printStackTrace();  
                }  
            }  
        });  
          
        thread.start();  
    }  
      
    private static void writeToFile(String cpros, String content) {  
        File file = new File("imgs/" + cpros + ".jpg");  
        BufferedWriter bw = null;  
          
        try {  
            bw = new BufferedWriter(new FileWriter(file));  
            bw.write(content);  
            bw.flush();  
            bw.close();  
              
        } catch(IOException e) {  
           e.printStackTrace();  
             
        } finally {     
            if(bw != null) {  
                try {  
                    bw.close();  
                } catch (IOException e) {  
                    e.printStackTrace();  
                }  
            }  
        }  
    }  
      
}  

Regardless, thanks.

[Ulf Dittmer]

when I create the image from the String value

Images are binary data, so if you ever store them in a string, or use Readers or Writers for them, the data is corrupted (unless you took precautions to make it not so, like base-64 encoding them, but it doesn't sound like you did).

[Levi Mendes]

Hello Ulf Dittmer
,

Images are binary data, so if you ever store them in a string, or use Readers or Writers for them, the data is corrupted (unless you took precautions to make it not so, like base-64 encoding them, but it doesn't sound like you did).

There are a system that use this database, the system was designed in Visual Fox Pro, the system read the images that are stored on this database. Yesterday one developer shown me the code that he uses to read the images, he uses a method called StrToFile to create the File from the image (a file with jpg extension), now I dont know what to do, on Visual Fox Pro he gets read the image with no problem, in Java when I try read it Im getting so:


One man said to me yestarday the samethins you said me:

the data is corrupted

[Ulf Dittmer]

If you know someone -even in your company, it sounds like- who is successful doing this, shouldn't you be talking to him, and have him explain to you the details of how it works?

[Levi Mendes]

Ulf Dittmer

I talked with him yesterday, the process he uses is the following:
Process to insert the image on database:
To insert the image on database exists one button that open a input dialog to the user select the image, the system read the image and convert it to string through a method called FileToString, that is all, according to him.
Process to read the image:
The programmer makes a select on database: "select pic from tb", the select command returns a string, then he calls a method called StrToFile, now he gets an image file with no problem.

[Ulf Dittmer]

So what do those FileToString and StrToFile methods do? Obviously, your code will have to do the same to the data.