|
I have some trouble with this query:
String qs =
"";
qs = qs +
" select adt.l_adt_id, ";
qs = qs + " adt.codice_adt, "; qs = qs + " adt.prezzo, "; qs = qs + " adt.prezzo_fattura, "; qs = qs + " adt.riferimento_fattura, "; qs = qs + " max(l_odt.t_consegna) "; qs = qs + " from "; qs = qs + " l_stato stato, "; qs = qs + " l_adt adt, "; qs = qs + " l_valutazione_odt valodt, "; qs = qs + " l_odt "; qs = qs + " where "; qs = qs + " l_odt.lsm_id = ? "; qs = qs + " and valodt.odt_id = "; qs = qs + " l_odt.l_odt_id "; qs = qs + " and adt.valutazione_adt_id = "; qs = qs + " valodt.valutazione_adt_id "; qs = qs + " and adt.trasportatore_id = ? "; qs = qs + " and adt.inviato = 1 "; qs = qs + " and stato.l_stato_id = adt.stato_corrente_id"; qs = qs + " and stato.nome = ? "; //qs = qs + and '2002-03-19 08:00:00.0' <= ( select max(odt1.t_consegna)"; qs = qs + " and ? <= ( select max(odt1.t_consegna)"; qs = qs + " from "; qs = qs + " l_valutazione_odt valodt1, "; qs = qs + " l_odt odt1"; qs = qs + " where "; qs = qs + " valodt1.odt_id = "; qs = qs + " odt1.l_odt_id "; qs = qs + " and adt.valutazione_adt_id = "; qs = qs + " valodt1.valutazione_adt_id ) "; qs = qs + " group by adt.l_adt_id, adt.codice_adt,"; qs = qs + " adt.prezzo, adt.prezzo_fattura, "; qs = qs + " adt.riferimento_fattura"; qs = qs + " order by 5"; PreparedStatement st = conn.prepareStatement(qs); st.setLong(1, 13 ); st.setLong(2, 31 ); st.setString(3, "fatturato" ); st.setTimestamp(4, new java.sql.Timestamp(new java.util.Date().getTime())); ResultSet rs = st.executeQuery(); while (rs.next()) { System.out.println("" + rs.getLong(1)); } odt1.t_consegna is a timestamp.
The application throws this
exception:
com.sap.dbtech.jdbc.exceptions.DatabaseException:
SAP DBTech SQL: [-7016] (at 527) Parameter spec not allowed in this
context
I tried to execute the query replacing a
constant instead of the fourth parameter and the query was executed
successfully.
Can you teel me if there
is an error in the jdbc driver or in my code?
Thank you and
goodbye. |
