I have a Date created in Java and then I want to store it into a database.
The date is being displayed but when I try to insert it to the DB I get an error.
This is my code:
Date Now = new Date();
PreparedStatement insertStmt = con.prepareStatement ("INSERT into Record(CStaffID,LoggedEvent) VALUES (?, ?)");
con.commit(); // commit transaction
but this is the error Im getting:
setString(int,java.lang.String) in java.sql.PreparedStatement cannot be applied to (int,java.util.Date)
Any help would be greatly appreciated,