Author: shankar
Date: Mon May 4 14:54:57 2009
New Revision: 771324
URL: http://svn.apache.org/viewvc?rev=771324&view=rev
Log:
Fixing error in getHolding method.
Modified:
incubator/stonehenge/trunk/stocktrader/wsas/common/src/org/apache/stonehenge/stocktrader/mssql/MSSQLCustomerDAO.java
Modified:
incubator/stonehenge/trunk/stocktrader/wsas/common/src/org/apache/stonehenge/stocktrader/mssql/MSSQLCustomerDAO.java
URL:
http://svn.apache.org/viewvc/incubator/stonehenge/trunk/stocktrader/wsas/common/src/org/apache/stonehenge/stocktrader/mssql/MSSQLCustomerDAO.java?rev=771324&r1=771323&r2=771324&view=diff
==============================================================================
---
incubator/stonehenge/trunk/stocktrader/wsas/common/src/org/apache/stonehenge/stocktrader/mssql/MSSQLCustomerDAO.java
(original)
+++
incubator/stonehenge/trunk/stocktrader/wsas/common/src/org/apache/stonehenge/stocktrader/mssql/MSSQLCustomerDAO.java
Mon May 4 14:54:57 2009
@@ -112,19 +112,19 @@
PreparedStatement selectHoldingNoLockStat = null;
try {
selectHoldingNoLockStat =
sqlConnection.prepareStatement(SQL_SELECT_HOLDING_NOLOCK);
- selectHoldingNoLockStat.setInt(0, holdingID);
- selectHoldingNoLockStat.setString(1, userId);
+ selectHoldingNoLockStat.setInt(1, holdingID);
+ selectHoldingNoLockStat.setString(2, userId);
ResultSet rs = selectHoldingNoLockStat.executeQuery();
if (rs.next()) {
try {
holding = new CustomHoldingBean(
rs.getInt(1),
- rs.getInt(2),
- rs.getDouble(3),
- rs.getBigDecimal(4),
-
StockTraderUtility.convertToCalendar(rs.getDate(5)),
- rs.getString(6));
+ holdingID,
+ rs.getDouble(2),
+ rs.getBigDecimal(3),
+
StockTraderUtility.convertToCalendar(rs.getDate(4)),
+ rs.getString(5));
return holding;
} finally {
try {
