CODEWITHSUNDEEP
springjdbcjdbctemplate
Yaniv Cohen
Yaniv Cohen

Reputation: 379

Spring JdbcTemplate returns empty result when there should be a valid result

I'm using SimpleJdbcDaoSupport object to access DB resources. I have a query which is frequently executed against the database to locate a record with a specific key. for some reason after executing the same query several times I start to get an empty result even though the record exists in the database.

Any ideas what can cause this behavior?

daoSupport.getJdbcTemplate().query(this.getConsumerTokenQueryStatement(),params, this.rowMapper); 
 public static class TokenServicesRowMapper implements RowMapper {  
   public Object mapRow(ResultSet rs, int rowNum) throws SQLException { 
     DefaultLobHandler lobHandler = new DefaultLobHandler(); 
     return lobHandler.getBlobAsBytes(rs, 1); 
   } 
}

Upvotes: 2

Views: 3433

Answers (1)

Sezin Karli
Sezin Karli

Reputation: 2525

If this is not related to your code one reason can be the fact that another transaction is doing something (like an update) to the row you search and due do the isolation between transactions you cannot see your row. One transaction can change but not commit your row yet while in the same time the other one is searching for it but as it can only see committed rows it does not see your row.

Upvotes: 1

Related Questions