Need more values from Other DB

[Rajkumar balakrishnan]

Hi ranchers,
I am back with bunch of questions...
I have lot of tables like customer,vendor,item and rma table... I generate a report of products that were return by customers to our company.. Here in this table i had a item_id field which is an foreign key which is the primary key of item table...My problem when admin clicks the report button some details will be displayed in screen from the RMA table along with the ITEM tables description field... I think you got it..
It retrieves all the product related information from RMA table.. In RMA table i had a field item_id and using this field i want to manipulate the item_description field that too displayed in the same report..

Please help me..

Sorry for my poor english...

[Shailesh Chandra]

What I assumed from your question is that all you need to is play with joins.

Try making some query and post your query, if you feel your query is not right. Also let us know why that query is wrong.

Thanks,
Shailesh

[Rajkumar balakrishnan]

RMA TABLE
---------
item_id -> varchar(FK)
customer_id -> varchar(FK)
vendor_id -> varchar(FK)
and so on..

ITEM TABLE
---------
item_id -> varchar
item_description -> varchar

My question is...
I generate a report where all the details about the RMA product is displayed from the RMA table...
I also need the item_description of the items with its item_id....But it is not in the RMA table and in ITEM table... How i get the item description of each and every product using the item_id... I ain't write any query for that....Please help me...
I need a output like this...
CustID | InvDate | InvNo | ItemDesc | FaultDesc | SerialNo

But now i had a output like this....
CustID | InvDate | InvNo | ItemID | FaultDesc | SerialNo

I hope ranchers will help me......

Sorry.... i just wrote it by mistake... Any way if you suggest me a solution then i'll get the CustName from customer table by the same method i get item_description....
[ August 11, 2008: Message edited by: Rajkumar balakrishnan ]

[Shailesh Chandra]

I think one inner join with item table will solve your problem. I guess you are selecting from RMA TABLE


But could you tell me how are you getting CustName because RMA Table is having a column as customer_id .

You must be using inner join with customer table, if you can do it for one table then you can also do it for other tables too.

Thanks,
Shailesh

[Rajkumar balakrishnan]

Originally posted by Shailesh Chandra:
I think one inner join with item table will solve your problem. I guess you are selecting from RMA TABLE


But could you tell me how are you getting CustName because RMA Table is having a column as customer_id .

You must be using inner join with customer table, if you can do it for one table then you can also do it for other tables too.

Thanks,
Shailesh

I edited the post as i write CustName instead of CustID... Now please let me know how could i achieve that using innerjoin.......

[Shailesh Chandra]

Rajkumar read below URL on join and come up with a query.

http://www.w3schools.com/Sql/sql_join.asp

All ranchers are there to help you out, once you will put some effort.

http://faq.javaranch.com/java/DoYourOwnHomework

Thanks,
Shailesh

[Rajkumar balakrishnan]

Hey friends,
i finally got what i want, but now my problem how do i implement it with JSP to get the desired output.. Here is my query and when i type it in MySQL console it returns the desired output... Here is my query...

mysql> select tbl_rmadetails.DATE,tbl_rmadetails.serial_no,tbl_rmadetails.item_i
d,tbl_rmadetails.customer_inv_no,tbl_rmadetails.fault_desc,tbl_rmadetails.custom
er_inv_date,tbl_item.item_description as ProductDetails FROM tbl_rmadetails as t
bl_rmadetails INNER JOIN tbl_item as tbl_item on tbl_item.item_id=tbl_rmadetails
.item_id;
+------------+-----------+---------+-----------------+--------------+-----------
--------+------------------------+
| DATE       | serial_no | item_id | customer_inv_no | fault_desc   | customer_i
nv_date | ProductDetails         |
+------------+-----------+---------+-----------------+--------------+-----------
--------+------------------------+
| 2008-08-11 | FA111     | KB002   | NULL            | Not detected | 2008-07-14
        | FARASOO KEYBOARD KBX78 |
| 2008-08-11 | MOU012    | KB002   | INV111          | Not detected | 2008-07-21
        | FARASOO KEYBOARD KBX78 |
+------------+-----------+---------+-----------------+--------------+-----------
--------+------------------------+
2 rows in set (0.00 sec)

And i need to print it in JSP page and i dont know how to get the results and iterate through it...
Here is the code i used but i dont get my desired output as i got in the MySQL console... whats the problem....

