Get Image from Ultralite

[Former Member]

Can any one tell me how to get bitmap from ultralite database using ResultSet.getBlobInputStream?

[philippefbertrand]

Can you tell us what platform and API you are using? What version of UltraLite are you using?

[Former Member]

I am using Android. I have the image stored in ultralite database in form of byte array.

[Former Member]

The following code fragment gives the idea:

ResultSet rs = ps.executeQuery();
while( rs.next() ) {
    if( !rs.isNull( 3 ) ) {
        InputStream is = rs.getBlobInputStream( 3 );
        // read the column using InputStream
    }
}

Is that what you are looking for?

[Former Member]

The following code fragment gives the idea:

ResultSet rs = ps.executeQuery();
while( rs.next() ) {
    if( !rs.isNull( 3 ) ) {
        InputStream is = rs.getBlobInputStream( 3 );
        // read the column using InputStream
    }
}

[VolkerBarth]

@Andy: FWIW, you can also "convert an existing comment to an answer" with the help of the leftmost button below the comment...