Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: Java
Expertise: Advanced
Nov 4, 2004



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Read an Image from a Database and Show it in a Browser

This script reads the image from the databse and uses JDBC and stream to write it into a browser.

//import the required files
import ...
//class declaration
public class ... extends HttpServlet{
  public void doGet(HttpServletRequest request, HttpServletResponse response)
                               throws ServletException, IOException {
  Connection conn = null;
  byte[] buffer = new byte[4 * 1024];  
  int len;  
  try {
      //database connectivity
      DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
      conn = DriverManager.getConnection("jdbc:oracle:thin:@url:1521:omm","uname","pwd"); 
      //getting stream
      ServletOutputStream out = response.getOutputStream();
      //executing query
      Statement stmt = conn.createStatement();
      //note IMAGE field may be CLOB/BLOB in the database
      ResultSet rs = stmt.executeQuery("SELECT IMAGE FROM table_image WHERE IMAGE_ID = 101") ;
      if (rs.next()) { //reading &writting using stream 
        BufferedInputStream bis = new BufferedInputStream(rs.getBinaryStream("IMAGE"));
        while ((len = bis.read(buffer, 0, buffer.length)) != -1) {
          out.write(buffer, 0, len);
    catch ( Exception e ) {//exception handling
David Elayaraja
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date