Unable to insert row into table - Websphere

This is a discussion on Unable to insert row into table - Websphere ; Hello, I'm using WAS 6.1, EJB 3.0, JPA and a DB2 database. I can access the database only for read actions. Everytime i call persist() method to write a row into the table i get the following error message: Trace: ...

+ Reply to Thread
Results 1 to 2 of 2

Thread: Unable to insert row into table

  1. Unable to insert row into table

    Hello,

    I'm using WAS 6.1, EJB 3.0, JPA and a DB2 database. I can access the database only for read actions. Everytime i call persist() method to write a row into the table i get the following error message:


    Trace: 2009/02/25 12:46:15.133 01 t=8C3E88 c=UNK key=P8 (13007002)
    ThreadId: 00000022
    FunctionName: com.ibm.ws.Transaction.JTA.RegisteredSyncs
    SourceId: com.ibm.ws.Transaction.JTA.RegisteredSyncs
    Category: SEVERE
    ExtendedMessage: ***BUFFER OVERFLOW***
    Trace: 2009/02/25 12:46:15.172 01 t=8C3E88 c=UNK key=P8 (13007002)
    ThreadId: 00000022
    FunctionName: com.ibm.ws.webcontainer.servlet.ServletWrapper
    SourceId: com.ibm.ws.webcontainer.servlet.ServletWrapper
    Category: SEVERE
    ExtendedMessage: BBOO0220E: SRVE0068E: Uncaught exception thrown in one of the service methods of the servlet: SstController. Exce
    ption thrown : javax.ejb.EJBTransactionRolledbackException:
    at com.ibm.ejs.csi.TranStrategy.commit(TranStrategy.j ava:795)
    at com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrate gy.java:206)
    at com.ibm.ejs.csi.TransactionControlImpl.postInvoke( TransactionControlImpl.java:581)
    at com.ibm.ejs.container.EJSContainer.postInvoke(EJSC ontainer.java:4311)
    at interfaces.EJSRemote0SLSstDbManagerImpl_9a8f969a.c reateServer(EJSRemote0SLSstDbManagerImpl_9a8f969a. java)
    at interfaces._SstDbManager_Stub.createServer(_SstDbM anager_Stub.java)
    at com.ibm.db2pm.sst.SstController.doGet(SstControlle r.java:436)
    at com.ibm.db2pm.sst.SstController.doPost(SstControll er.java:654)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:763)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:856)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.ser vice(ServletWrapper.java:1076)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.han dleRequest(ServletWrapper.java:550)
    at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.h andleRequest(ServletWrapper.java:486)
    at com.ibm.ws.webcontainer.servlet.CacheServletWrappe r.handleRequest(CacheServletWrapper.java:90)
    at com.ibm.ws.webcontainer.WebContainer.handleRequest (WebContainer.java:744)
    at com.ibm.ws.wswebcontainer.WebContainer.handleReque st(WebContainer.java:1455)
    at com.ibm.ws.webcontainer.channel.WCChannelLink.read y(WCChannelLink.java:115)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLi nk.handleDiscrimination(HttpInboundLink.java:458)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLi nk.handleNewInformation(HttpInboundLink.java:387)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLi nk.ready(HttpInboundLink.java:267)
    at com.ibm.ws390.channel.xmem.XMemConnLink.ready(XMem ConnLink.java:762)
    at com.ibm.ws390.xmem.XMemSRBridgeImpl.httpinvoke(XMe mSRBridgeImpl.java:230)
    at com.ibm.ws390.xmem.XMemSRCppUtilities.httpinvoke(X MemSRCppUtilities.java:74)
    at com.ibm.ws390.orb.ServerRegionBridge.httpinvoke(Un known Source)



    Interesting is the Buffer Overflow. The same happens before i inserting to
    ibm-web-ext.xmi which means to use JVM 1.5 either 1.3 which is the default.
    The reason therefore lay in the fact that java collections were used in a JSP.
    Other tutorials said you have to apply a Non-JTA-Data-Source. I've tried but i couldn't get it working. Has anybody any ideas?

    Regards, Joachim

  2. Re: Unable to insert row into table

    Something else:

    I get some messages in the log where i don't know wherefrom they are.

    The first is this one:

    Trace: 2009/02/26 15:36:28.019 01 t=8C1828 c=UNK key=P8 (0000000A)
    Description: Log Java Message
    Message: BBOO0220E: UTLS0002E: The shared library DB2Driver Driver Jars contains a classpath entry which does not resolve to a val
    id jar file, the library jar file is expected to be found at C:\Program Files\IBM\SDP70Shared\plugins\com.ibm.datatools.db 2_2.0.0.v2
    00808071952\driver\db2jcc_license_cisuz.jar. com.ibm.ws.runtime.ModuleManifestParser com.ibm.ws.runtime.ModuleManifestParser


    Such an entry i had seen when i configured a DB2Driver within my IDE but i had removed it.



    The second:

    Trace: 2009/02/26 15:36:38.573 01 t=8BBCF0 c=UNK key=P8 (0000000A)
    Description: Log Java Message
    Message: BBOO0221W: CWNEN0025W: The enterprise bean is being bound to an empty string in the global Java Naming and Directory Interface (JNDI) namespace.

    This is from the ejb reference in my web.xml. When i remove it i get a JNDI error. This is the entry:




    ejb/SstDbManagerImpl
    Session

    interfaces.SstDbManager
    SstDbManagerImpl




    The third:

    Trace: 2009/02/26 15:37:10.356 01 t=8C2580 c=UNK key=P8 (13007002)
    ThreadId: 00000028
    FunctionName: com.ibm.ws.webcontainer.srt.SRTServletResponse
    SourceId: com.ibm.ws.webcontainer.srt.SRTServletResponse
    Category: WARNING
    ExtendedMessage: BBOO0221W: WARNING: Cannot set status. Response already committed.
    Trace: 2009/02/26 15:37:10.356 01 t=8C2580 c=UNK key=P8 (0000000A)
    Description: Log Java Message
    Message: BBOO0221W: WARNING: Cannot set status. Response already committed.
    Trace: 2009/02/26 15:37:10.358 01 t=8C2580 c=UNK key=P8 (13007002)
    ThreadId: 00000028
    FunctionName: com.ibm.ws.webcontainer.srt.SRTServletResponse
    SourceId: com.ibm.ws.webcontainer.srt.SRTServletResponse
    Category: WARNING
    ExtendedMessage: BBOO0221W: WARNING: Cannot set header. Response already committed.
    Trace: 2009/02/26 15:37:10.358 01 t=8C2580 c=UNK key=P8 (0000000A)
    Description: Log Java Message
    Message: BBOO0221W: WARNING: Cannot set header. Response already committed.


    These messages i get at the end of the after the other exceptions.

+ Reply to Thread