Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

java.sql.SQLException: ORA-00936: missing expression

568940Apr 30 2007 — edited Apr 30 2007
Hi I am write a sql query in the entity bean and have edit the session bean so as this method of querying all the line from the table trp_stime_reports. But i am getting this error.

javax.ejb.EJBException: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2006.8 (Build 060829)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-00936: missing expression
Error Code: 936
Call:SELECT TRP_ID, PROJECT_ID, TASK_ID, DATE, COMMENTS, WEEK_NUMBER, DURATION, EMPLOYEE_ID FROM TRP_STIME_REPORTS WHERE (EMPLOYEE_ID = ?)
bind => [1]
Query:ReportQuery(org.trp.persistence.TrpStimeReports); nested exception is:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2006.8 (Build 060829)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-00936: missing expression
Error Code: 936
Call:SELECT TRP_ID, PROJECT_ID, TASK_ID, DATE, COMMENTS, WEEK_NUMBER, DURATION, EMPLOYEE_ID FROM TRP_STIME_REPORTS WHERE (EMPLOYEE_ID = ?)
bind => [1]
Query:ReportQuery(org.trp.persistence.TrpStimeReports); nested exception is: oracle.oc4j.rmi.OracleRemoteException: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2006.8 (Build 060829)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-00936: missing expression
Error Code: 936
Call:SELECT TRP_ID, PROJECT_ID, TASK_ID, DATE, COMMENTS, WEEK_NUMBER, DURATION, EMPLOYEE_ID FROM TRP_STIME_REPORTS WHERE (EMPLOYEE_ID = ?)
bind => [1]
Query:ReportQuery(org.trp.persistence.TrpStimeReports); nested exception is:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2006.8 (Build 060829)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-00936: missing expression
Error Code: 936
oracle.oc4j.rmi.OracleRemoteException: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2006.8 (Build 060829)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-00936: missing expression
Error Code: 936
Call:SELECT TRP_ID, PROJECT_ID, TASK_ID, DATE, COMMENTS, WEEK_NUMBER, DURATION, EMPLOYEE_ID FROM TRP_STIME_REPORTS WHERE (EMPLOYEE_ID = ?)
bind => [1]
Query:ReportQuery(org.trp.persistence.TrpStimeReports)
at com.evermind.server.ejb.EJBUtils.getUserException(EJBUtils.java:346)
at com.evermind.server.ejb.interceptor.system.AbstractTxInterceptor.convertAndHandleMethodException(AbstractTxInterceptor.java:69)
at com.evermind.server.ejb.interceptor.system.TxRequiredInterceptor.invoke(TxRequiredInterceptor.java:52)
at com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.DMSInterceptor.invoke(DMSInterceptor.java:52)
at com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.InvocationContextPool.invoke(InvocationContextPool.java:55)
at com.evermind.server.ejb.StatelessSessionEJBObject.OC4J_invokeMethod(StatelessSessionEJBObject.java:87)
at SessionEJB_RemoteProxy_56ok9jj.getEmpTrp(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.evermind.server.rmi.RmiMethodCall.run(RmiMethodCall.java:53)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:595)

What is wrong with my sql query and please help me.

Regards
Lutchumaya
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 28 2007
Added on Apr 30 2007
1 comment
3,806 views