Inserting 'Dates' in database - Mailing list pgsql-jdbc

From Dan McDaniel
Subject Inserting 'Dates' in database
Date
Msg-id 587C9ED8EF99D3118DCD00508B115FF29103D3@EXCH1
Whole thread Raw
Responses Re: Inserting 'Dates' in database
Re: Inserting 'Dates' in database
List pgsql-jdbc
I am writing a simple Java user interface to a simple data base in
Postgresql.
I have no trouble connecting through my code using the JDBC driver. I can
get several different Resultsets back with no problem. I am having trouble
inserting data into the database. In particular  Date data types. I get a
message that says "Bad Date external representation".
Here is how I am trying to solve the problem:
I am getting a text string from the user interface and storing it in a
String varialble called " dateInsert".
Using a method I wrote call "convertDate()" , I am converting this date
first to a java.util.Date object, a time object  and finally to a
java.sql.Date object called "sqldate" which I include in the Insert
statement.

here is the code snippet for the "convertDate() method:
<pre>
 public java.sql.Date convertDate()
    {
     java.util.Date adate;
    DateFormat fmt = DateFormat.getDateInstance(DateFormat.SHORT,
Locale.US);
try {
           aDate = fmt.parse(dateInsert); // dateInsert is String from
JTextPane;
    long time = aDate.getTime();
    sqldate = new java.sql.Date(time);
}
    catch (ParseException e)
    {
        System.out.println(e);
    }
    return sqldate;
} //end of convertDate()
</pre>

I pent allmost 18 hours trying to work this out  yesterday and have run out
of ideas. Can anyone  suggest a direction for me?

Thanks
Dan McDaniel
Director of Architecture and Facility Planning
ext. 2048
beeper 1152


pgsql-jdbc by date:

Previous
From: "Barry Lind"
Date:
Subject: Re: raw data broken in 7.2 driver?
Next
From: "Robert Dyas"
Date:
Subject: problems with setBytes getBytes