Null pointer exceptions are back. Any ideas would be appreciated! Thanks, Bill
2005-04-19 22:54:24 StandardContext[/manager]Manager: restart: Reloading web application at '/prayerdb'
2005-04-19 22:54:24 StandardContext[/prayerdb]config: finalizing
2005-04-19 22:54:36 StandardWrapperValve[jsp]: Servlet.service() for servlet jsp threw exception
java.lang.NullPointerException
at org.dbforms.config.FieldValue.toString(FieldValue.java:718)
at org.dbforms.config.Table.getFilterFieldArray(Table.java:5035)
at org.dbforms.taglib.DbFormTag.doStartTag(DbFormTag.java:2769)
at org.apache.jsp.displayRequests_jsp._jspService(displayRequests_jsp.java:193)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
displayRequests_jsp.java:182-193 is :
org.dbforms.taglib.DbFormTag _jspx_th_db_dbform_0 = (org.dbforms.taglib.DbFormTag) _jspx_tagPool_db_dbform_tableName_orderBy_multipart_maxRows_filter_autoUpdate.get(org.dbforms.taglib.DbFormTag.class);
_jspx_th_db_dbform_0.setPageContext(_jspx_page_context);
_jspx_th_db_dbform_0.setParent(null);
_jspx_th_db_dbform_0.setMultipart("false");
_jspx_th_db_dbform_0.setAutoUpdate("false");
_jspx_th_db_dbform_0.setMaxRows("*");
_jspx_th_db_dbform_0.setFilter("request_summary=MyFavoriteMartian");
_jspx_th_db_dbform_0.setTableName("allRequestInfo");
_jspx_th_db_dbform_0.setOrderBy("request_category,request_summary");
int[] _jspx_push_body_count_db_dbform_0 = new int[] { 0 };
try {
int _jspx_eval_db_dbform_0 = _jspx_th_db_dbform_0.doStartTag();
The query is (the from was checked in MySQL and it works):
<query name="allRequestInfo"
from="requests r
INNER JOIN eperson ep
ON r.requestor_id=ep.person_id
INNER JOIN sensitivities s
ON r.sensitivity=s.sensitivity" >
<field name="r.request_id" fieldType="int" />
<field name="r.requestor_id" fieldType="int" />
<field name="r.recipient_id" fieldType="int" />
<field name="r.sensitivity" fieldType="int" />
<field name="r.gender_specific" fieldType="char" />
<field name="r.request_summary" fieldType="char" isKey="true" />
<field name="r.request_detail" fieldType="char" />
<field name="r.request_category" fieldType="char" isKey="true"
/>
<field name="r.alert_age" fieldType="int" />
<field name="r.status" fieldType="char" />
<field name="r.created" fieldType="timestamp" isKey="true"/>
<field name="r.created_by" fieldType="char" />
<field name="r.modified" fieldType="timestamp" isKey="true"/>
<field name="r.modified_by" fieldType="char" />
<field name="ep.lastname" fieldType="char" isKey="true" />
<field name= "ep.firstname" fieldType="char" isKey="true" />
<field name="s.selector_display" fieldType="char" isKey="true"
/>
</query>
------------------------------------------------------- This SF.Net email is sponsored by: New Crystal Reports XI. Version 11 adds new functionality designed to reduce time involved in creating, integrating, and deploying reporting solutions. Free runtime info, new features, or free trial, at: http://www.businessobjects.com/devxi/728 _______________________________________________ DbForms Mailing List
http://www.wap-force.net/dbforms
