wood burning stoves 2.0*
The moose likes Oracle/OAS and the fly likes not all variables bound Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "not all variables bound" Watch "not all variables bound" New topic
Author

not all variables bound

Pradeep
Ranch Hand

Joined: Sep 19, 2006
Posts: 49
i got error not all variables bound

i have to delete record


my query

public static final String GET_FUNDSHARE_DETAILS = "SELECT SHARE_ID,SHARE_TYPE,BASE_CRNCY_CD,ACTIVE, LAUNCH_DT,ISIN,COM_CD,WPKNR,SEDOL,VALOREN,MEX_ID,CUSIP,EURO_CLEAR FROM WK_SHARE WHERE FUND_ID=? and DELETED = '0'";

public static final String AD_SHARE = "insert into wk_share values(?,wk_share_seq.nextval,?,?,?,?,?,?,?,?,?,?,?,?,?)";

public static final String MODIFY_SHARE = "update wk_share set SHARE_TYPE=?,BASE_CRNCY_CD=?,ACTIVE=?,LAUNCH_DT=?,ISIN=?,COM_CD=?,WPKNR=?,SEDOL=?,VALOREN=?,MEX_ID=?,CUSIP=?,EURO_CLEAR=? WHERE SHARE_ID=?";

public static final String DELETE_SHARE = "update wk_share set deleted='1' where fund_id=? and share_id=? ";





my delete fun in dao class:-->


public boolean deleteFundShare(String fundId , String shareId )throws KMSSystemException{

logger.info("ShareToFundDAO :: deleteFundShare :: Inside");
ResultSet resultSet = null;
PreparedStatement preparedStmt = null;
boolean isUpdate = false;
try{
conn = ServiceLocator.getInstance().getConnection();

// Delete Shares
preparedStmt = new LoggableStatement(conn, DELETE_SHARE);
preparedStmt.setString(1, shareId);
SharesToFundDVO sharesToFundDVO = new SharesToFundDVO();
sharesToFundDVO.setDeleted(KMSConstants.ACTIVE_YES);
logger.debug("ShareToFundDAO :: deleteFundShare :: Query to delete share :: "+((LoggableStatement)preparedStmt).getQueryString());

preparedStmt.execute();

isUpdate = preparedStmt.execute();

conn.commit();
ServiceLocator.closeAll(conn,resultSet,preparedStmt);
}catch(SQLException sqlExec){
logger.debug("ShareToFundDAO :: deleteFundShare :: SQLException ::",sqlExec);
throw new KMSSystemException("error.sharestofund.dao.sqlException",sqlExec);
} catch(KMSSystemException kmsExec){
logger.debug("ShareToFundDAO :: deleteFundShare :: KMSSystemException ::",kmsExec);
throw new KMSSystemException("error.sharestofund.dao.kmsException",kmsExec);
}


logger.info("ShareToFundDAO :: deleteFundShare :: Exit");
return isUpdate;
}
Carol Enderlin
drifter
Ranch Hand

Joined: Oct 10, 2000
Posts: 1364
DELETE_SHARE takes two parameters and you are only setting one; share_id, but not fund_id. Separate issue, then it looks like you are going to execute it twice?

Originally posted by pradeep malekar:
i got error not all variables bound

public static final String DELETE_SHARE = "update wk_share set deleted='1' where fund_id=? and share_id=? ";

...
// Delete Shares
preparedStmt = new LoggableStatement(conn, DELETE_SHARE);
preparedStmt.setString(1, shareId);
preparedStmt.execute();

isUpdate = preparedStmt.execute();
...

Pradeep
Ranch Hand

Joined: Sep 19, 2006
Posts: 49
i have done respective changes that erro has gone

but record is not deleted


please see my action class for that


if(null != mode && mode.trim().equals(KMSConstants.MODE_DELETE)){


sharesToFundValidationHelper.deleteFundShare("1233","5" );
forward = mapping.findForward("search");
Carol Enderlin
drifter
Ranch Hand

Joined: Oct 10, 2000
Posts: 1364
What do you mean by record is not deleted?

Are you really trying to delete the record? From your sql it looks like you are only setting a deleted column (deleted flag) to a certain value. Do you mean the record is not getting updated by your sql now that the error is gone?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: not all variables bound
 
Similar Threads
want to delete the record fom db
Selecting option in second selectOneMenu not setting property value
Problem in getting the data from DB using servlets
want to delete the record
What is error in query