Dear All,
I'm trying to use interceptor with dbforms and they work fine, but I can't find
a way to show my custom error message on the related JSP, it's just on the
tomcat log, and the error tag on the JSP just shows some null errors, something
like this:
Error:
* null
Extra info:
1) This is my dbforms-config.xml section:
<table name="servicios"
defaultVisibleFields="ser_id" >
<field name="ser_id" fieldType="int4" size="4" isKey="true"
autoInc="true"/>
<field name="ser_nombre" fieldType="varchar" size="30"/>
<field name="ser_codigo" fieldType="varchar" size="4"/>
<field name="ser_descripcion" fieldType="varchar" size="255"/>
<field name="ser_tsr_id" fieldType="int4" size="4"/>
<field name="ser_emp_id" fieldType="int4" size="4"/>
<field name="ser_cue_id" fieldType="int4" size="4"
isKey="true"/>
<field name="ser_srv_id" fieldType="int4" size="4"/>
<field name="ser_esr_id" fieldType="int4" size="4"/>
<field name="ser_valor" fieldType="varchar" size="999"/>
<interceptor
className =
"com.contacta.crm.interceptor.InterceptorServicio"
/>
</table>
2) This is the preInsert method code:
public int preInsert(HttpServletRequest request,
Table table,
FieldValues fieldValues,
DbFormsConfig config,
Connection con) throws ValidationException {
String ser_nombre = fieldValues.get("ser_nombre").getFieldValue();
String ser_codigo = fieldValues.get("ser_codigo").getFieldValue();
String ser_srv_id = fieldValues.get("ser_srv_id").getFieldValue();
System.out.print(ser_nombre);
String query = "SELECT ser_nombre, ser_codigo, ser_srv_id FROM
servicios
WHERE ser_nombre='"+ser_nombre+"'"
+"OR ser_codigo='"+ser_codigo+"'AND ser_srv_id='"+ser_srv_id+"'";
try {
System.out.print(query);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(query);
System.out.print(rs);
if (rs.next())
{
//return IGNORE_OPERATION;
throw new ValidationException("El nombre de servicio
o
el codigo ya existen.");
}
else {
return GRANT_OPERATION;}
}catch (Exception e) {
e.printStackTrace();
return DENY_OPERATION;
}
}
3) And this is the error messaje on the tomcat log:
TESTYSELECT ser_nombre, ser_codigo, ser_srv_id FROM servicios WHERE
ser_nombre='TESTY'OR ser_codigo='1111'AND
ser_srv_id='1'[EMAIL PROTECTED]:
The service name already exists.
I would really appreciate any ideas to solve this. I have worked too much hours
without success and have no more time.
Thanks in advance to all dbforms community !!!!
Alfred Certain
-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
