[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Problem with entity Beans
sachin1506
do-not-reply at jboss.com
Tue Mar 3 03:39:36 EST 2009
<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#4214408
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4214408
More information about the jboss-user
mailing list