Statement in Java.sql

[ShoKazamatsuri]

My code :

64: stmt2 = con2.createStatement();
65:
66: if( stmt2.executeUpdate(query.toString()) > 0 )
67: {
68: query = new StringBuilder();
69: query.append(" UPDATE TrJenisSoal ");

And its produce

root cause

javax.servlet.ServletException: General error
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
org.apache.jsp.Soal.UpdateSoalProses_jsp._jspService(UpdateSoalProses_jsp.java:188)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368)


root cause

java.sql.SQLException: General error
sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6986)
sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3110)
sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(JdbcOdbcStatement.java:288)
org.apache.jsp.Soal.UpdateSoalProses_jsp._jspService(UpdateSoalProses_jsp.java:135)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368)

It's weird because my first statement(stmt) running well before the second statement.

StringBuilder query = new StringBuilder();
query.append(" UPDATE MsSoal ");
query.append(" SET Stsrc = 'U', ");
query.append(" PilihanA = '" + txtPilihanA + "', ");
query.append(" PilihanB = '" + txtPilihanB + "', ");
query.append(" PilihanC = '" + txtPilihanC + "', ");
query.append(" PilihanD = '" + txtPilihanD + "', ");
query.append(" PilihanE = '" + txtPilihanE + "', ");
query.append(" Jawaban = '" + txtJawaban + "', ");
query.append(" NmSoal = '" + txtNamaSoal + "' ");
query.append(" WHERE KdSoal = " + kdSoal);

if( stmt.executeUpdate(query.toString()) > 0 )
{
query = new StringBuilder();
query.append(" UPDATE TrPaketSoal ");
query.append(" SET Stsrc = 'U', ");
query.append(" KdPaket = '" + selectKodePaket + "' ");
query.append(" WHERE KdSoal = " + kdSoal);

....
Sory if my question is dumb, maybe because I'm a newbie.

Thx in advance