Question on the data type short

[Melinda Savoy]

When looping through a SQL ResultSet, I am adding the attributes of a resultset to an object called Card. In my card object there is a variable defined as: private short cardSequence

When stepping through the WHILE statement below to populate my Card object from the resultset, when I get to populating the property called cardSequence I exit the while statement and my Card object is NOT populated.

In the SQL table the column for cardSequence is a datatype of "smallint". What should I be using to populate the property called cardSequence so that my object gets populated completely?

if (results != null) {
				while (results.next()) {
					if (results.getString("CardNumber") != null) { 
						System.out.println("I got the card number " + results.getString("CardNumber"));
					}
					
					Card newCard = new Card();

					newCard.databaseId = results.getLong("Id");
					newCard.cardnumber = results.getString("CardNumber");
					newCard.status = results.getByte("Status");
					newCard.expire = results.getString("Expiration");
					newCard.MMYY = results.getString("ExpireMMYY");
					newCard.YYMM = results.getString("ExpireYYMM");
					newCard.atmLimit = results.getLong("ATMLimit");
					newCard.atmUsed = results.getLong("ATMUsed");
					newCard.purLimit = results.getLong("PurchLimit");
					newCard.purUsed = results.getLong("PurchUsed");
					newCard.zip = results.getString("Zip");
					newCard.address = results.getString("Address");
					[b][color=red]newCard.cardSequence = results.getShort("Sequence");[/color][/b] 
					newCard.cardType = SwitchConstants.CardType.cardTypeForPbfValue(results.getShort("Sequence"));
					newCard.YYMM = newCard.expire.substring(6, 8) + newCard.expire.substring(0, 2);
					newCard.MMYY = newCard.expire.substring(0, 2) + newCard.expire.substring(6, 8);
					cards.put(newCard.cardnumber, newCard);
					rowsRetrieved++;

				}
			}

Any help/direction would be appreciated. Thanks.

[Jesper de Jong]

Melinda Savoy wrote:When stepping through the WHILE statement below to populate my Card object from the resultset, when I get to populating the property called cardSequence I exit the while statement and my Card object is NOT populated.

Why not? Does an exception occur? Is your code catching the exception and printing the error message? If yes, then please post the exact error message.

Could it be that the column is null in the database?

Also note that in lines 21 and 22 you're getting the same column, named "Sequence", twice. Is that really what you intended?

[Melinda Savoy]

Sorry about an exception was caught and it states: Exception caught: com.microsoft.sqlserver.jdbc.SQLServerException: The column name Sequence is not valid.

The SP was different than my SQL statement. Sorry about that. Thanks for the help.

Regards.

[Rob Spoor]

Are you sure you have a column named "Sequence"?