SQL = "select tbl_rmadetails.date,tbl_rmadetails.serial_no,tbl_item.item_description,tbl_rmadetails.customer_inv_no,tbl_rmadetails.fault_desc,
tbl_rmadetails.customer_inv_date FROM tbl_rmadetails, tbl_item WHERE (tbl_rmadetails.status='RFC')";
 
ps=db.con.prepareStatement(SQL);
 
rs=ps.executeQuery();
 
if(rs!=null)
{
while(rs.next())
{
%>
<tr bgcolor="#CCCCCC">
<td align="center"><%=rs.getDate("tbl_rmadetails.date")%></td>
<td align="center"><%=rs.getString("tbl_rmadetails.serial_no")%></td>
<td align="center"><%=rs.getString("tbl_item.item_description")%></td>
<td align="center"><%=rs.getString("tbl_rmadetails.customer_inv_no")%></td>
<td align="center"><%=rs.getString("tbl_rmadetails.fault_desc")%></td>
<td align="center"><%=rs.getString("tbl_rmadetails.customer_inv_date")%></td>
</tr>
<%
}
}
else
{
out.println("Result Set is empty");
}
}

I dont get the item_description here....Whats the ptoblem..Please help me ranchers....

[ August 12, 2008: Message edited by: Rajkumar balakrishnan ]

[Rajkumar balakrishnan]

Any one is there to help me.....

[Paul Sturrock]

tbl_item.item_description as ProductDetails

You are using what is called an alias here. It means the name of the column you return in your results is "ProductDetails" not "tbl_item.item_description". The ResultSet method getString(String) method needs to use the correct name.

By the way, its not a good ideas to mix JDBC code and JSP. Better to use a bean and seperate the nuts and bolts of talking to the database from the presentation logic in the JSP.

[Shailesh Chandra]

Originally posted by Rajkumar balakrishnan:
Any one is there to help me.....

Be patient Patience Is A Virtue

You are doing it right, but two query you have given are not identical. The query you are running on console is diferent with the code. can you check the same.

Thanks,
Shailesh

[Rajkumar balakrishnan]

Originally posted by Shailesh Chandra:


Be patient Patience Is A Virtue

You are doing it right, but two query you have given are not identical. The query you are running on console is diferent with the code. can you check the same.

Thanks,
Shailesh

Yeah... the one i write in console is to check the working of inner join and one i put in jsp is for my purpose.. So no worry about that.. So please help me ranchers....

[Shailesh Chandra]

Did you follow Paul's post, It seems you have edited your query

tbl_item.item_description as ProductDetails

If your query is like <as ProductDetails> then use rs.getString("ProductDetails") else rs.getString("tbl_item.item_description");

Let us know if it is working.

Thanks,
Shailesh
Sh

[Rajkumar balakrishnan]

Originally posted by Shailesh Chandra:
Did you follow Paul's post, It seems you have edited your query



If your query is like <as ProductDetails> then use rs.getString("ProductDetails") else rs.getString("tbl_item.item_description");

Let us know if it is working.

Thanks,
Shailesh
Sh

Here is the code as per ranchers suggestion i made it... it runs flawlessly in console and not in JSP.. Why..

if(cust_name.equals(""))
{
SQL = "SELECT tbl_rmadetails.date, tbl_rmadetails.serial_no, tbl_item.item_description,tbl_rmadetails.customer_inv_no, tbl_rmadetails.fault_desc, tbl_rmadetails.customer_invoice_date FROM tbl_rmadetails, tbl_item WHERE tbl_rmadetails.item_id = tbl_item.item_id AND status='RFC'";
}
else
{
SQL = "SELECT tbl_rmadetails.date,tbl_rmadetails.serial_no,tbl_item.item_description,tbl_rmadetails.customer_inv_no,tbl_rmadetails.fault_desc,
tbl_rmadetails.customer_inv_date FROM tbl_rmadetails,tbl_item WHERE tbl_rmadetails.item_id=tbl_item.item_id,status='RFC' and customer_id='"+cust_name+"'";
}
ps=db.con.prepareStatement(SQL);
 
rs=ps.executeQuery();
 
