Doesn´t works with null values
Status: Alpha
Brought to you by:
danielaparker
Menu
▾
▴
#3 Doesn´t works with null values
With this configuration:
PAGES
<px:page name="rdo_descarga/html">
<px:show>
<px:transform>
<px:content ref="myapp:rdo_descarga"/>
</px:transform>
</px:show>
</px:page>
DOCUMENDS
<px:sqlContent name="rdo_descarga">
<px:jdbcConnectionPool name="jdbc-pool"
driver="oracle.jdbc.driver.OracleDriver"
databaseURL="jdbc:oracle:thin:@xx:1521:xxx"
user="xxxx"
password="xxxx"
minConnections="2"
testStatement="SELECT * FROM
DUAL"/>
<px:sqlQuery>
SELECT
CODIGO,FECHA_SOL,TIPO_SOLICITUD,TIPO_INSTITUCION
,NOMBRE,EMAIL,FAX,DIRECCION,
POBLACION,PROVINCIA
FROM ST_SOL_PUBLICACIONES
WHERE CODIGO LIKE '19%'
</px:sqlQuery>
<px:recordSetMapping>
<ROWSET>
<px:recordMapping>
<ROW>
<px:fieldElementMap field="CODIGO"
element="CODIGO"/>
<px:fieldElementMap field="FECHA_SOL"
element="FECHA_SOL"/>
<px:fieldElementMap
field="TIPO_SOLICITUD" element="TIPO_SOLICITUD"/>
<px:fieldElementMap
field="TIPO_INSTITUCION"
element="TIPO_INSTITUCION"/>
<px:fieldElementMap field="NOMBRE"
element="NOMBRE"/>
<px:fieldElementMap field="EMAIL"
element="EMAIL"/>
<px:fieldElementMap field="FAX"
element="FAX"/>
<px:fieldElementMap field="DIRECCION"
element="DIRECCION"/>
<px:fieldElementMap field="POBLACION"
element="POBLACION"/>
<px:fieldElementMap field="PROVINCIA"
element="PROVINCIA"/>
</ROW>
</px:recordMapping>
</ROWSET>
</px:recordSetMapping>
</px:sqlContent>
then its produces this result in the catalina.out
EXCEPTION 400 null
java.lang.NullPointerException
at
com.presentingxml.components.recordset.FieldElementBin
ding.parse(FieldElementBinding.java:168)
at
com.presentingxml.components.recordset.LiteralElementBi
nding.parse(LiteralElementBinding.java:193)
at
com.presentingxml.components.recordset.RecordBinding.
writeRecord(RecordBinding.java:90)
at
com.presentingxml.components.recordset.RecordSetWrite
rImpl.writeRecord(RecordSetWriterImpl.java:104)
at
com.presentingxml.components.content.sql.SQLRecordRe
ader.readRecords(SQLRecordReader.java:110)
at
com.presentingxml.components.content.sql.SQLXMLReade
r.parse(SQLXMLReader.java:114)
at
com.presentingxml.components.content.BaseXMLReader.p
arse(BaseXMLReader.java:151)
at
com.presentingxml.components.Pipeline.execute
(Pipeline.java:99)
at
com.presentingxml.components.serializer.xml.XMLSerialize
r.serialize(XMLSerializer.java:110)
at
com.presentingxml.components.show.PageRendererImpl.r
ender(PageRendererImpl.java:69)
at
com.presentingxml.components.show.PageDisplayer.exec
utePipeline(PageDisplayer.java:119)
at
com.presentingxml.components.page.PageImpl.executePip
eline(PageImpl.java:97)
at
com.presentingxml.presenter.http.ServletPageContext.ex
ecutePipeline(ServletPageContext.java:328)
at
com.presentingxml.presenter.AbstractPageContext.transf
er(AbstractPageContext.java:102)
at
com.presentingxml.components.redirect.local.LocalRedirec
tor.redirect(LocalRedirector.java:56)
at
com.presentingxml.components.redirect.AbstractRedirect
or.executePipeline(AbstractRedirector.java:93)
at
com.presentingxml.components.page.PageImpl.executePip
eline(PageImpl.java:97)
at
com.presentingxml.presenter.http.ServletPageContext.ex
ecutePipeline(ServletPageContext.java:328)
at
com.presentingxml.components.validate.RequestValidatorI
mpl.validate(RequestValidatorImpl.java:64)
at
com.presentingxml.components.app.AppImpl.validateRequ
est(AppImpl.java:80)
at
com.presentingxml.presenter.http.PresenterServlet.servic
e(PresenterServlet.java:160)
at javax.servlet.http.HttpServlet.service
(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDo
Filter(ApplicationFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke
(StandardWrapperValve.java:256)
at
org.apache.catalina.core.StandardPipeline$StandardPipeli
neValveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke
(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContextValve.invoke
(StandardContextValve.java:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipeli
neValveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke
(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContext.invoke
(StandardContext.java:2422)
at
org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java:180)
at
org.apache.catalina.core.StandardPipeline$StandardPipeli
neValveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke
(ErrorDispatcherValve.java:171)
at
org.apache.catalina.core.StandardPipeline$StandardPipeli
neValveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.valves.ErrorReportValve.invoke
(ErrorReportValve.java:163)
at
org.apache.catalina.core.StandardPipeline$StandardPipeli
neValveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke
(ContainerBase.java:995)
at
org.apache.catalina.core.StandardEngineValve.invoke
(StandardEngineValve.java:174)
at
org.apache.catalina.core.StandardPipeline$StandardPipeli
neValveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke
(ContainerBase.java:995)
at
org.apache.coyote.tomcat4.CoyoteAdapter.service
(CoyoteAdapter.java:199)
at
org.apache.coyote.http11.Http11Processor.process
(Http11Processor.java:828)
at
org.apache.coyote.http11.Http11Protocol$Http11Connec
tionHandler.processConnection(Http11Protocol.java:700)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt
(PoolTcpEndpoint.java:584)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunna
ble.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
If I change the sql to:
SELECT
CODIGO,FECHA_SOL,TIPO_SOLICITUD,TIPO_INSTITUCION
,NOMBRE,EMAIL,FAX,DIRECCION,
POBLACION,
NVL(PROVINCIA,0) AS PROVINCIA
FROM ST_SOL_PUBLICACIONES
WHERE CODIGO LIKE '19%'
It works, becouse the code doesn´t control null values,
but XSLT transformations
accepts and process strings like
<PROVINCIA></PROVINCIA>
I tink it will be good to correct this bug.
Logged In: YES
user_id=218806
Thanks for reporting this, I'll have a look at it.