From: | Dan McDaniel <Dan-McDaniel(at)smh(dot)com> |
---|---|
To: | "'pgsql-jdbc(at)postgresql(dot)org'" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Inserting 'Dates' in database |
Date: | 2002-04-08 21:58:59 |
Message-ID: | 587C9ED8EF99D3118DCD00508B115FF29103D3@EXCH1 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2002-04-09 00:01:46 | Re: JDBC Driver Problem |
Previous Message | Barry Lind | 2002-04-08 16:58:57 | Re: raw data broken in 7.2 driver? |