null pointer in namedParameterJdbcTemplate

Asked Apr 05 '20 at 18:07

Active Apr 05 '20 at 18:07

Viewed 16 times

I am getting the namedParameterJBCtemplate as null value

    static String TABLE = "select * from cdh_spectrum_xstore_reg.%s";
    static String GET_TRANSACTION_BY_FILENAME = " where etl_source_name = :etlSourceName" + 
            " and pos_key in (select pos_key from cdh_spectrum_xstore_reg.pos_log where etl_source_name = :etlSourceName order by load_date desc limit 1)" + 
            " and batch_ts in (select batch_ts from cdh_spectrum_xstore_reg.pos_log where etl_source_name = :etlSourceName order by load_date desc limit 1)" +
            " limit 1";

@Transactional(isolation = Isolation.READ_COMMITTED, propagation = Propagation.REQUIRED)
public Transaction getIsolatedTransactionDetails(String fileName) {
    return namedParameterJdbcTemplate.queryForObject(String.format(TABLE, "pos_log") + GET_TRANSACTION_BY_FILENAME,
            new MapSqlParameterSource("etlSourceName", fileName),
            transactionMapper);
}

Here the filename is correctly coming when I debug What I noticed is namedParameterJdbcTemplate is giving null.

asked Apr 05 '20 at 18:07

Ashu

No it's. a null pointer issue.Its relate to template instatntiation. – Ashu Apr 05 '20 at 18:13
Create a bean `@Bean public JdbcTemplate jdbcTemplate() { return new JdbcTemplate(dataSource()); }` and try – Sreyas Apr 05 '20 at 18:17
@sreyas Created still same issue.Can I share me screen? – Ashu Apr 05 '20 at 18:20
ok please show the code – Sreyas Apr 05 '20 at 18:22

null pointer in namedParameterJdbcTemplate

0 Answers0