Frank,
That F is a bit harsh. We are talking about an unusually complex finder
method which requires absolute concentration to formulate precisely. There
is no 'space' for errors, thats why the syntax has been specifically
designed to trip up most novice's and learn them the most important
programming fact: there are 2 types of developers, simiplifiers and
complicators. Unfortunately the complicators seem to out number the
simplifiers.
Life would be so much duller if we did not have to write (= 1 1). What if
somebody allowed you to do nothing?
William Louth
Inprise
www.inprise.com/appserver
-----Original Message-----
From: A mailing list for Enterprise JavaBeans development
[mailto:[EMAIL PROTECTED]]On Behalf Of Frank Sauer
Sent: Monday, September 18, 2000 6:05 PM
To: [EMAIL PROTECTED]
Subject: Re: Finder Exception in CMP -urgent
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".
===========================================================================
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".
