Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

bc4j VO setWhereClauseParam problem

179663Jun 5 2003
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

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 3 2003
Added on Jun 5 2003
0 comments
113 views