Hi gurus,
I have written findByNumber() method which is supposed to get all the
data(records from the table to which cmp is mapped to).
The query is "(= 1 1)"
When i try to call it
test t = testhome.findByNumber();
I am getting the below error.
javax.ejb.FinderException: Problem preparing or executing statement: 'SELECT
job
Num FROM job WHERE '(=1 1)'':
java.sql.SQLException: ORA-00920: invalid relational operator
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java, Compiled Code)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java, Compiled Code)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java, Compiled
Cod
e)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java,
Compiled Code)
at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.jav
a, Compiled Code)
at
oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java, Co
mpiled Code)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java, Compiled Code)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
edStatement.java, Compiled Code)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare
dStatement.java, Compiled Code)
at weblogic.jdbcbase.jts.Statement.executeQuery(Statement.java:58)
at
iprems.server.jobEJBPSWebLogic_CMP_RDBMS.findByNumber(jobEJBPSWebLogi
c_CMP_RDBMS.java:882)
at
iprems.server.jobEJBHomeImpl.findByNumber(jobEJBHomeImpl.java:116)
at
iprems.server.jobEJBHomeImpl_WLSkel.invoke(jobEJBHomeImpl_WLSkel.java
:105)
at
weblogic.rmi.extensions.BasicServerObjectAdapter.invoke(BasicServerOb
jectAdapter.java, Compiled Code)
at
weblogic.rmi.extensions.BasicRequestHandler.handleRequest(BasicReques
tHandler.java:69)
at
weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest
.java:15)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java, Compiled
Code)
at
weblogic.rmi.extensions.AbstractRequest.sendReceive(AbstractRequest.j
ava:76)
at
iprems.server.jobEJBHomeImpl_WLStub.findByNumber(jobEJBHomeImpl_WLStu
b.java:279)
Can some one tell me what's going on
Roopa
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
