Select multiple tables using single resultset - SQLException: ORA-00933: SQL command not properly en

[Albert Hopkins]

Hi...

I wrote

  ResultSet rs25 = stmt.executeQuery("SELECT count(BLESS_SEVERITY) as sbmseverity3 from BLESS where BLESS_SEVERITY=3 
AND bless_orno like '%_QSC_%'" + "SELECT count(BLESS_SEVERITY) as no2 from bless");
rs25.next();
out.println("<p>Test with harstate (SEV1) = "+ rs25.getInt("sbmseverity3") + "</p>");
out.println("<p>Test with harstate (SEV1) = "+ rs25.getInt("no2") + "</p>");  

But, I got SQLException: ORA-00933: SQL command not properly ended message.

What I did wrong?? please

[Swastik Dey]

your sql evaluates to this

SELECT count(BLESS_SEVERITY) as sbmseverity3 from BLESS where BLESS_SEVERITY=3
AND bless_orno like '%_QSC_%' SELECT count(BLESS_SEVERITY) as no2 from bless);

and the above does not seem to be a valid sql.

[Bear Bibeault]

Please take the time to choose the correct forum for your posts. This forum is for questions on JSP.

For more information, please read this.

This post has been moved to a more appropriate forum.