Multiple Prepared Statements in JSP

[CodeBoy101]

Hello all, I've been working on a project where I wish to retrieve two sets of information from a MySQL database using two prepared statements. When I try to do this I get a blank screen, but the first query is successfull executed. Any suggestion would be greatly appreciated.

Thanks.

[kvprajapati]

....
      String query = "insert into table(stringcol, numcol) values(?, ?)";
      pstmt = conn.prepareStatement(query);
      pstmt.setString(1, "A");
      pstmt.setInt(2, 10);
      pstmt.addBatch();

      pstmt.setString(1, "B");
      pstmt.setInt(2, 2);
      pstmt.addBatch();

      int[] updateCounts = pstmt.executeBatch();
      checkUpdateCounts(updateCounts);
      conn.commit();
      ....

[peter_budo]

Hello all, I've been working on a project where I wish to retrieve two sets of information from a MySQL database using two prepared statements. When I try to do this I get a blank screen, but the first query is successfull executed. Any suggestion would be greatly appreciated.

Thanks.

Not normal behaviour. If adatapost will not solve it please provide code sample of you using.

[CodeBoy101]

I have a question, what if I was trying to work with more than one table?

[peter_budo]

I have a question, what if I was trying to work with more than one table?

It makes no difference to us...

Now, are you gone answer previous question about code you using?