Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2009

    Talking Unanswered: java.sql.SQLException

    Hi All,
    Has anyone has any idea why I am getting this error?

    0000008b SystemOut O WARN [WebContainer : 68] (?:?) - Error in createUserLimitTempTable Temp
    table (mktsys.tmp_er_user_limit) already exists in session.
    java.sql.SQLException: Temp table (mktsys.tmp_er_user_limit) already exists in session.
    at com.informix.jdbc.IfxSqli.a( Code))
    at com.informix.jdbc.IfxSqli.E( Code))
    at com.informix.jdbc.IfxSqli.dispatchMsg( (Compiled Code))
    at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.j ava(Compiled Code))
    at com.informix.jdbc.IfxSqli.executeCommand(IfxSqli.j ava(Compiled Code))
    at com.informix.jdbc.IfxResultSet.b( (Compiled Code))
    at com.informix.jdbc.IfxStatement.c( (Compiled Code))

  2. #2
    Join Date
    Aug 2006
    The Netherlands
    Hi, I'm not really familiar with Java but according to the JDBC error message the object tries to create the same temp table for the second time in it's existence. My guess is the particular method is invoked once to many.


  3. #3
    Join Date
    Jun 2009
    I think, that is right, Thanks for your help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts