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