Thread: Servlet cant perform sql after second button click

Hi there, I need some guidance on my servlet.

Does anyone expert in iterator part of built in package of java libary List?
List dataList = new ArrayList();

Iterator itr;
for(itr=data.iterator();itr.hasNext();)

Actually I m able to perform first query with data display..but when I click on other button..it cant proceed servlet and it gv me blank page.
Servlet.java

String sql="select * from a natural left join b" +
                   "natural left crecord natural left join dwhere jobid="+jobid+
                   "order by recordid";
 
            stmt = conn.createStatement();
            stmt.executeQuery(sql);
            rs=stmt.getResultSet();
            List dataList = new ArrayList();
 
 
            while(rs.next())
            {
 
            dataList.add(rs.getInt("xxx"));
            }

p/s: my form sure ok just dunno why cant read my parameter

I bet your query is wrong.

sorry typo...impossible wrong i m able to run at netbean

String sql="select * from a natural left join b" +
                   "natural left join c natural left join d where jobid="+jobid+
                   "order by recordid";

Yeah now you may run it. First not even possible whatever it was typo or....
Compile your servlet class again and put in the path....
I think you are loosing cursor when you perform some other event. YOu know writing explicit cursor in sql?

erm sorry could u guide me?i m newbie in servlet..

You are using APACHE?
If yes, again compile your servlet, copy it's .CLASS file from the folder where netbeans has created project folder and in APACHE directory place it inside classes folder.

ya apache..

Then do as i told you to do.

sorry where is servlet.CLASS located?

You must read this.

Problem solved. thanks to those respondants.Erm the problem is due to join tables and parameter passing..