Author: shankar
Date: Wed May 6 09:42:45 2009
New Revision: 772118
URL: http://svn.apache.org/viewvc?rev=772118&view=rev
Log:
Fixing mysql "getHolding" error.
Modified:
incubator/stonehenge/trunk/stocktrader/wsas/common/src/org/apache/stonehenge/stocktrader/mysql/MySQLCustomerDAO.java
Modified:
incubator/stonehenge/trunk/stocktrader/wsas/common/src/org/apache/stonehenge/stocktrader/mysql/MySQLCustomerDAO.java
URL:
http://svn.apache.org/viewvc/incubator/stonehenge/trunk/stocktrader/wsas/common/src/org/apache/stonehenge/stocktrader/mysql/MySQLCustomerDAO.java?rev=772118&r1=772117&r2=772118&view=diff
==============================================================================
---
incubator/stonehenge/trunk/stocktrader/wsas/common/src/org/apache/stonehenge/stocktrader/mysql/MySQLCustomerDAO.java
(original)
+++
incubator/stonehenge/trunk/stocktrader/wsas/common/src/org/apache/stonehenge/stocktrader/mysql/MySQLCustomerDAO.java
Wed May 6 09:42:45 2009
@@ -110,19 +110,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 {
