Hi All,
public static final
String INSERT_QUERY =
"INSERT INTO USER_SUMMARY(USER_ID,LOGIN_TIME) VALUES (?,?)";
/**
* @param args
*/
public static void main(String[] args) {
try {
Driver d = (Driver)Class.forName
("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
Connection conn = DriverManager.getConnection(
"jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=E:/preetish/userapplication.mdb"
);
System.out.println("Connection Obtained : " + conn );
PreparedStatement ps =
conn.prepareStatement(INSERT_QUERY);
ps.setInt(1,1);
Date date = new Date();
Calendar cal = Calendar.getInstance();
cal.setTime(date);
ps.setString(2,cal.getTime().toString());
boolean rs = ps.execute();
System.out.println(rs);
/*while(rs.next()){
System.out.print("User_id : " + rs.getString("user_id"));
}
*/
} catch (InstantiationException e) {
e.printStackTrace();
} catch (IllegalAccessException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch(SQLException sqe){
sqe.printStackTrace();
}
Here, is a simple
java programme were i m trying to insert data in the table user_summary. But, the error i'm gettign is :
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(Unknown Source)
at com.connection.JdbcConnection.main(JdbcConnection.java:43)
I don't hav any idea as to wat this error is.
Pls. help me out in this.