bc4j VO setWhereClauseParam problem
I have noticed a peculiar problem in Bc4J and was wondering if any one had come across this one earlier.
I am setting the where clause for a VO in a JSP using the setWhereClauseParam tag
<jbo:DataSource id="ds" appid="bc4jModule" viewobject="TestView" rangesize="-1" itermode="LastPagePartial" >
<jbo:SetWhereClauseParam index="0" value="<%=projID%>" datasource="ds"/>
</jbo:DataSource>
The projID is a number in the oracle table and so when i pass an alphanumeric value to it,it gives an oracle error as expected.
Error Message: ORA-01722: invalid number .
But after this,when i try to pass the correct value to the VO the next time,i get a null pointer error.Until i restart the server,the JSP cannot be accessed.
This is the stack trace:
java.lang.NullPointerException
oracle.jbo.Row oracle.jbo.server.ViewRowSetImpl.getRow(int)
ViewRowSetImpl.java:2619
void oracle.jbo.server.ViewRowSetIteratorImpl.doFetch(int)
ViewRowSetIteratorImpl.java:2347
void oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed()
ViewRowSetIteratorImpl.java:2211
int oracle.jbo.server.ViewRowSetIteratorImpl.setRangeStart(int)
ViewRowSetIteratorImpl.java:2157
int oracle.jbo.server.ViewRowSetImpl.setRangeStart(int)
ViewRowSetImpl.java:1726
int oracle.jbo.server.ViewObjectImpl.setRangeStart(int)
ViewObjectImpl.java:4718
void oracle.jbo.html.jsp.datatags.DataScroller.initialize(javax.servlet.jsp.PageContext, java.lang.String)
DataScroller.java:46
java.lang.String oracle.jbo.html.jsp.datatags.ScrollBarTag.getUrl()
ScrollBarTag.java:71
int oracle.jbo.html.jsp.datatags.ComponentTag.doStartTag()
ComponentTag.java:64
void TestView_Browse._jspService(javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
TestView_Browse.jsp:21
void oracle.jsp.runtime.HttpJsp.service(javax.servlet.ServletRequest, javax.servlet.ServletResponse)
HttpJsp.java:139
void oracle.jsp.runtimev2.JspPageTable.service(javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse, java.lang.String)
JspPageTable.java:317
void oracle.jsp.runtimev2.JspServlet.internalService(javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
JspServlet.java:465
void oracle.jsp.runtimev2.JspServlet.service(javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
JspServlet.java:379
void javax.servlet.http.HttpServlet.service(javax.servlet.ServletRequest, javax.servlet.ServletResponse)
HttpServlet.java:853
void com.evermind.server.http.ServletRequestDispatcher.invoke(javax.servlet.ServletRequest, javax.servlet.ServletResponse)
ServletRequestDispatcher.java:721
void com.evermind.server.http.ServletRequestDispatcher.forwardInternal(javax.servlet.ServletRequest, javax.servlet.http.HttpServletResponse)
ServletRequestDispatcher.java:306
boolean com.evermind.server.http.HttpRequestHandler.processRequest(com.evermind.server.ApplicationServerThread, com.evermind.server.http.EvermindHttpServletRequest, com.evermind.server.http.EvermindHttpServletResponse, java.io.InputStream, java.io.OutputStream, boolean)
HttpRequestHandler.java:767
void com.evermind.server.http.HttpRequestHandler.run(java.lang.Thread)
HttpRequestHandler.java:259
void com.evermind.server.http.HttpRequestHandler.run()
HttpRequestHandler.java:106
void EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run()
PooledExecutor.java:803
void java.lang.Thread.run()
Thread.java:484
Even after restarting the server,I get the following error the first time when i access the page,
Error Message: JBO-30003: The application pool (bc4jModuleLocal) failed to checkout an application module due to the following exception:
Error Message: JBO-25222: Unable to create application module.
JBO-30003: The application pool (bc4jModuleLocal) failed to checkout an application module due to the following exception:
oracle.jbo.JboException: JBO-25222: Unable to create application module.
....
....more error messages here
...
## Detail 0 ##
javax.naming.NamingException. Root exception is oracle.jbo.NoXMLFileException: JBO-26001: XML File not found for the Container Mybc4j.jpx
The error disappears after forcing the page to be refreshed twice.
Has any come across such a problem and found the solution to it?
The environment used is Tomcat 4.1.18 and Jdev 9.0.3