Data output in two Clob columns are switched
I'm using Spring 1.2.8, Hibernate 3.2.5, Websphere 6, JDK 1.4.2, and Oracle 9i, although for this test case I'm using the 10g driver.
I have a table with a small number of columns, and two of them are Clob columns. When I write the data out with Hibernate and then look at the database, the data is all there, but the values in the two Clob columns are reversed (data in other non-clob columns is fine). I've stared at my code for a long time now, and I've even stepped into the Hibernate code that calls PreparedStatement.setCharacterStream(). As far as I can tell, it's passing the correct index and value each time.
I don't know if this is relevant, but the Hibernate Oracle dialect specifies that Clob columns should be set with "setCharacterStream()" instead of "setClob()". I don't know if I can change that, or if using "setClob()" could even work.
This sure seems like I'm seeing a bug in the JDBC driver.