Retrieving image from database - getBlob?

[Stefan Renemeister]

Hi there,

I am performing my first steps in java JDBC, and as an exercise try to show some images from a mysql database.
The thing below runs, but doesn't show my photo's. (it does show the id's however).
It returns the following error:

SQLException: Column Index out of range, 0 < 1.
SQLState: S1009
VendorError: 0

What am I doing wrong? And more important, what is the proper way to show my photo? Any help is greatly appreciated!

public class databaseConnection {
    private int photo;

    public void loadDriver() {
            try {
            Class.forName("com.mysql.jdbc.Driver");
            System.out.println("Driver loaded");
            }
            catch (Exception ex) {
           System.out.println("not Connected, com.mysql.jdbc.Driver class not found");
            }
    }

    public void connect() {
        Connection conn = null;
    try {
    conn = DriverManager.getConnection("jdbc:mysql://www.scoobie.nl:1025/photo_dbs","scoobie","xxxxx");
    System.out.println("Connected");

    Statement stmt = null;
    ResultSet rs = null;
    stmt =  (Statement) conn.createStatement();
    rs = (ResultSet) stmt.executeQuery("SELECT id, photo FROM photo_tbl");

    while (rs.next()) {
    int i = rs.getInt("id");
                Blob ph = rs.getBlob(photo);
    System.out.println(i);
    System.out.println(ph);

    }
    }
    catch (SQLException ex) {
    // handle any errors
    System.out.println("SQLException: " + ex.getMessage());
    System.out.println("SQLState: " + ex.getSQLState());
    System.out.println("VendorError: " + ex.getErrorCode());
    }
}
}

[Stefan Renemeister]

Duuuh, forgot the quotes in the columnname..

Should have been:

  Blob ph = rs.getBlob("photo");  

instead of:

  Blob ph = rs.getBlob(photo);  

Ok, well here's the following question:

my result of above code is:

1
com.mysql.jdbc.Blob@84da23
2
com.mysql.jdbc.Blob@d3d6f

I'd like to see the actual pics, instead of the data.. How can I transform this into a picture?

[Stefan Renemeister]

Anybody any advice?