Error in CMP ORA-00928: missing SELECT keyword - Weblogic

This is a discussion on Error in CMP ORA-00928: missing SELECT keyword - Weblogic ; Hi, I am using WLS 8.1 and with CMP trying to insert records in oracle 8.1. But I am getting error as below. I hv not defined and finder method in the home interface except the default findByPrimaryKey(). javax.transaction.TransactionRolledbackException: EJB ...

+ Reply to Thread
Results 1 to 2 of 2

Thread: Error in CMP ORA-00928: missing SELECT keyword

  1. Error in CMP ORA-00928: missing SELECT keyword


    Hi,

    I am using WLS 8.1 and with CMP trying to insert records in oracle 8.1.

    But I am getting error as below.

    I hv not defined and finder method in the home interface except the default findByPrimaryKey().

    javax.transaction.TransactionRolledbackException: EJB Exception: : java.sql.SQLE
    xception: ORA-00928: missing SELECT keyword

    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:134)
    at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:2 89)
    at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
    at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol .java:1894)
    at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TT C7Protocol.java:109
    4)
    at oracle.jdbc.driver.OracleStatement.executeNonQuery (OracleStatement.ja
    va:2132)
    at oracle.jdbc.driver.OracleStatement.doExecuteOther( OracleStatement.jav
    a:2015)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStateme
    nt.java:2877)
    at oracle.jdbc.driver.OraclePreparedStatement.execute Update(OraclePrepar
    edStatement.java:608)
    at weblogic.jdbc.wrapper.PreparedStatement.executeUpd ate(PreparedStateme
    nt.java:95)
    at weblogic.ejb20.manager.BaseEntityManager.executeIn sertStmt(BaseEntity
    Manager.java:546)
    at weblogic.ejb20.manager.BaseEntityManager.executeDB Operations(BaseEnti
    tyManager.java:435)
    at weblogic.ejb20.internal.TxManager$TxListener.execu teDBOperations(TxMa
    nager.java:596)
    at weblogic.ejb20.internal.TxManager$TxListener.execu teDBOperationsDrive
    r(TxManager.java:571)
    at weblogic.ejb20.internal.TxManager$TxListener.befor eCompletion(TxManag
    er.java:731)
    at weblogic.transaction.internal.ServerSCInfo.callBef oreCompletions(Serv
    erSCInfo.java:1010)
    at weblogic.transaction.internal.ServerSCInfo.startPr ePrepareAndChain(Se
    rverSCInfo.java:115)
    at weblogic.transaction.internal.ServerTransactionImp l.localPrePrepareAn
    dChain(ServerTransactionImpl.java:1142)
    at weblogic.transaction.internal.ServerTransactionImp l.globalPrePrepare(
    ServerTransactionImpl.java:1868)
    at weblogic.transaction.internal.ServerTransactionImp l.internalCommit(Se
    rverTransactionImpl.java:250)
    at weblogic.transaction.internal.ServerTransactionImp l.commit(ServerTran
    sactionImpl.java:221)
    at weblogic.ejb20.internal.BaseEJBHome.postHomeInvoke (BaseEJBHome.java:3
    93)
    at weblogic.ejb20.internal.EntityEJBHome.create(Entit yEJBHome.java:268)
    at gateway.GatewayUpdate_f6dwyt_HomeImpl.create(Gatew ayUpdate_f6dwyt_Hom
    eImpl.java:84)
    at gateway.LogBean.msg_update(LogBean.java:137)
    at gateway.LogBean.onMessage(LogBean.java:57)
    at weblogic.ejb20.internal.MDListener.execute(MDListe ner.java:382)
    at weblogic.kernel.ExecuteThread.execute(ExecuteThrea d.java:197)
    at weblogic.kernel.ExecuteThread.run(ExecuteThread.ja va:170)

    In a nushell I am not using any finder methods in my client program.Still I am
    getting this error.

    Pl.advise.

    Regards,

    Ram


  2. Re: Error in CMP ORA-00928: missing SELECT keyword


    Hi,

    Please do not post the same question in multiple newsgroups.
    Please see my reply in the other group.

    thanks



+ Reply to Thread