jdbc and automagic casting

Поиск
Список
Период
Сортировка
От Guillaume
Тема jdbc and automagic casting
Дата
Msg-id 419cf418-a33a-4c61-858c-208bf5d55844@g30g2000yqc.googlegroups.com
обсуждение исходный текст
Ответы Re: jdbc and automagic casting  (Kris Jurka <books@ejurka.com>)
Список 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 по дате отправления:

Предыдущее
От: Bodor Andras
Дата:
Сообщение: Re: binary patch problems
Следующее
От: Bodor Andras
Дата:
Сообщение: Re: binary patch problems