Hi all !!!
could you please tell me the solution why <b>"Illegal operation on empty result set."</b> is coming.

I have to display the images from the database Mysql dynamically by pssing parameter "chartid"

<%@ page import="java.sql.*" %>
<%@ page import= "java.io.*" %>
<%
String connectionURL = "jdbc:mysql://localhost:3306/modelval?user=modval;password=modval";
Connection connection = null;
Statement statement = null;
%>
<%
String Id=request.getParameter("chartid");
Class.forName("com.mysql.jdbc.Driver").newInstance ();
connection = DriverManager.getConnection(connectionURL, "modval", "modval");
statement = connection.createStatement();
ResultSet rs1 = statement.executeQuery( "SELECT * FROM tab_charts where chartid= ' " + Id + " ' ");
rs1.next();
byte [] barray = rs1.getBytes("chart");
rs1.close();
statement.close();
response.setContentType("image/jpeg");
response.getOutputStream().write(barray);
%>
================================================== =============
i am not getting the display of images on jsp page....the image is stored as a blob in table tab_charts with the column name "chart"
but not getting the images....

please help me .Its reallly urgent...
thanx in advance

Amit Srivastava

Hi,

check whether your query returns something
is there exist some data in the table with this chartid etc.

SELECT * FROM tab_charts where chartid= ' " + Id + " '

how u inserted image data into db.
==================
other way to increase perfomance..

u have to upload images in to a folder
and store the file path in db

for displaying
retrieve the filepath
and display it using <img src="path">
buy doing this u can avoid the extra fetch from the db..

regds,


jomet.
---------------------------------------------
Once you start a working on something,
dont be afraid of failure and dont abandon it.
People who work sincerely are the happiest.

check the link
http://blogs.sun.com/sakthi/entry/ho...d_and_retrieve

jomet.
---------------------------------------------
Once you start a working on something,
dont be afraid of failure and dont abandon it.
People who work sincerely are the happiest.