Skuste nacitat obrazok do pola bytov
rs.getBytes("obrazek");
S pozdravom
Radovana Straube
--- Pavel Zelenka <[EMAIL PROTECTED]> wrote:
> Pokou¹ím se stahovat z MS SQL 2000 serveru data z
> polo¾ky typu Image,
> nicménì kód uvedený ní¾e naète pouze první 3 byty.
> Pou¾ívám JDBC driver od
> Microsoftu.
> Nevíte v èem je problém nebo kde dìlám chybu?
>
> synchronized public void
> getObrazek(HttpServletResponse response,
> Integer id) throws SQLException, IOException {
>
> PreparedStatement ps = null;
> ResultSet rs = null;
> InputStream is = null;
> OutputStream os =
> response.getOutputStream();
> response.setContentType("image/jpeg");
>
> ps =
> con.prepareStatement(SQL_MOTOCYKLY_OBRAZEK);
> ps.setInt(1, id);
> rs = ps.executeQuery();
> if (rs.next()) {
> is = rs.getBinaryStream("obrazek");
> }
>
> int b;
> while (0 < (b=is.read())) {
> System.out.println(b);
> length ++;
> }
> is.close();
> os.flush();
____________________________________________________________________________________
Be a better Heartthrob. Get better relationship answers from someone who knows.
Yahoo! Answers - Check it out.
http://answers.yahoo.com/dir/?link=list&sid=396545433
