Question: SQL and JDBC How to solve this Code: Error column car_date is of type date but expression is of type character varying System.out.print(Please enter the
SQL and JDBC
How to solve this Code: Error column car_date is of type date but expression is of type character varying

System.out.print("Please enter the ID of car: "); genre=in.nextInt(); System.out.print("Please enter the model of car: "); mediaType=in.nextLine(); System.out.print("Please enter the car date: "); releaseDate=in.nextLine(); Connection con = null; ResultSet result=null; PreparedStatement stmt=null; try { Class.forName("org.postgresql.Driver"); //load driver // opening database connection to postgresql server String url = "jdbc:postgresql://localhost/a4"; con = DriverManager.getConnection(url,"postgres", "123"); ll getting Statement object to execute query stmt = con.prepareStatement("INSERT INTO cars(car_id,car_model.car_date)"+ "VALUES (?, ?, ?)'); stmt.setInt(1, carld); stmt.setString(2, carModel) stmt.setDate(3, carDate) result = stmt.execute Query()
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
