storing date in mysql

[Jyoti Jadhav]

hi
in my program i am entering a string parsing it to date and storing it in table.
i am not getting any error but the table is not upfdating..
code is...

con2=GetConnection();
PreparedStatement st=con2.prepareStatement("INSERT INTO employee VALUES(?,?,?,?,?,?)");

String s="12/03/2007";
SimpleDateFormat df=new SimpleDateFormat("mm/dd/yyyy");
java.util.Date p=df.parse(s);
st.setString(1,"7");
st.setString(2,"manasi");
st.setString(3,"tilak");
st.setDate(4,(Date) p);
st.setString(5,"400000");
st.setString(6,"n");

st.executeUpdate();

[Paul Campbell]

are you in auto-commit mode?

[Jyoti Jadhav]

Originally posted by Paul Campbell:
are you in auto-commit mode?

how to check the auto commit mode?and i should or should not in auto commit mode..

thanks

[Jyoti Jadhav]

Originally posted by Paul Campbell:
are you in auto-commit mode?

yes i am in autocommit mode because executing
select @@autocommit;
giving me value 1.

[Rob Spoor]

Are you sure you are not getting a ClassCastException?

st.setDate(4,(Date) p);

Here, you are casting a java.util.Date object as java.sql.Date. The object isn't an instance of java.sql.Date however.

To create a java.sql.Date from a java.util.Date you have to do the following:

Date sqlDate = new Date(p.getTime());

The same goes for Time and Timestamp.

[Jyoti Jadhav]

Originally posted by Rob Prime:
Are you sure you are not getting a ClassCastException?

st.setDate(4,(Date) p);

Here, you are casting a java.util.Date object as java.sql.Date. The object isn't an instance of java.sql.Date however.

To create a java.sql.Date from a java.util.Date you have to do the following:

Date sqlDate = new Date(p.getTime());

The same goes for Time and Timestamp.

thanks
it worked.