Thread: Inserting 'Dates' in database

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

Dan,

Can you give me some data to input into this function to see how it
breaks ?

Dave
On Mon, 2002-04-08 at 17:58, Dan McDaniel wrote:
>
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>

On Monday 08 April 2002 23:58, Dan McDaniel wrote:
> 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:
>
> I pent allmost 18 hours trying to work this out  yesterday and have run out
> of ideas. Can anyone  suggest a direction for me?

Hi,
your convertDate() method looks OK - i guess your problem is with the SQL
Statement. Did you use a PreparedStatement and its setDate() method to build
your statement? If not, try this, it avoids a lot of trouble with Dates....

Greetings
Andreas

Barry,

The BatchUpdate test is now failing. This appears to be because execute
will now execute a select statement?

Is this desired behaviour?

Dave