| From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
|---|---|
| To: | "surabhi(dot)ahuja" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: date value not geting inserted properly |
| Date: | 2006-06-07 12:30:41 |
| Message-ID: | 4486C6F1.7070408@opencloud.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-jdbc |
surabhi.ahuja wrote:
> stmt.setObject(i + 1, (tagV.value),
> ((TypeAttrib) (primaryKeyMap_.get(tMap.get(temp)))).dataType);
>
> can u please tell as to what should the dataType be for date, isnt it
> 91- integer?
java.sql.Types.DATE is 91, which should be correct if you're inserting a
bare date (with no time part).
What is the type and value of the "tagV.value" object?
What driver version and server version are you using?
What is the query you are executing?
Can you provide a selfcontained testcase showing the problem? You
haven't really given us enough info to go on here.
-O
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Filip Rembiałkowski | 2006-06-07 13:09:18 | Re: COLLATE |
| Previous Message | chris smith | 2006-06-07 12:25:16 | Re: ean code data type |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan de Visser | 2006-06-07 12:42:20 | Re: PostgreSQL XA & EJB container |
| Previous Message | surabhi.ahuja | 2006-06-07 11:54:33 | date value not geting inserted properly |