Convert Timestamp from Database to java.sql.Timestamp

Question

I am querying data from a database and want to convert a Database Timestamp to a java.sql.Timestamp:

    List<Map<String, Object>> rows = jdbcTemplate.queryForList(SELECT_ALL_DATA);    
    for(Map row : rows) {
                Customer customer = new Customer();
                customer.setMaturityDate(new Timestamp((Long) row.get("MATURTIY_DATE")));
    }

However, doing it like that gives me:

Exception in thread "AWT-EventQueue-0" java.lang.ClassCastException: java.sql.Timestamp cannot be cast to java.lang.Long

I also tried it without the cast to Long, but this gives me:

The constructor Timestamp(Object) is undefined

Any recommendations how to cast the database object?

I appreciate your reply!

DirkNM · Accepted Answer · 2014-10-23 07:01:11Z

1

You don't need to create a new timestamp instance because it is already returned one:

List<Map<String, Object>> rows = jdbcTemplate.queryForList(SELECT_ALL_DATA);    
for(Map row : rows) {
            Customer customer = new Customer();
            customer.setMaturityDate((Timestamp)row.get("MATURTIY_DATE"));
}

answered Oct 23, 2014 at 7:01

DirkNM

2,66417 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert Timestamp from Database to java.sql.Timestamp

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related