Error while using finder methods in Orion Server
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Velivela_Srinivas
Posted On:   Wednesday, January 23, 2002 04:39 AM

I am getting the following error while using the finder methods in orion server. if am accessing data using findByAll method i am getting data. if i am using any parameterized finder method then i am getting the below error com.evermind[Oracle9iAS (1.0.2.2) Containers for J2EE].server.rmi.OrionRemoteException: Transaction was rolled back: Database error: java.sql.SQLException: ORA-00904: invalid column name at DealerDetailsHome_EntityHomeWrapper2.findByRegionCode(DealerDetailsHome_EntityHomeWrapper2.java:1056) at /adminytdperformance.jsp._jspService(/adminytdperformance.jsp.java:69) (JSP page line 234) at com.orionserver[Oracle9iAS (1.0.2.2) Containers for J2EE].http.OrionHttpJspPage.service(OrionHttpJspPage.java:   More>>

I am getting the following error while using the finder methods in orion server. if am accessing data using findByAll method i am getting data. if i am using any parameterized finder method then i am getting the below error




com.evermind[Oracle9iAS (1.0.2.2) Containers for J2EE].server.rmi.OrionRemoteException: Transaction was rolled back: Database error: java.sql.SQLException: ORA-00904: invalid column name
at DealerDetailsHome_EntityHomeWrapper2.findByRegionCode(DealerDetailsHome_EntityHomeWrapper2.java:1056)
at /adminytdperformance.jsp._jspService(/adminytdperformance.jsp.java:69) (JSP page line 234)
at com.orionserver[Oracle9iAS (1.0.2.2) Containers for J2EE].http.OrionHttpJspPage.service(OrionHttpJspPage.java:54)
at com.evermind[Oracle9iAS (1.0.2.2) Containers for J2EE].server.http.HttpApplication.serviceJSP(HttpApplication.java:5458)
at com.evermind[Oracle9iAS (1.0.2.2) Containers for J2EE].server.http.JSPServlet.service(JSPServlet.java:31)
at com.evermind[Oracle9iAS (1.0.2.2) Containers for J2EE].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:501)
at com.evermind[Oracle9iAS (1.0.2.2) Containers for J2EE].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:170)
at com.evermind[Oracle9iAS (1.0.2.2) Containers for J2EE].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:576)
at com.evermind[Oracle9iAS (1.0.2.2) Containers for J2EE].server.http.HttpRequestHandler.run(HttpRequestHandler.java:189)
at com.evermind[Oracle9iAS (1.0.2.2) Containers for J2EE].util.ThreadPoolThread.run(ThreadPoolThread.java:62)
Nested exception is:
java.sql.SQLException: ORA-00904: invalid column name
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:643)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1819)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2015)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:395)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:339)
at com.evermind[Oracle9iAS (1.0.2.2) Containers for J2EE].sql.FilterPreparedStatement.executeQuery(FilterPreparedStatement.java:269)
at com.evermind[Oracle9iAS (1.0.2.2) Containers for J2EE].sql.FilterPreparedStatement.executeQuery(FilterPreparedStatement.java:269)
at DealerDetailsHome_EntityHomeWrapper2.findByRegionCode(DealerDetailsHome_EntityHomeWrapper2.java:916)
at /adminytdperformance.jsp._jspService(/adminytdperformance.jsp.java:69) (JSP page line 234)
at com.orionserver[Oracle9iAS (1.0.2.2) Containers for J2EE].http.OrionHttpJspPage.service(OrionHttpJspPage.java:54)
at com.evermind[Oracle9iAS (1.0.2.2) Containers for J2EE].server.http.HttpApplication.serviceJSP(HttpApplication.java:5458)
at com.evermind[Oracle9iAS (1.0.2.2) Containers for J2EE].server.http.JSPServlet.service(JSPServlet.java:31)
at com.evermind[Oracle9iAS (1.0.2.2) Containers for J2EE].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:501)
at com.evermind[Oracle9iAS (1.0.2.2) Containers for J2EE].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:170)
at com.evermind[Oracle9iAS (1.0.2.2) Containers for J2EE].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:576)
at com.evermind[Oracle9iAS (1.0.2.2) Containers for J2EE].server.http.HttpRequestHandler.run(HttpRequestHandler.java:189)
at com.evermind[Oracle9iAS (1.0.2.2) Containers for J2EE].util.ThreadPoolThread.run(ThreadPoolThread.java:62)



Help me in solving this problem.



Thanks



Srinivas

   <<Less

Re: Error while using finder methods in Orion Server

Posted By:   Velivela_Srinivas  
Posted On:   Thursday, January 24, 2002 05:51 AM

In the orion-ejb.xml file, in the finder query we have to specify the table name but not the ejb-name and the column name should also be as in the table but not the bean field variable.

Example :




region
findByRegionCode

java.lang.Integer






Srinivas
About | Sitemap | Contact