jdbc and automagic casting - Mailing list pgsql-jdbc

From Guillaume
Subject jdbc and automagic casting
Date
Msg-id 419cf418-a33a-4c61-858c-208bf5d55844@g30g2000yqc.googlegroups.com
Whole thread Raw
Responses Re: jdbc and automagic casting
List pgsql-jdbc
Hello,

I have an INSERT which does not behave the same under jdbc and psql.

With psql, INSERTing a poperly formed VARCHAR into an inet column
would work, eg.:

=# \d user_record;
                  Table "user_record"
        Column        |          Type          | Modifiers
----------------------+------------------------+-----------
 id                   | integer                |
 username             | character varying(64)  |
 registered_ip        | inet                     |

INSERT INTO user_record (0, 'abc', '127.0.0.1') is valid and works.
The string is automagically casted as an inet value.

Using jdbc, this is not the case, and causes me loads of trouble (and
exceptions).
Is there a way around it?

I do not have access to the java source code, there is thus no way to
update the code to programatically force a CAST.

Thanks for any help,
Guillaume



pgsql-jdbc by date:

Previous
From: Bodor Andras
Date:
Subject: Re: binary patch problems
Next
From: Bodor Andras
Date:
Subject: Re: binary patch problems