Not recognizing Date Type in Java MySQL DB Call

Question

I have the following calls in one of my classes

@Override
public Integer save(NewsItem item){
    ConnectionPool pool = new ConnectionPool();
    Connection connection = pool.getConnection();
    PreparedStatement ps = null;
    try{
        String query = "INSERT INTO newsItem (type,title,content,link,layout,imageUri,timestamp)" +
                       "VALUES (?,?,?,?,?,?,?)";
        ps = connection.prepareStatement(query);
        ps.setInt(1,item.getType());
        ps.setString(2,item.getTitle());
        ps.setString(3,item.getContent());
        ps.setString(4,item.getLink());
        ps.setInt(5,item.getLayout());
        ps.setString(6,item.getImageUri());
        ps.setDate(7,item.getTimestamp());

        return ps.executeUpdate();
    }
    catch(SQLException e){
        e.printStackTrace();
        return 0;
    }
    finally{
        ConnectionUtility utility = new ConnectionUtility();
        utility.closePreparedStatement(ps);
        pool.freeConnection(connection);
    }
}

The NewsItem POJO has the following properties

    private Integer id;
    private Integer type;
    private String title;
    private String content;
    private String link;
    private Integer layout;
    private String imageUri;
    private Date timestamp;

Everything works and has been tested except for the timestamp call which is

ps.setDate(7,item.getTimeStamp())

I am able to set the Date on the NewsItem object by calling

item.setTimestamp(new Date());

but I get the error from my IDE (Eclipse) that tells me the following message

The method setDate(int,Date) in the type NewsItemDAO is not applicable for the arguments setDate(int,Date)

This has been a plague for me throughout the life of this application I have been working on because I have had to result to storing the timestamps as string for the time being.

If the column in my MySQL database is of type DATETIME is there a different way I should be saving that timestamp? Or is there something wrong with the call?

BalusC · Accepted Answer · 2012-08-07 17:35:39Z

2

The setDate() expects java.sql.Date, not java.util.Date.

ps.setDate(7, new java.sql.Date(item.getTimestamp().getTime()));

But the java.sql.Date contains only the date part of datetime, not the time part. You'd like to use java.sql.Timestamp instead.

ps.setTimestamp(7, new Timestamp(item.getTimestamp().getTime()));

edited Aug 7, 2012 at 17:35

answered Sep 24, 2010 at 15:50

BalusC

1.1m377 gold badges3.7k silver badges3.6k bronze badges

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

3 Comments

TheJediCowboy Over a year ago

Does this method work well with MySQL and can I still use java.sql.Timestamp the way Java.util.Date is used? Should the MySQL datatype for this be TIMESTAMP or DATETIME?

BalusC Over a year ago

You should not use java.sql.Timestamp in your model object (POJO as you call it). Use it only during persisting in DB. On retrieving you can just upcast ResultSet#getTimestamp() to java.util.Date. As to the types, you can use both. The difference is only that TIMESTAMP is implicitly converted to UTC timezone and thus more recommended to avoid timezone headaches and unportability.

TheJediCowboy Over a year ago

excellent! I made the changes. Everything looks great as long as I can go back and forth with the Date type on my POJO and the value when I pull it out of the Database.

dpatchery · Accepted Answer · 2010-09-24 15:46:40Z

1

Check your imports - My guess is that you are using java.util.Date instead of java.sql.Date.

If possible, it's a good idea to use java.sql.Timestamp which extends java.util.Date to avoid this confusion and enhance the readability of your code.

answered Sep 24, 2010 at 15:46

dpatchery

5085 silver badges19 bronze badges

1 Comment

BalusC Over a year ago

The problem is in this particular case not in the imports. The Timestamp recommendation is however seconded, but not only due to readability.

Collectives™ on Stack Overflow

Not recognizing Date Type in Java MySQL DB Call

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related