Thx a ton angrycat....
it finally worked..u made my day.. :)

y do u say tat it is a mistake bush...?

I dont see why this is mistake.

True the page is only compiled once, but it is not static.
Building on the code I gave, what should be compiled (once only) is a DYNAMIC jsp page that receives parameters (for database queries) and returns an image based on those parameters.

The fact that jsp compiles once only (unless source is updated) does not detract from the fact they are dynamic.

ag

bush,

Think I know where your coming from, but still think it will work!

getImage is a jsp that queries the database, in the example I gave the the parameter a static "1".

The code needs to be developed to use a variable as the parameter, which would be passed something like this:

<td><img src="getImage.jsp?myRecordId=myParam"></td>

The variable myParam makes it possible to call getImage.jsp with different parameters, thus returning whatever image you want.

Perhaps Pallav could try it and let us know!

ag

Hi angrycat,

I tried wat u said (<td><img src="getImage.jsp?myRecordId=myParam"></td>) n it worked perfectly f9....

No problem at all.....

Thnx 4 the help...

please tell me what is myRecordId=myParam

and how should i get that recordid
<td><img src="getImage.jsp?myRecordId=myParam"></td>

hi pallav

can u send me your Your_Code.jsp

iam struggling to do this

iam using struts and hibernate

my requirement is also the same

displaying image from databse

to the jsp

regards
amir

Hi !!!
      i would like to display an image, actually i'm getting this image dyanmically after every 5 mins being processed by some database queries, I'm getting values from the database, process them and make a jpeg chart , now i want it to be displayed on a jsp , and i want that jsp to display this image after every 5 mins. Could you please tell me how should i do it , i need to get this problem solved as soon as possible.
please help .

Hi, i am facing problems so hope you guys can help me out! I did try out many different solutions. What i want is to retrieve the BLOB image in mysql and display it in jsp.

I tried out the code. But there is no image displayed out. I have no choice what went wrong.
I embed the servlet in one of the tags so i am not sure if i am right. If not, please guide me. Thanks.

---comments.jsp---

table border="1" borderColor="#ffe9bf" cellPadding="0" cellSpacing="0" width="428" height="63">
<tbody>
<td bgColor="#008080" width="28" align="center" height="19">No.</td>
<td bgColor="#008080" width="126" align="center" height="19">Name</td>
<td bgColor="#008080" width="224" align="center" height="19">Picture</td>
<td bgColor="#008080" width="270" align="center" height="19">Comments</td>


<%

String DRIVER = "com.mysql.jdbc.Driver";
Class.forName(DRIVER).newInstance();

Connection conn = null;
Statement stmt = null;

try{

String dbUrl = "jdbc:mysql://localhost/homepage?user=root&password=mysql";

int i=1;
conn = DriverManager.getConnection(dbUrl);
stmt = conn.createStatement();
String query = "Select * FROM Comments";
ResultSet rst = stmt.executeQuery(query);
while(rst.next()){

if(i==(i/2)*2){
%>

<tr>
<td width="28" height="19" align="center" vAlign="top" bgColor="#ffff98" class="title"><%=i%></td>
<td width="126" height="19" align="center" vAlign="top" bgColor="#ffff98" class="title"><%=rst.getString(3)%></td>
<td width="224" height="19" align="center" vAlign="top" bgColor="#ffff98" class="title"> <embed src="http://localhost:8080/servlet/ImageServlet" content="image/jpeg"></embed></td></td>
<td width="270" height="19" align="center" vAlign="top" bgColor="#ffff98" class="title"><%=rst.getString(4)%></td>
</tr>

<%
}else{
%>
<tr>
<td width="28" height="19" align="center" vAlign="top" bgColor="#ffcc68" class="title"><%=i%></td>
<td width="126" height="19" align="center" vAlign="top" bgColor="#ffcc68" class="title"><%=rst.getString(3)%></td>
<td width="224" height="19" align="center" vAlign="top" bgColor="#ffff98" class="title"><embed src="http://localhost:8080/servlet/ImageServlet" content="image/jpeg"></embed> </td>
<td width="270" height="19" align="center" vAlign="top" bgColor="#ffcc68" class="title"><%=rst.getString(4)%></td>

</tr>
<% }

i++;
}
rst.close();
stmt.close();
conn.close();
}catch(Exception e){
System.out.println(e.getMessage());
}
%>
</tbody>
</table>

<---ImageServlet.java-->

import java.io.*;
import javax.servlet.http.*;
import javax.servlet.*;
import java.sql.*;

public class ImageServlet extends HttpServlet {

public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request, response);
}

public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
try {

String filename = request.getParameter("name");
//filename = "baby.gif";
//execute you sql to get the clob here
String url = "jdbc:mysql://localhost/homepage";
String userID="root";
String PWD="mysql";
Connection conn = null;
String classPath= "com.mysql.jdbc.Driver";

try{
Class.forName(classPath).newInstance();
conn = DriverManager.getConnection(url,userID,PWD);
}catch(Exception exc){
out.println(exc.toString());
}
Statement stmt = null;
ResultSet rst = null;

// Connection c = ...
stmt = conn.createStatement();
//String strSQL = "SELECT Picture FROM comments WHERE name='" +filename +"'";
String strSQL = "SELECT Picture1 FROM comments WHERE name='" filename"'";
rst = stmt.executeQuery(strSQL);

byte [] barray = rst.getBytes("binaryfile");
rst.close();
stmt.close();
response.setContentType("image/jpeg");
response.getOutputStream().write(barray);

} catch (Exception sqle) {

}

}

}

package image;

import java.sql.*;
import java.io.*;
import java.util.*;
import oracle.jdbc.*;
import oracle.sql.*;

public class images
{
  /*-------------------------
   * Get the Blob image
   *------------------------*/
  public static byte[] getPhoto (OracleConnection conn, int iNumPhoto)
       throws Exception, SQLException
  {

    String req = "" ;
    Blob img ;
    byte[] imgData = null ;
    Statement stmt = conn.createStatement ();

    // Query
    req = "Select image From IMAGES Where ImageID = " + iNumPhoto ;

    ResultSet rset = stmt.executeQuery ( req );

    while (rset.next ())
    {
      img = rset.getBlob(1);
      imgData = img.getBytes(1,(int)img.length());
    }

    rset.close();
    stmt.close();

    return imgData ;

  }

}

 The JavaServer Page includes the bean so its methods can be accessed in the JSP page using scriplets and “photo” as a named bean reference



<%@ page import = "image.*" %>
<%@ page import = "java.io.*" %>
<%@ page import = "oracle.jdbc.OracleConnection" %>
<jsp:useBean id="photo" class="image.images" scope="session" />
<%

  int iNumPhoto ;
  oracle.jdbc.driver.OracleConnection conn = null;

  if ( request.getParameter("imgID") != null )
  {

    iNumPhoto = Integer.parseInt(request.getParameter("imgID")) ;

    try
    {
       conn = …………;
       conn.setAutoCommit (false);

       // get the image from the database
       byte[] imgData = photo.getPhoto( conn, iNumPhoto ) ;
       // display the image
       response.setContentType("image/gif");
       OutputStream o = response.getOutputStream();
       o.write(imgData);
       o.flush();
       o.close();
    }
    catch (Exception e)
    {
      e.printStackTrace();
      throw e;
    }
    finally
    {
      â€¦ Close the connexion … ;
    }
  }
%>

http://studyjava.org/forums/