| Lists: | pgsql-jdbc |
|---|
| From: | Luca Ferrari <fluca1978(at)infinito(dot)it> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Date time format out of range???? |
| Date: | 2006-10-31 10:18:55 |
| Message-ID: | 200610311118.55852.fluca1978@infinito.it |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc |
Hi,
I'm using my java application to access a pg8 database, but now I'm getting
the following error performing the following insert:
[Logger - info] Preparing a statement for the query <INSERT INTO persona
VALUES('FRR999','LUCA','FERRARI','19/07/1978','0000000000000','000000000','00000','BLLLLLLLLLLLLLLLLLL','Modena','Modena','','31/9/2006','luca','31/9/2006','luca')>
[Logger - error] Caught SQL exception in query execution
org.postgresql.util.PSQLException: ERROR: date/time field value out of
range: "31/9/2006"
org.postgresql.util.PSQLException: ERROR: date/time field value out of
range: "31/9/2006"
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
While in other tables it has worked with dates!
The information about the table persona are the followings:
gestione_personale=# \d persona;
Table "public.persona"
Column | Type | Modifiers
--------------------+-----------------------+-----------
codice_fiscale | character varying(20) | not null
nome | character varying(12) |
cognome | character varying(20) |
data_nascita | date |
telefono | character varying(20) |
cellulare | character varying(20) |
fax | character varying(20) |
indirizzo | character varying(50) |
citta_nascita | character varying(20) |
citta_residenza | character varying(20) |
titolo_studio | character varying(20) |
data_inserimento | date |
utente_inserimento | character varying(20) |
data_modifica | date |
utente_modifica | character varying(20) |
Indexes:
"persona_pkey" primary key, btree (codice_fiscale)
Foreign-key constraints:
"$1" FOREIGN KEY (utente_inserimento) REFERENCES users(username)
"$2" FOREIGN KEY (utente_modifica) REFERENCES users(username)
"$3" FOREIGN KEY (titolo_studio) REFERENCES titolo_studio(titolo)
"$4" FOREIGN KEY (citta_residenza) REFERENCES citta(denominazione)
"$5" FOREIGN KEY (citta_nascita) REFERENCES citta(denominazione)
Any idea?
Thanks,
Luca
| From: | Tom Arthurs <tarthurs(at)jobflash(dot)com> |
|---|---|
| To: | Luca Ferrari <fluca1978(at)infinito(dot)it> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Date time format out of range???? |
| Date: | 2006-10-31 10:45:00 |
| Message-ID: | 4547292C.40602@jobflash.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc |
There is no 31 Sept, the month only has 30 days.
Luca Ferrari wrote:
> Hi,
> I'm using my java application to access a pg8 database, but now I'm getting
> the following error performing the following insert:
>
> [Logger - info] Preparing a statement for the query <INSERT INTO persona
> VALUES('FRR999','LUCA','FERRARI','19/07/1978','0000000000000','000000000','00000','BLLLLLLLLLLLLLLLLLL','Modena','Modena','','31/9/2006','luca','31/9/2006','luca')>
> [Logger - error] Caught SQL exception in query execution
> org.postgresql.util.PSQLException: ERROR: date/time field value out of
> range: "31/9/2006"
> org.postgresql.util.PSQLException: ERROR: date/time field value out of
> range: "31/9/2006"
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
>
>
> While in other tables it has worked with dates!
> The information about the table persona are the followings:
>
> gestione_personale=# \d persona;
> Table "public.persona"
> Column | Type | Modifiers
> --------------------+-----------------------+-----------
> codice_fiscale | character varying(20) | not null
> nome | character varying(12) |
> cognome | character varying(20) |
> data_nascita | date |
> telefono | character varying(20) |
> cellulare | character varying(20) |
> fax | character varying(20) |
> indirizzo | character varying(50) |
> citta_nascita | character varying(20) |
> citta_residenza | character varying(20) |
> titolo_studio | character varying(20) |
> data_inserimento | date |
> utente_inserimento | character varying(20) |
> data_modifica | date |
> utente_modifica | character varying(20) |
> Indexes:
> "persona_pkey" primary key, btree (codice_fiscale)
> Foreign-key constraints:
> "$1" FOREIGN KEY (utente_inserimento) REFERENCES users(username)
> "$2" FOREIGN KEY (utente_modifica) REFERENCES users(username)
> "$3" FOREIGN KEY (titolo_studio) REFERENCES titolo_studio(titolo)
> "$4" FOREIGN KEY (citta_residenza) REFERENCES citta(denominazione)
> "$5" FOREIGN KEY (citta_nascita) REFERENCES citta(denominazione)
>
>
> Any idea?
> Thanks,
> Luca
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate
>
>
>