| From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> | 
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org | 
| Subject: | Re: Inserting into a uuid column | 
| Date: | 2009-03-04 07:46:40 | 
| Message-ID: | golbl5$aj4$1@ger.gmane.org | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-jdbc | 
Hi Kris,
thanks for your answers.
I can change the import to use setObject(int, Object, int) which works fine.
> The reason the driver doesn't do this is twofold.
> 
> 1) The driver doesn't know the target server type.  Retrieving that 
> would induce an extra network roundtrip for execution.
> 
> 2) Sometimes the server doesn't know the the target type and it's better 
> for the driver/user to provide it.  Consider the call of an overloaded 
> function: SELECT myfunc(?), if it has an implementation for both float 
> and int, you want the user/driver to indicate which one should be called 
> because the server doesn't know.
I can see the problems there ;)
Regards
Thomas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anthony Presley | 2009-03-04 23:11:10 | canceling query due to user request | 
| Previous Message | Oliver Jowett | 2009-03-03 22:53:23 | Re: Inserting into a uuid column |