Hi,
I have a problem wit setSQL.
My coding like below,
PHP Code:
try {
sql = "SELECT " + COLUMN_1 + c + COLUMN_2 + c + COLUMN_3 + c + COLUMN_4;
sql2 = " FROM " + PARAM_TABLE + " ORDER BY " + COLUMN_1 + c + COLUMN_2;
sqlUtil.setSQL(sql+sql2);
DefaultLogger.debug(this, '\n'+"SQL String-> " + sql +'\n'+ sql2);
}
catch (SQLException e) {
e.printStackTrace();
throw new SQLException("Could not set SQL query");
}
and get error like below,
Code:
Exception =
java.sql.SQLException: Could not set SQL query
at com.bkr.retail.app.common.ParamDAO.getParameterList(ParamDAO.java:66)
at com.bkr.retail.ui.common.ParamManager.getParameterData(ParamManager.java:43)
at com.bkr.retail.ui.common.ParamManager.<init>(ParamManager.java:29)
at com.bkr.retail.ui.common.ParamHelper.getInstance(ParamHelper.java:22)
at com.bkr.retail.ui.financing.FinancingEligibilityCheckPersonalLoanFormValidator.validateInput(FinancingEligibilityCheckPersonalLoanFormValidator.java:110)
at com.bkr.retail.ui.financing.FinancingEligibilityCheckPersonalLoanAction.validateInput(FinancingEligibilityCheckPersonalLoanAction.java:167)
at com.bkr.retail.ui.common.framework.CommonAction.perform(CommonAction.java:260)
at org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.java:1720)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1519)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:505)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1006)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:419)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:315)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6722)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3764)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2644)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)
Can anyone help me with this problem? Really have no idea why.
I'm using j2sdk1.4.2_05..