Java Database Connectivity (JDBC) - Inserting a date

I'm having quite a lot of trouble inserting a date value to a database. I believe the problem is the format of the date. As when i use the java type date it seems to store it in iso format. The database stores its dates in the format mm/dd/yyyy. I've looked into class SimpleDateFormat, but can't seem to get to grips with it and changing the way the database stores the date is not an option. Any solutions would be appreciated.

DBMS : DB2

[457 byte] By [AlaNioa] at [2007-11-26 23:06:35]

«« Java Media Framework - JMF and Linux Performance Pack
»» Sun Java System Portal Server 6 - get global properties

# 1

Don't mess about with date formats in your code. Use a PreparedStatement and let the JDBC driver take care of it.

DrClapa at 2007-7-10 14:00:15 >

top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...

# 2

i am using a preparedstatement. i'm taking in a date value (dob) from a jsp page, passing it to a bean, then inserting it to the db. but the database is throwing an error because the date is in the wrong format.

AlaNioa at 2007-7-10 14:00:15 >

# 3

Then you must be messing with date formats in your SQL code. But that's just a guess based on the code you have posted so far, namely nothing. Don't you think it would be more practical to discuss the code you actually have rather than some theoretical concepts?

DrClapa at 2007-7-10 14:00:15 >

Database Connectivity

Java Database Connectivity (JDBC)

Java Database Connectivity (JDBC)

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

Java Database Connectivity (JDBC) - Inserting a date

Database Connectivity New Topic

Database Connectivity Hot Topic

Database Connectivity

All Classified