Not All Varialbes Bound Error

[JiaPei Jen]

My code worked OK until I changed this statement:

    String query = "SELECT Value FROM ContactEntry WHERE ContactTypeID = 6";

to

    String query = "SELECT Value FROM ContactEntry WHERE ContactTypeID = ?";

I got the runtime error:

Caused by: java.sql.SQLException: ORA-01008: not all variables bound

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1986)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:880)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2516)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2850)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:609)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:537)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at org.dhsinfo.message.dao.OracleRecipientDAO.findRecipients(OracleRecipientDAO.java:35)
... 32 more

My OracleRecipientDAO.java looks like:

public class OracleRecipientDAO implements RecipientDAO
{
   // Here the return type is Collection
   public Collection findRecipients( int contactTypeID ) throws RecipientDAOSysException
   {
      Connection conn = null;
      PreparedStatement stmt = null;
      ResultSet rs = null;
      RecipientBean recipientBean;
      Collection recipients = new ArrayList();
      String query = "SELECT Value FROM ContactEntry WHERE ContactTypeID = ?";
 
      try
      {
         conn = DBConnection.getDBConnection();
         stmt = conn.prepareStatement( query );
         rs = stmt.executeQuery();
 
 while( rs.next() )
         {
    recipientBean = new RecipientBean();
            recipientBean.setEmailAddress( rs.getString( "Value" ) );
    recipients.add( recipientBean );
         }
      }
      catch (NamingException ne)
      {
         ne.printStackTrace();
         throw new RecipientDAOSysException("NamingException: " + ne.getMessage());
      }
      catch (SQLException se)
      {
         se.printStackTrace( System.err );
         throw new RecipientDAOSysException("SQLException: " + se.getMessage(), se );
      }
      finally
      {
          .....
      }
   }
}

[JiaPei Jen]

never mind. I have found the mistake.