Hi Bill,
2 points:
please check out the sources with CRLF set to dos. You have doubled
lines in the sources.
With the debugger set a breakpoint in in the FieldValue.toString method
an look wich field is not defined here. Seems that getField() returns null.
Good luck
Henner
> -----Ursprüngliche Nachricht-----
> Von: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Im
> Auftrag von Bill Tribley
> Gesendet: Mittwoch, 20. April 2005 06:20
> An: jdbforms-interest@lists.sourceforge.net
> Betreff: [dbforms] Using Queries
>
> I need to present a denormalized view for reports. Since
> MySQL does not support views in earlier releases, I decided
> to use dbforms query construct in the dbforms-config.xml
> specification.
>
> 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(JspServlet
> Wrapper.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.internalDoFilt
> er(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_fi
> lter_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
>
-------------------------------------------------------
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
