Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> New error message

New error message

From: swati <swatihdy_at_usa.net>
Date: 6 Aug 2001 09:52:47 -0700
Message-ID: <d6ea977d.0108060852.481bc55@posting.google.com>

I get a exception thrown if i try to modify a screen through the entity beans.
and weblogic

Everytime i modify a screen i get an error that says

Thu Aug 02 17:09:21 CDT 2001:<I> <TX> Transaction rolled back due to beforeCompletion exception
java.sql.SQLException: ORA-01401: inserted value too large for column

        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
        at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java, Compiled
Code)
        at oracle.jdbc.ttc7.Oall7.receive(Oall7.java, Compiled Code)
        at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java,
Compiled Code)
        at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java,
Compiled Code)
        at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java,
Compiled Code)
        at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java,
Compiled Code)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java,
Compiled Code)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java,
Compiled Code)
        at weblogic.jdbcbase.jts.Statement.executeUpdate(Statement.java,
Compiled Code)
        at checktrac.entity.common.address.AddressEJBPSWebLogic_CMP_RDBMS.update(AddressEJBPSWebLogic_CMP_RDBMS.java:460
        at checktrac.entity.common.address.AddressEJBPSWebLogic_CMP_RDBMS.store(AddressEJBPSWebLogic_CMP_RDBMS.java:386)
        at weblogic.ejb.internal.EntityEJBContext.store(EntityEJBContext.java,
Compiled Code)
        at weblogic.ejb.internal.EntityEJBContext.beforeCompletion(EntityEJBContext.java,
Compiled Code)
        at weblogic.jts.internal.CoordinatorImpl.notifyBefore(CoordinatorImpl.java,
Compiled Code)
        at weblogic.jts.internal.CoordinatorImpl.prepare(CoordinatorImpl.java,
Compiled Code)
        at weblogic.jts.internal.CoordinatorImpl.commit(CoordinatorImpl.java,
Compiled Code)
        at weblogic.jts.internal.TxContext.commit(TxContext.java,
Compiled Code)
        at weblogic.ejb.internal.StatelessEJBObject.postInvokeOurTx(StatelessEJBObject.java:88)
        at weblogic.ejb.internal.BaseEJBObject.postInvoke(BaseEJBObject.java,
Compiled Code)
        at checktrac.session.admin1.AdminSessionEJBEOImpl.modifyStore(AdminSessionEJBEOImpl.java:776)
        at checktrac.session.admin1.AdminSessionEJBEOImpl_ServiceStub.modifyStore(AdminSessionEJBEOImpl_ServiceStub.java
        at checktrac.servlets.ModStoreServlet.doGet(ModStoreServlet.java:76)
        at checktrac.servlets.ModStoreServlet.doPost(ModStoreServlet.java:29)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:772)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
        at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java,
Compiled Code)
        at weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImpl.java:907)
        at weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImpl.java:851)
        at weblogic.servlet.internal.ServletContextManager.invokeServlet(ServletContextManager.java:252)
        at weblogic.socket.MuxableSocketHTTP.invokeServlet(MuxableSocketHTTP.java:364)
        at weblogic.socket.MuxableSocketHTTP.execute(MuxableSocketHTTP.java:252)
        at weblogic.kernel.ExecuteThread.run(ExecuteThread.java,
Compiled Code)
--------------- nested within: ------------------
weblogic.utils.NestedRuntimeException: Error writing 'Context hashcode: '-630306647', primaryKey: 'ADD1', flags: '', nee 782359'' to persistent store - with nested exception:
[java.sql.SQLException: ORA-01401: inserted value too large for column
]

        at weblogic.ejb.internal.EntityEJBContext.beforeCompletion(EntityEJBContext.java, Compiled Code)

        at weblogic.jts.internal.CoordinatorImpl.notifyBefore(CoordinatorImpl.java, Compiled Code)

        at weblogic.jts.internal.CoordinatorImpl.prepare(CoordinatorImpl.java, Compiled Code)

        at weblogic.jts.internal.CoordinatorImpl.commit(CoordinatorImpl.java, Compiled Code)

        at weblogic.jts.internal.TxContext.commit(TxContext.java, Compiled Code)

        at weblogic.ejb.internal.StatelessEJBObject.postInvokeOurTx(StatelessEJBObject.java:88)
        at weblogic.ejb.internal.BaseEJBObject.postInvoke(BaseEJBObject.java,
Compiled Code)
        at checktrac.session.admin1.AdminSessionEJBEOImpl.modifyStore(AdminSessionEJBEOImpl.java:776)
        at checktrac.session.admin1.AdminSessionEJBEOImpl_ServiceStub.modifyStore(AdminSessionEJBEOImpl_ServiceStub.java
        at checktrac.servlets.ModStoreServlet.doGet(ModStoreServlet.java:76)
        at checktrac.servlets.ModStoreServlet.doPost(ModStoreServlet.java:29)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:772)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
        at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java,
