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

__________________
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.