Sunday, July 7, 2013

java.sql.SQLException: Missing IN or OUT parameter at index:: 1

1 comment:

  1. " org.apache.openjpa.persistence.PersistenceException:
    Missing IN or OUT parameter at index:: 1 {prepstmnt 1946973196 SELECT COUNT(ppappl.permit_appl_id) NUMBEROFRECORDS FROM
    IJSAFEPPP.pistol_permit_appl ppappl, IJSAFEPPP.applicant APPL WHERE ppappl.applicant_id = appl.applicant_id
    AND ppappl.application_type_code='R' AND UPPER(ppappl.APPL_PROCESS_STATUS_CODE) =:1} [code=17041, state=null].
    This is happening in WAS 7.0.0.29 integrated in RAD 9.0.
    The same query works fine in WAS 7.0.0.23.Does WAS 7.0.0.29 supports the JPA 1.1,
    please share your knowledge

    ReplyDelete