5 Replies Latest reply on May 28, 2004 1:39 PM by Holger Baxmann

    getting error message

    Nischal Sharma Newbie

      hi

      friends

      i am getting the this error message "Could not create entity:java.sql.SQLException: ORA-00972: identifier is too long"
      while creating the CMP through my client .

      the given below is what appear on jboss console:

      -------------------------------------------
      11:32:57,234 INFO [EARDeployer] Init J2EE application: file:/C:/jboss-3.2.3/server/default/deploy/ESP.ear
      11:32:58,093 INFO [EjbModule] Deploying CandidateDependent
      11:32:58,359 INFO [EjbModule] Deploying CandidateProfileMst
      11:32:58,359 INFO [EjbModule] Deploying CandidatePassport
      11:32:58,390 INFO [EjbModule] Deploying CandidateIdentity
      11:32:58,421 INFO [EjbModule] Deploying CandidateAdd
      11:32:58,437 INFO [EjbModule] Deploying CandidateEdu
      11:32:58,453 INFO [EjbModule] Deploying CandidatePedu
      11:32:58,468 INFO [EjbModule] Deploying CandidateEmployment
      11:32:58,484 INFO [EjbModule] Deploying CandidateEmpGap
      11:32:58,500 INFO [EjbModule] Deploying SessionEJBGenCandInfo
      11:32:58,546 INFO [EjbModule] Deploying SessionEJBIdentity
      11:32:58,546 INFO [EjbModule] Deploying SessionEJBFamilyDetails
      11:32:58,562 INFO [EjbModule] Deploying SessionEJBAddressDetails
      11:32:58,578 INFO [EjbModule] Deploying SessionEJBEduDetails
      11:32:58,578 INFO [EjbModule] Deploying SessionEJBProfQualDetails
      11:32:58,609 INFO [EjbModule] Deploying SessionEJBEmpHistoryDetails
      11:33:00,625 INFO [EntityInstancePool] Started jboss.j2ee:jndiName=CandidateDependentLocalHome,plugin=pool,service=EJB
      11:33:00,625 INFO [EntityContainer] Started jboss.j2ee:jndiName=CandidateDependentLocalHome,service=EJB
      11:33:00,734 INFO [EntityInstancePool] Started jboss.j2ee:jndiName=CandidateProfileMstLocalHome,plugin=pool,service=EJB
      11:33:00,750 INFO [EntityContainer] Started jboss.j2ee:jndiName=CandidateProfileMstLocalHome,service=EJB
      11:33:00,765 INFO [EntityInstancePool] Started jboss.j2ee:jndiName=CandidatePassportLocalHome,plugin=pool,service=EJB
      11:33:00,765 INFO [EntityContainer] Started jboss.j2ee:jndiName=CandidatePassportLocalHome,service=EJB
      11:33:00,781 INFO [EntityInstancePool] Started jboss.j2ee:jndiName=CandidateIdentityLocalHome,plugin=pool,service=EJB
      11:33:00,781 INFO [EntityContainer] Started jboss.j2ee:jndiName=CandidateIdentityLocalHome,service=EJB
      11:33:00,828 INFO [EntityInstancePool] Started jboss.j2ee:jndiName=CandidateAddLocalHome,plugin=pool,service=EJB
      11:33:00,828 INFO [EntityContainer] Started jboss.j2ee:jndiName=CandidateAddLocalHome,service=EJB
      11:33:00,859 INFO [EntityInstancePool] Started jboss.j2ee:jndiName=CandidateEduLocalHome,plugin=pool,service=EJB
      11:33:00,859 INFO [EntityContainer] Started jboss.j2ee:jndiName=CandidateEduLocalHome,service=EJB
      11:33:00,890 INFO [EntityInstancePool] Started jboss.j2ee:jndiName=CandidatePeduLocalHome,plugin=pool,service=EJB
      11:33:00,890 INFO [EntityContainer] Started jboss.j2ee:jndiName=CandidatePeduLocalHome,service=EJB
      11:33:01,312 INFO [EntityInstancePool] Started jboss.j2ee:jndiName=CandidateEmploymentLocalHome,plugin=pool,service=EJB
      11:33:01,312 INFO [EntityContainer] Started jboss.j2ee:jndiName=CandidateEmploymentLocalHome,service=EJB
      11:33:02,671 INFO [EntityInstancePool] Started jboss.j2ee:jndiName=CandidateEmpGapLocalHome,plugin=pool,service=EJB
      11:33:02,671 INFO [EntityContainer] Started jboss.j2ee:jndiName=CandidateEmpGapLocalHome,service=EJB
      11:33:02,750 INFO [StatelessSessionInstancePool] Started jboss.j2ee:jndiName=SessionEJBGenCandInfoHome,plugin=pool,service=EJB
      11:33:02,750 INFO [StatelessSessionContainer] Started jboss.j2ee:jndiName=SessionEJBGenCandInfoHome,service=EJB
      11:33:02,781 INFO [StatelessSessionInstancePool] Started jboss.j2ee:jndiName=SessionEJBIdentityHome,plugin=pool,service=EJB
      11:33:02,781 INFO [StatelessSessionContainer] Started jboss.j2ee:jndiName=SessionEJBIdentityHome,service=EJB
      11:33:02,796 INFO [StatelessSessionInstancePool] Started jboss.j2ee:jndiName=SessionEJBFamilyDetailsHome,plugin=pool,service=EJ
      11:33:02,812 INFO [StatelessSessionContainer] Started jboss.j2ee:jndiName=SessionEJBFamilyDetailsHome,service=EJB
      11:33:02,843 INFO [StatelessSessionInstancePool] Started jboss.j2ee:jndiName=SessionEJBAddressDetailsHome,plugin=pool,service=E
      11:33:02,843 INFO [StatelessSessionContainer] Started jboss.j2ee:jndiName=SessionEJBAddressDetailsHome,service=EJB
      11:33:02,875 INFO [StatelessSessionInstancePool] Started jboss.j2ee:jndiName=SessionEJBEduDetails,plugin=pool,service=EJB
      11:33:02,875 INFO [StatelessSessionContainer] Started jboss.j2ee:jndiName=SessionEJBEduDetails,service=EJB
      11:33:02,906 INFO [StatelessSessionInstancePool] Started jboss.j2ee:jndiName=SessionEJBProfQualDetails,plugin=pool,service=EJB
      11:33:02,906 INFO [StatelessSessionContainer] Started jboss.j2ee:jndiName=SessionEJBProfQualDetails,service=EJB
      11:33:02,953 INFO [StatelessSessionInstancePool] Started jboss.j2ee:jndiName=SessionEJBEmpHistoryDetails,plugin=pool,service=EJ
      11:33:02,953 INFO [StatelessSessionContainer] Started jboss.j2ee:jndiName=SessionEJBEmpHistoryDetails,service=EJB
      11:33:02,953 INFO [EjbModule] Started jboss.j2ee:module=ESP.jar,service=EjbModule
      11:33:02,953 INFO [EJBDeployer] Deployed: file:/C:/jboss-3.2.3/server/default/tmp/deploy/tmp46833ESP.ear-contents/ESP.jar
      11:33:03,093 INFO [EARDeployer] Started J2EE application: file:/C:/jboss-3.2.3/server/default/deploy/ESP.ear
      11:33:03,093 INFO [MainDeployer] Deployed package: file:/C:/jboss-3.2.3/server/default/deploy/ESP.ear
      11:33:03,109 INFO [URLDeploymentScanner] Started jboss.deployment:type=DeploymentScanner,flavor=URL
      11:33:03,187 INFO [MainDeployer] Deployed package: file:/C:/jboss-3.2.3/server/default/conf/jboss-service.xml
      11:33:03,187 INFO [Server] JBoss (MX MicroKernel) [3.2.3 (build: CVSTag=JBoss_3_2_3 date=200311301445)] Started in 26s:312ms

      11:35:11,500 ERROR [CandidateEdu] Could not create entity
      java.sql.SQLException: ORA-00972: identifier is too long

      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
      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:1451)
      at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:862)
      at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1846)
      at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1771)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2361)
      at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:422)
      at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:324)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.executeInsert(JDBCAbstractCreateCommand.java:326)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.performInsert(JDBCAbstractCreateCommand.java:287)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.execute(JDBCAbstractCreateCommand.java:138)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:554)
      at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:208)
      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:269)
      at org.jboss.ejb.EntityContainer.createLocalHome(EntityContainer.java:581)
      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:1043)
      at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
      at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:197)
      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:214)
      at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
      at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:89)
      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:297)
      at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:98)
      at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:92)
      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:483)
      at org.jboss.ejb.Container.invoke(Container.java:720)
      at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:293)
      at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110)
      at $Proxy52.create(Unknown Source)
      at com.hill_assoc.esp.Stateless.SessionEJBEduDetailsBean.saveIntoDb(SessionEJBEduDetailsBean.java:294)
      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.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
      at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
      at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
      at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:267)
      at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
      at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118)
      at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
      at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
      at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
      at org.jboss.ejb.Container.invoke(Container.java:700)
      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.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
      at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:367)
      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 sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
      at sun.rmi.transport.Transport$1.run(Transport.java:148)
      at java.security.AccessController.doPrivileged(Native Method)
      at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
      at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
      at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
      at java.lang.Thread.run(Thread.java:536)
      11:35:11,500 INFO [STDOUT] javax.ejb.CreateException: Could not create entity:java.sql.SQLException: ORA-00972: identifier is t
      11:35:11,500 ERROR [STDERR] javax.ejb.CreateException: Could not create entity:java.sql.SQLException: ORA-00972: identifier is t
      11:35:11,500 ERROR [STDERR] at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.performInsert(JDBCAbstractCreateComm
      11:35:11,500 ERROR [STDERR] at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.execute(JDBCAbstractCreateCommand.ja
      11:35:11,515 ERROR [STDERR] at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:554)
      11:35:11,515 ERROR [STDERR] at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:208)
      11:35:11,515 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectio
      11:35:11,515 ERROR [STDERR] at org.jboss.ejb.EntityContainer.createLocalHome(EntityContainer.java:581)
      11:35:11,515 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      11:35:11,515 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      11:35:11,515 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      11:35:11,515 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:324)
      11:35:11,531 ERROR [STDERR] at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1043)
      11:35:11,531 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
      11:35:11,546 ERROR [STDERR] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterc
      11:35:11,546 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionI
      11:35:11,546 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
      11:35:11,546 ERROR [STDERR] at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:89)
      11:35:11,546 ERROR [STDERR] at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61)
      11:35:11,546 ERROR [STDERR] at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28)
      11:35:11,546 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:88)
      11:35:11,546 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:297)
      11:35:11,546 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:98)
      11:35:11,546 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:92)
      11:35:11,546 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
      11:35:11,546 ERROR [STDERR] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.
      11:35:11,546 ERROR [STDERR] at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:483)
      11:35:11,546 ERROR [STDERR] at org.jboss.ejb.Container.invoke(Container.java:720)
      11:35:11,546 ERROR [STDERR] at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:293)
      11:35:11,546 ERROR [STDERR] at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110)
      11:35:11,546 ERROR [STDERR] at $Proxy52.create(Unknown Source)
      11:35:11,546 ERROR [STDERR] at com.hill_assoc.esp.Stateless.SessionEJBEduDetailsBean.saveIntoDb(SessionEJBEduDetailsBean.jav
      11:35:11,546 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      11:35:11,546 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      11:35:11,546 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      11:35:11,546 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:324)
      11:35:11,546 ERROR [STDERR] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer
      11:35:11,546 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInter
      11:35:11,546 ERROR [STDERR] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInte
      11:35:11,546 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
      11:35:11,546 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:267)
      11:35:11,546 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
      11:35:11,546 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118)
      11:35:11,546 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
      11:35:11,546 ERROR [STDERR] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java
      11:35:11,546 ERROR [STDERR] at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
      11:35:11,546 ERROR [STDERR] at org.jboss.ejb.Container.invoke(Container.java:700)
      11:35:11,562 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      11:35:11,562 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      11:35:11,562 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      11:35:11,562 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:324)
      11:35:11,578 ERROR [STDERR] at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      11:35:11,578 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
      11:35:11,578 ERROR [STDERR] at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:367)
      11:35:11,578 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      11:35:11,578 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      11:35:11,578 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      11:35:11,578 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:324)
      11:35:11,578 ERROR [STDERR] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
      11:35:11,578 ERROR [STDERR] at sun.rmi.transport.Transport$1.run(Transport.java:148)
      11:35:11,578 ERROR [STDERR] at java.security.AccessController.doPrivileged(Native Method)
      11:35:11,578 ERROR [STDERR] at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
      11:35:11,578 ERROR [STDERR] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
      11:35:11,578 ERROR [STDERR] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
      11:35:11,578 ERROR [STDERR] at java.lang.Thread.run(Thread.java:536)

      ------------------------------------------------


      if any one face this problem in past then please help me.

      and also how we can increment the primary key value in cmp bean
      when we use oracle 9i as database




      with regards
      nischal


        • 1. Re: getting error message
          Alexey Loubyansky Master

          ORA-00972 identifier is too long

          Cause: The name of a schema object exceeds 30 characters. Schema objects are tables, clusters, views, indexes, synonyms, tablespaces, and usernames.

          Action: Shorten the name to 30 characters or less.

          http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96525/e900.htm#1000610

          • 2. Re: getting error message
            Nischal Sharma Newbie

            Thanks for ur reply

            i am not getting one point that is -> i have already created the table in schema
            .so this error would have appeared while creating the table in DB

            and why i am getting this error when i am running client that call the
            CMP create function


            with regards
            nischal

            • 3. Re: getting error message
              Nischal Sharma Newbie

              hi

              i have jsut tested that i can insert the rerord in table using the SQL
              but why i am not able to craete pK using cmp bean

              if any one knows then please help me

              • 4. Re: getting error message
                Erik Sliman Apprentice

                You can turn on CMP logging to see what it is sending to the database by adding this to your server/default/conf/log4j.xml:

                 <!-- View CMP queries -->
                 <category name="org.jboss.ejb.plugins.cmp">
                 <priority value="DEBUG"/>
                 </category>
                

                As for how to implement sequence numbers in Oracle, I'm not sure how to set it up to get CMP to automatically do it. Here's a variation of the method I use that uses Oracle sequence objects:

                - Create sequence controller session bean.

                - Implement getNextVal and other sequence related methods.

                - Have it, based on the parameter you pass, do a JDBC call to select the next value from a sequence object.

                - Have your onCreate CMP methods call the sequence controller and set the primary key value.

                - Develop the sequence controller to use "caching" for optimal performance. Create or alter your sequence objects to jump a specified interval. We had ours increment the sequence object by 100. This had the effect of "caching" 100 sequence values. Thus, the sequence controller would still return an increment of 1 to your CMP bean, but would only call the database to obtain the "nextval" from the sequence object every 100th time. This increased performance dramatically, particularly during large quantities of inserts, which was typical of our system.


                • 5. Re: getting error message
                  Holger Baxmann Novice

                  Do you check if you have double quotes or single quotes surrounding your values?

                  Double quotes may throw ORA-00972.

                  Google tells for example:

                  "The relevance of ' and " I suppose is this. By default Oracle is not case
                  sensitive about the names of database objects, but it is if when you create
                  them you enclose the name in double quotes. For instance if you simply say
                  'create table euan', then you will be able to access it with 'select * from
                  euan', 'select * from EUAN', 'select * from Euan' etc. But if you say
                  'create table "euan"', then you will forever have to say 'select * from
                  "euan"'. "

                  at http://www.phpbuilder.com/lists/php-general/2001032/0912.php

                  bax