This week's book giveaway is in the OCMJEA forum. We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line! See this thread for details.
hey folks, the code: ----------- ResultSet r1=statement.executeQuery(select * a); ResultSet r2=statement.executeQuery(select * b); ----------- for some reason r1 is ok, but r2 is empty. if i make a totally new statement for the second ResultSet, like this: ----------- ResultSet r1=statement1.executeQuery(select * a); ResultSet r2=statement2.executeQuery(select * b); ----------- everything works fine. i just don't want to open another connection to make a second statement, and i have examples where the first solution works fine. any ideas what is the problem? thnx