Compiled Code)
        at weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImpl.java:907)
        at weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImpl.java:851)
        at weblogic.servlet.internal.ServletContextManager.invokeServlet(ServletContextManager.java:252)
        at weblogic.socket.MuxableSocketHTTP.invokeServlet(MuxableSocketHTTP.java:364)
        at weblogic.socket.MuxableSocketHTTP.execute(MuxableSocketHTTP.java:252)
        at weblogic.kernel.ExecuteThread.run(ExecuteThread.java,
Compiled Code)
weblogic.utils.NestedRuntimeException: Error writing 'Context hashcode: '-630306647', primaryKey: 'ADD1', flags: '', need 782359'' to persistent store - with nested exception:
[java.sql.SQLException: ORA-01401: inserted value too large for column
]

        at weblogic.ejb.internal.EntityEJBContext.beforeCompletion(EntityEJBContext.java, Compiled Code)

        at weblogic.jts.internal.CoordinatorImpl.notifyBefore(CoordinatorImpl.java, Compiled Code)

        at weblogic.jts.internal.CoordinatorImpl.prepare(CoordinatorImpl.java, Compiled Code)

        at weblogic.jts.internal.CoordinatorImpl.commit(CoordinatorImpl.java, Compiled Code)

        at weblogic.jts.internal.TxContext.commit(TxContext.java, Compiled Code)

        at weblogic.ejb.internal.StatelessEJBObject.postInvokeOurTx(StatelessEJBObject.java:88)
        at weblogic.ejb.internal.BaseEJBObject.postInvoke(BaseEJBObject.java,
Compiled Code)
        at checktrac.session.admin1.AdminSessionEJBEOImpl.modifyStore(AdminSessionEJBEOImpl.java:776)
        at checktrac.session.admin1.AdminSessionEJBEOImpl_ServiceStub.modifyStore(AdminSessionEJBEOImpl_ServiceStub.java,
        at checktrac.servlets.ModStoreServlet.doGet(ModStoreServlet.java:76)
        at checktrac.servlets.ModStoreServlet.doPost(ModStoreServlet.java:29)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:772)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
        at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java,
Compiled Code)
        at weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImpl.java:907)
        at weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImpl.java:851)
        at weblogic.servlet.internal.ServletContextManager.invokeServlet(ServletContextManager.java:252)
        at weblogic.socket.MuxableSocketHTTP.invokeServlet(MuxableSocketHTTP.java:364)
        at weblogic.socket.MuxableSocketHTTP.execute(MuxableSocketHTTP.java:252)
        at weblogic.kernel.ExecuteThread.run(ExecuteThread.java,
Compiled Code)
        at weblogic.jts.internal.CoordinatorImpl.throwRollbackException(CoordinatorImpl.java:726)
        at weblogic.jts.internal.CoordinatorImpl.commit(CoordinatorImpl.java,
Compiled Code)
        at weblogic.jts.internal.TxContext.commit(TxContext.java,
Compiled Code)
        at weblogic.ejb.internal.StatelessEJBObject.postInvokeOurTx(StatelessEJBObject.java:88)
        at weblogic.ejb.internal.BaseEJBObject.postInvoke(BaseEJBObject.java,
Compiled Code)
        at checktrac.session.admin1.AdminSessionEJBEOImpl.modifyStore(AdminSessionEJBEOImpl.java:776)
        at checktrac.session.admin1.AdminSessionEJBEOImpl_ServiceStub.modifyStore(AdminSessionEJBEOImpl_ServiceStub.java,
        at checktrac.servlets.ModStoreServlet.doGet(ModStoreServlet.java:76)
        at checktrac.servlets.ModStoreServlet.doPost(ModStoreServlet.java:29)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:772)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
        at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java,
Compiled Code)
        at weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImpl.java:907)
        at weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImpl.java:851)
        at weblogic.servlet.internal.ServletContextManager.invokeServlet(ServletContextManager.java:252)
        at weblogic.socket.MuxableSocketHTTP.invokeServlet(MuxableSocketHTTP.java:364)
        at weblogic.socket.MuxableSocketHTTP.execute(MuxableSocketHTTP.java:252)
        at weblogic.kernel.ExecuteThread.run(ExecuteThread.java,
Compiled Code)

and the code breaks then

can anyone help me and guide me Received on Mon Aug 06 2001 - 11:52:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US