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

    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(IfxSqli.java(Compiled Code))
    at com.informix.jdbc.IfxSqli.E(IfxSqli.java(Compiled Code))
    at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java (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(IfxResultSet.java (Compiled Code))
    at com.informix.jdbc.IfxStatement.c(IfxStatement.java (Compiled Code))

  2. #2
    Join Date
    Aug 2006
    Location
    The Netherlands
    Posts
    248
    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.

    Regards

  3. #3
    Join Date
    Jun 2009
    Posts
    2
    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
  •