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