Look at your WHERE clause, then RTFM.
Frank
> -----Original Message-----
> From: A mailing list for Enterprise JavaBeans development
> [mailto:[EMAIL PROTECTED]]On Behalf Of Roopa Kotha
> Sent: Monday, September 18, 2000 6:26 PM
> To: [EMAIL PROTECTED]
> Subject: Finder Exception in CMP -urgent
>
>
> 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".
>
===========================================================================
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".
