java - Hibernate自定义类型避免 'Caused by: java.sql.SQLException: Stream has already been closed'

Question

如何编写自定义 Long 类来处理 Oracle 中的 long 值，以避免出现以下错误？

Caused by: java.sql.SQLException: Stream has already been closed.

谢谢

Answer 1

甲骨文 recommends not using Long 和 Long Raw 列(自 Oracle 8i 起)。它们仅出于遗留原因包含在 Oracle 中。如果您真的需要使用它们，您应该先处理这些列，然后再尝试接触 ResultSet 中的任何其他列:

Docs :

When a query selects one or more LONG or LONG RAW columns, the JDBC driver transfers these columns to the client in streaming mode. After a call to executeQuery or next, the data of the LONG column is waiting to be read.

Do not create tables with LONG columns. Use large object (LOB) columns, CLOB, NCLOB, and BLOB, instead. LONG columns are supported only for backward compatibility. Oracle recommends that you convert existing LONG columns to LOB columns. LOB columns are subject to far fewer restrictions than LONG columns.

至于 hibernate - 请参阅此 question .