Statement setNull for Types.CLOB
| От | Matt Magoffin |
|---|---|
| Тема | Statement setNull for Types.CLOB |
| Дата | |
| Msg-id | 49924.192.168.1.1.1108748477.squirrel@192.168.1.1 обсуждение исходный текст |
| Ответы |
Re: Statement setNull for Types.CLOB
|
| Список | pgsql-jdbc |
Hello, I'm using PostgreSQL 8 and the 310 build of the 8.0 JDBC3 driver with Hibernate. For 'text' columns in my database, I had mapped them to the Hibernate "text" type. When attempting to set the value of a text column to 'null' via a PreparedStatement Hibernate calls setNull() passing the Types.CLOB as the SQL type. The Postgres driver is throwing an exception, however, saying that type is unknown. I can easily change the Hibernate mapping to "string", which would change the SQL type passed to setNull() to Types.VARCHAR, but I was wondering if Types.CLOB should be a supported value in the setNull() JDBC method? I realize it might not be correct to think of the PostgreSQL text type as a CLOB, so I just wanted some insight on this issue if possible. Thanks,
В списке pgsql-jdbc по дате отправления: