Thread: How to work with OID type?

Hello

Which setXXX() method should I use from java.sql.PreparedStatement
interface to set value of the OID type (this is PostgreSQL type).
setObject does not work :-(

Same question about getXXX() method from java.sql.ResultSet interface.

Thank you
Valera


--
The information contained in this communication and any attachments is confidential and may be privileged, and is for
thesole use of the intended recipient(s). Any unauthorized review, use, disclosure or distribution is prohibited. If
youare not the intended recipient, please notify the sender immediately by replying to this message and destroy all
copiesof this message and any attachments. ASML is neither liable for the proper and complete transmission of the
informationcontained in this communication, nor for any delay in its receipt. 

Valeriy,

I would recommend using get/setLong(), since the oid is an unsigned
integer.  get/setString should also work.

thanks,
--Barry

Valeriy Voitishchuk wrote:
> Hello
>
> Which setXXX() method should I use from java.sql.PreparedStatement
> interface to set value of the OID type (this is PostgreSQL type).
> setObject does not work :-(
>
> Same question about getXXX() method from java.sql.ResultSet interface.
>
> Thank you
> Valera
>
>