if(rs!=null)
{
while(rs.next())
{
%>
<tr bgcolor="#CCCCCC">
<td align="center"><%=rs.getDate("tbl_rmadetails.date")%></td>
<td align="center"><%=rs.getString("tbl_rmadetails.serial_no")%></td>
<td align="center"><%=rs.getString("tbl_item.item_description")%></td>
<td align="center"><%=rs.getString("tbl_rmadetails.customer_inv_no")%></td>
<td align="center"><%=rs.getString("tbl_rmadetails.fault_desc")%></td>
<td align="center"><%=rs.getString("tbl_rmadetails.customer_inv_date")%></td>
</tr>
<%

[ August 12, 2008: Message edited by: Rajkumar balakrishnan ]

[Paul Sturrock]

See my earlier post. This is the reason rs.getString("tbl_item.item_description") returns nothing.

[Rajkumar balakrishnan]

Originally posted by Paul Sturrock:
See my earlier post. This is the reason rs.getString("tbl_item.item_description") returns nothing.

After changing that tpp i cant get anything.... Here is the modified code...

if(cust_name.equals(""))
{
SQL = "SELECT tbl_rmadetails.date, tbl_rmadetails.serial_no, tbl_item.item_description ,tbl_rmadetails.customer_inv_no, tbl_rmadetails.fault_desc, tbl_rmadetails.customer_invoice_date FROM tbl_rmadetails, tbl_item WHERE tbl_rmadetails.item_id = tbl_item.item_id AND status='RFC'";
 
}
else
{
SQL = "SELECT tbl_rmadetails.date,tbl_rmadetails.serial_no,tbl_item.item_description,tbl_rmadetails.customer_inv_no,tbl_rmadetails.fault_desc,
tbl_rmadetails.customer_inv_date FROM tbl_rmadetails,tbl_item WHERE tbl_rmadetails.item_id=tbl_item.item_id,status='RFC' and customer_id='"+cust_name+"'";
}
ps=db.con.prepareStatement(SQL);
 
rs=ps.executeQuery();
 
if(rs!=null)
{
while(rs.next())
{
%>
<tr bgcolor="#CCCCCC">
<td align="center"><%=rs.getDate("tbl_rmadetails.date")%></td>
<td align="center"><%=rs.getString("tbl_rmadetails.serial_no")%></td>
<td align="center"><%=rs.getString("tbl_item.item_description")%></td>
<td align="center"><%=rs.getString("tbl_rmadetails.customer_inv_no")%></td>
<td align="center"><%=rs.getString("tbl_rmadetails.fault_desc")%></td>
<td align="center"><%=rs.getString("tbl_rmadetails.customer_inv_date")%></td>
</tr>
<%

Will someone please give me a solution....

[Paul Sturrock]

I'm going to assume you mean you get no results?

Does:

SELECT tbl_rmadetails.date, tbl_rmadetails.serial_no, tbl_item.item_description ,tbl_rmadetails.customer_inv_no, tbl_rmadetails.fault_desc, tbl_rmadetails.customer_invoice_date 
FROM tbl_rmadetails, tbl_item WHERE tbl_rmadetails.item_id = tbl_item.item_id AND status='RFC'"

return any results when you run it directly in your SQL client?

[Rajkumar balakrishnan]

Originally posted by Paul Sturrock:
I'm going to assume you mean you get no results?

Does:

SELECT tbl_rmadetails.date, tbl_rmadetails.serial_no, tbl_item.item_description ,tbl_rmadetails.customer_inv_no, tbl_rmadetails.fault_desc, tbl_rmadetails.customer_invoice_date 
FROM tbl_rmadetails, tbl_item WHERE tbl_rmadetails.item_id = tbl_item.item_id AND status='RFC'"

return any results when you run it directly in your SQL client?

This is what i got when i type the query in console....

+------------+-----------+------------------------+-----------------+-----------
---+-------------------+
| date       | serial_no | item_description       | customer_inv_no | fault_desc
   | customer_inv_date |
+------------+-----------+------------------------+-----------------+-----------
---+-------------------+
| 2008-08-11 | MOU012    | FARASOO KEYBOARD KBX78 | INV111          | Not detect
ed | 2008-07-21        |
+------------+-----------+------------------------+-----------------+-----------
---+-------------------+
1 row in set (0.00 sec)

But not in JSP file,,,,

[Paul Sturrock]

OK, so one of a number of things could be happening:

You are not running the same query in your JSP as you are in the console.

You are not connected to the database you think you are

Some sort of exception is occuring in your JDBC code

Something is messing up how you render your results. Have you checked the source of the page you return?

This is not related, but I notice you are using a PreparedStatement but not using bind variables. You probably want to fix that too.

[Rajkumar balakrishnan]

Originally posted by Paul Sturrock:
OK, so one of a number of things could be happening:

1.You are not running the same query in your JSP as you are in the console.

2.You are not connected to the database you think you are.

3.Some sort of exception is occuring in your JDBC code.

4.Something is messing up how you render your results. Have you checked the source of the page you return?

This is not related, but I notice you are using a PreparedStatement but not using bind variables. You probably want to fix that too.

Answer for your questions...
1. No
2.Surely not
3.yes. i got after the end of result set exception.. but it is not giving me any problem
4.Thats what i am thinking about.. If somebody do find any messy code please inform me..

When i just give the below query in my JSP page it renders the result ...

SQL = "SELECT * FROM tbl_rmadetails WHERE status='RFC' ";

But when i give these queries it wont render the output...

SQL = "SELECT tbl_rmadetails.date, tbl_rmadetails.serial_no, tbl_item.item_description, tbl_rmadetails.customer_inv_no, tbl_rmadetails.fault_desc, tbl_rmadetails.customer_inv_date FROM tbl_rmadetails, tbl_item WHERE tbl_rmadetails.item_id = tbl_item.item_id AND status='RFC'";

[ August 13, 2008: Message edited by: Rajkumar balakrishnan ]

[Paul Sturrock]

1. No

How do you know for sure? Are you logging the sql statement you are running in your Java app? I'd do this just to be absolutiely sure.

2.Surely not

You'd be surprised how often this mistake happens.

yes. i got after the end of result set exception.. but it is not giving me any problem

I'd look into that if I were you. There is normally no such thing an ignorable exception.

But when i give these queries it wont render the output...

Do you mean you get no results at all, or the table is rendered with no values in it? Have you tried using rs.getString(int) method instead? If there are no results at all, I'd assume that your join condition is never met i.e. there are no records WHERE tbl_rmadetails.item_id = tbl_item.item_id. Add the item_id to the sql query you got to work and check.

4.Thats what i am thinking about.. If somebody do find any messy code please inform me..

Look at the source of the HTML page you JSP renders. Is it valid HTML?

With regards to messy code, like I said earlier its messy to mix JSP and JDBC code. Use a bean. Its also messy to use a PreparedStatement and not use bind variables.
[ August 13, 2008: Message edited by: Paul Sturrock ]

[Shailesh Chandra]

I would like to add one point only, can you try with query below.
I have removed join condition. It will give you cartesian product of both table,also It will let you know if your join clause actually is being satisfied or not

SQL = "SELECT tbl_rmadetails.date, tbl_rmadetails.serial_no, 
tbl_item.item_description, tbl_rmadetails.customer_inv_no, tbl_rmadetails.fault_desc, tbl_rmadetails.customer_inv_date 
FROM tbl_rmadetails, tbl_item WHERE status='RFC'";

Thanks,
Shailesh

[Rajkumar balakrishnan]

Originally posted by Shailesh Chandra:
I would like to add one point only, can you try with query below.
I have removed join condition. It will give you cartesian product of both table,also It will let you know if your join clause actually is being satisfied or not

SQL = "SELECT tbl_rmadetails.date, tbl_rmadetails.serial_no, 
tbl_item.item_description, tbl_rmadetails.customer_inv_no, tbl_rmadetails.fault_desc, tbl_rmadetails.customer_inv_date 
FROM tbl_rmadetails, tbl_item WHERE status='RFC'";

Thanks,
Shailesh

Sorry for such late reply as i am not here for the past few days... As for your query it gives all the item descriptions in the item table like this

mysql> SELECT tbl_rmadetails.date, tbl_rmadetails.serial_no,
    -> tbl_item.item_description, tbl_rmadetails.customer_inv_no, tbl_rmadetails
.fault_desc, tbl_rmadetails.customer_inv_date
    -> FROM tbl_rmadetails, tbl_item WHERE status='RFC';
+------------+-----------+----------------------------+-----------------+-------
-------+-------------------+
| date       | serial_no | item_description           | customer_inv_no | fault_
desc   | customer_inv_date |
+------------+-----------+----------------------------+-----------------+-------
-------+-------------------+
| 2008-08-11 | MOU012    | FARASOO KEYBOARD-KBX       | INV111          | Not de
tected | 2008-07-21        |
| 2008-08-11 | MOU012    | FARASOO KEYBOARD KBX78     | INV111          | Not de
tected | 2008-07-21        |
| 2008-08-11 | MOU012    | FARASOO OPTICAL MOUSE REG  | INV111          | Not de
tected | 2008-07-21        |
| 2008-08-11 | MOU012    | FARASOO OPTICAL MOUSE MINI | INV111          | Not de
tected | 2008-07-21        |
+------------+-----------+----------------------------+-----------------+-------
-------+-------------------+
4 rows in set (0.11 sec)
 

But i need something like this... item_description of product must be based on item_id of product in the rma table.....

mysql> SELECT tbl_rmadetails.date, tbl_rmadetails.serial_no,
    -> tbl_item.item_description, tbl_rmadetails.customer_inv_no, tbl_rmadetails
.fault_desc, tbl_rmadetails.customer_inv_date
    -> FROM tbl_rmadetails, tbl_item WHERE status='RFC' and tbl_item.item_id=tbl
_rmadetails.item_id;
+------------+-----------+------------------------+-----------------+-----------
---+-------------------+
| date       | serial_no | item_description       | customer_inv_no | fault_desc
   | customer_inv_date |
+------------+-----------+------------------------+-----------------+-----------
---+-------------------+
| 2008-08-11 | MOU012    | FARASOO KEYBOARD KBX78 | INV111          | Not detect
ed | 2008-07-21        |
+------------+-----------+------------------------+-----------------+-----------
---+-------------------+
1 row in set (0.00 sec)

Please let me know how do i get the result.... I'll give you the complete code in which i find problems......

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="err_login_session.jsp" %>
<%@ page import="java.text.SimpleDateFormat"%>
<%@ page import="java.util.Date"%>
<%@ page import="com.rajk.javacode.servlets.dbmodel"%>
 
<html>
<style type="text/css">
<!--
.style1 {
color: #0066CC;
font-weight: bold;
}
.style2 {color: #ECE9D8}
-->
</style>
<body>
<table width="100%" border="0">
<tr bgcolor="#0066CC">
<td align="center"><span class="style2">Date</span></td>
<td align="center" class="style2">Serial No</td>
<td align="center" class="style2">Item Details</td>
<td align="center" class="style2">Customer Inv.No</td>
<td align="center" class="style2">Fault Desc</td>
<td align="center" class="style2">Invoice Date</td>
<tr>
<%
String cust_name = request.getParameter("q");
 
try
{
dbmodel db=new dbmodel();
 
String SQL = null;
Statement ps = null;
ResultSet rs = null;
db.connect();
 
if(cust_name.equals("Get Report"))
{
SQL = "SELECT tbl_rmadetails.date, tbl_rmadetails.serial_no, tbl_item.item_description, tbl_rmadetails.customer_inv_no, tbl_rmadetails.fault_desc, tbl_rmadetails.customer_inv_date FROM tbl_rmadetails, tbl_item WHERE tbl_rmadetails.item_id = tbl_item.item_id AND status='RFC'";
}
else
{
SQL = "SELECT tbl_rmadetails.date,tbl_rmadetails.serial_no,tbl_item.item_description,tbl_rmadetails.customer_inv_no,tbl_rmadetails.fault_desc,
tbl_rmadetails.customer_inv_date FROM tbl_rmadetails,tbl_item WHERE tbl_rmadetails.item_id=tbl_item.item_id AND status='RFC' AND customer_id='"+cust_name+"'";
}
 
ps=db.con.createStatement();
 
rs=ps.executeQuery(SQL);
 
if(rs!=null)
{
while(rs.next())
{
%>
<tr bgcolor="#CCCCCC">
<td align="center"><%=rs.getDate("date")%></td>
<td align="center"><%=rs.getString("serial_no")%></td>
[B]<td align="center"><%=rs.getString("item_description")%>[/B]</td>//This is where i stuck...
<td align="center"><%=rs.getString("customer_inv_no")%></td>
<td align="center"><%=rs.getString("fault_desc")%></td>
<td align="center"><%=rs.getDate("customer_inv_date")%></td>
</tr>
 
<%
}
}
else
{
out.println("Result Set is empty");
}
}
catch(Exception e)
{
e.printStackTrace();
}
response.setContentType("text/xml");
response.setHeader("Cache-Control", "no-cache");
%>
</table>
</body>
</html>
 

Please help me ranchers.......

[Paul Sturrock]

Have you tried using rs.getString(int) instead? You might also try looking at the ResultSetMEtaData to see what columns have been returned.

NB: if your JDBC code wasn't mixed in with your JSP code you would be able to debug this easily without any concerns about soemthing else (such as invalid HTML) hiding output.
[ August 19, 2008: Message edited by: Paul Sturrock ]

[Rajkumar balakrishnan]

Originally posted by Paul Sturrock:
Have you tried using rs.getString(int) instead? You might also try looking at the ResultSetMEtaData to see what columns have been returned.

NB: if your JDBC code wasn't mixed in with your JSP code you would be able to debug this easily without any concerns about soemthing else (such as invalid HTML) hiding output.

Sure i will take a look on it and report it here.....Could i use this one
rs.getString("tbl_rmadetails.serial_no"); instead of rs.getString("serial_no")???

[Paul Sturrock]

Now I'm confused. I didn't think it was the serial_no field you were having trouble with?

You shouldn't need the table name on the field name. Your database should return a result set that just includes the field. The field name should be the same in your SQL Client and via JDBC.

[Rajkumar balakrishnan]

Originally posted by Paul Sturrock:
Now I'm confused. I didn't think it was the serial_no field you were having trouble with?

You shouldn't need the table name on the field name. Your database should return a result set that just includes the field. The field name should be the same in your SQL Client and via JDBC.

I just write that for an example.... But the problem is really with the "item_id" field... When the resultset traverse and when it comes to item_id it didn't return anything.... As i check it it returns something like this...

Date     SerialNo  ItemDetails  Cust.Inv.No  Fault Desc  Inv Date
----     --------  -----------  -----------  ----------  ---------
08/11/08 MO565

The remainig fields seems to be null.... ie..the item details is the problematic area.... (The output shown above is not in exact format as i get)

[Paul Sturrock]

So the above result is what you get in your MySQL client when you run the SQL:

SELECT tbl_rmadetails.date, 
       tbl_rmadetails.serial_no, 
       tbl_item.item_description, 
       tbl_rmadetails.customer_inv_no, 
       tbl_rmadetails.fault_desc, 
       tbl_rmadetails.customer_inv_date 
FROM tbl_rmadetails, tbl_item 
WHERE tbl_rmadetails.item_id = tbl_item.item_id 
AND status='RFC';

Yes? Now I'm even more confused because in earlier posts you said that this query returned different results?

So are we trying to fix the query or its display logic?

(The output shown above is not in exact format as i get)

I'm not sure there is any point us trying to help if you don't tell us exactly what is happening and how it is going wrong. Without that we are just guessing.
[ August 20, 2008: Message edited by: Paul Sturrock ]

[Rajkumar balakrishnan]

Originally posted by Paul Sturrock:
So the above result is what you get in your MySQL client when you run the SQL:

SELECT tbl_rmadetails.date, 
       tbl_rmadetails.serial_no, 
       tbl_item.item_description, 
       tbl_rmadetails.customer_inv_no, 
       tbl_rmadetails.fault_desc, 
       tbl_rmadetails.customer_inv_date 
FROM tbl_rmadetails, tbl_item 
WHERE tbl_rmadetails.item_id = tbl_item.item_id 
AND status='RFC';

Yes? Now I'm even more confused because in earlier posts you said that this query returned different results?

So are we trying to fix the query or its display logic?


I'm not sure there is any point us trying to help if you don't tell us exactly what is happening and how it is going wrong. Without that we are just guessing.

[ August 20, 2008: Message edited by: Paul Sturrock ]

I apologise for that but i just mention that the output is not same as it is in graphical format. But this is what i got in my HTML page.
May be its display logic is poor.... I too suspect that but i don't know how to fix it....
Please help me ranchers...


[ August 21, 2008: Message edited by: Rajkumar balakrishnan ]

[Rajkumar balakrishnan]

I got an exception like this

Error: java.sql.SQLException: After end of result set

Will it be the cause of my problem...???
I swear on it....

Please help me ranchers...