User development, A new message was posted in the thread "JDBCCacheLoader with Oracle 10g problem":
http://community.jboss.org/message/531561#531561 Author : Tomas Frastia Profile : http://community.jboss.org/people/tfrastia Message: -------------------------------------------------------------- Hi I have the same problem and I think I managed to get it fixed. The problem was in class org.jboss.cache.loader.AdjListJDBCCacheLoader in method populatePreparedStatementForInsert(). A wrong SQL insert query is used when saving a business-object. If the business-object is larger than 4000 bytes then the SQL insert query fails and returns an error code ORA-01461. My fix: I changed the SQL insert query by replacing the second parameter from '?' to 'empty_blob()' and after a successfull insert into the DB I have selected the inesrted row and put it into blob data via java.sql.ResultSet. I uploaded corrected class and simple to POC JBoss-Cache-POC-and-fix.rar. Tomas, -------------------------------------------------------------- To reply to this message visit the message page: http://community.jboss.org/message/531561#531561
_______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user