<entity> | <description>Entity Bean ( CMP )</description> | | <display-name>LoginDetails</display-name> | | <ejb-name>LoginDetails</ejb-name> | | <home>cdot.oss.clh.invoice.ioinvoice.ejb.entity.LoginDetailsHome</home> | | <remote>cdot.oss.clh.invoice.ioinvoice.ejb.entity.LoginDetails</remote> | <local-home>cdot.oss.clh.invoice.ioinvoice.ejb.entity.LoginDetailsLocalHome</local-home> | <local>cdot.oss.clh.invoice.ioinvoice.ejb.entity.LoginDetailsLocal</local> | <ejb-class>cdot.oss.clh.invoice.ioinvoice.ejb.entity.LoginDetailsBean</ejb-class> | | <persistence-type>Container</persistence-type> | | <prim-key-class>java.lang.Long</prim-key-class> | | <reentrant>False</reentrant> | | <cmp-version>2.x</cmp-version> | | <abstract-schema-name>logindetails</abstract-schema-name> | | <cmp-field> | | <field-name>id</field-name> | | </cmp-field> | | <cmp-field> | | <field-name>password</field-name> | | </cmp-field> | | <cmp-field> | | <field-name>name</field-name> | | </cmp-field> | | | <query> | | <query-method> | | <method-name>findAll</method-name> | | <method-params/> | | </query-method> | | <ejb-ql>select object(o) from logindetails o</ejb-ql> | | </query> | | <query> | | <query-method> | | <method-name>findPasswordById</method-name> | <method-params> | <method-param>java.lang.Long</method-param> | </method-params> | </query-method> | | <ejb-ql>select object(o) from logindetails o where o.id = ?1 </ejb-ql> | | </query> | | </entity> This is my discriptor for bean "LoginDetails" but when ever i m going to cerate a row using create function it prints following exception can any one help me plzz Error checking if entity exists | java.sql.SQLException: ORA-00921: unexpected end of SQL command | | at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) | at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) | at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543) | at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405) | at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:643) | at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1674) | at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1870) | at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363) | at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:314) | at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:314) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCInsertPKCreateCommand.beforeInsert(JDBCInsertPKCreateCommand.java:79) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.execute(JDBCAbstractCreateCommand.java:136) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:572) | at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:211) | at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:270) | at org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:730) | 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:324) | at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1070) | at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88) | at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:204) | at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:215) | at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88) | at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:90) | at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61) | at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28) | at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:88) | at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:341) | at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:128) | at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:85) | at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120) | at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93) | at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:478) | at org.jboss.ejb.Container.invoke(Container.java:729) | 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:324) | at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60) | at org.jboss.mx.server.Invocation.dispatch(Invocation.java:62) | at org.jboss.mx.server.Invocation.dispatch(Invocation.java:54) | at org.jboss.mx.server.Invocation.invoke(Invocation.java:82) | at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:197) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473) | at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:97) | at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90) | at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46) | at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:55) | at org.jboss.proxy.ejb.HomeInterceptor.invoke(HomeInterceptor.java:173) | at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85) | at $Proxy1882.create(Unknown Source) | at org.apache.jsp.General.Succ_jsp._jspService(Succ_jsp.java:97) | at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) | at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) | at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324) | at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) | at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) | at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) | at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75) | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) | at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) | at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) | at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) | at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) | at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) | at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) | at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66) | at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) | at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:158) | at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) | at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462) | at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) | at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) | at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) | at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) | at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) | at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) | at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:103) | at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) | at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:444) | at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) | at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) | at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) | at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) | at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) | at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) | at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) | at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) | at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) | at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) | at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) | at java.lang.Thread.run(Thread.java:534) | I am using jboss 3.2.6 I dont know what this problem is .?? As i m writing first Bean by myself but its not working View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4214408#... Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...