Re: Another Problem with DB2 v.5 for MVS/OS-390

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Thu Sep 23 2004 - 17:53:39 EDT

  • Next message: Mike Elliott: "Even more log4j -- 'how' not 'what'"

    I think it is a problem with your other parameters, not the date one -
    "(? = ?)". Looking up description for SQLSTATE=42609 - "All operands of
    an operator or predicate are parameter markers.", so it expects
    something like "abc = ?" instead of just "? = ?".

    And a message translated from Portugese by Google, confirms that too
    (in a weird language of a machine translator :-)) - "A chain of to be
    prepared instruction contains marking of parameters as operandos of the
    same operator."

    On Sep 23, 2004, at 5:45 PM, André Luiz do Nascimento Sousa wrote:

    > INFO RequestProcessor: Processing a 'POST' for path '/TestarCayenne'
    > INFO QueryLogger: --- will run 1 query.
    > INFO QueryLogger: SELECT t0.COD_BOL_SIMUL, t0.DES_NUMERO_SORT,
    > t0.DTH_EXTRACAO, t0.NOM_LOCAL_EXTRACAO, t0.NUM_EXTRACAO,
    > t0.NUM_INICIAL_DOC, t0.SIGLA_UF, t0.IDE_REGRA_EXTRACAO FROM
    > FDRCAP.FC_EXTRACAO t0 WHERE (? = ?) AND (t0.DTH_EXTRACAO >= ?) [bind:
    > 1, 1, '2004-05-01 00:00:00.0']
    > INFO QueryLogger: *** error.
    > COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2] SQL0417N Uma
    > cadeia de instrução a ser preparada contém marcadores de parâmetros
    > como operandos do mesmo operador. SQLSTATE=42609
    >
    > at java.lang.Throwable.<init>(Throwable.java:59)
    > at java.lang.Throwable.<init>(Throwable.java:73)
    > at java.sql.SQLException.<init>(SQLException.java:52)
    > at COM.ibm.db2.jdbc.DB2Exception.<init>(DB2Exception.java:72)



    This archive was generated by hypermail 2.0.0 : Thu Sep 23 2004 - 17:53:42 EDT