Our JBoss Cache configuration is currently using the JDBCCacheLoader and Oracle 11i. This seems to work fine but occasionally during load tests we'll get this error:
org.jboss.cache.CacheException: java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column
<loader class="org.jboss.cache.loader.JDBCCacheLoader" async="false" fetchPersistentState="false" ignoreModifications="false" purgeOnStartup="false"> <properties> cache.jdbc.table.name=jbosscache cache.jdbc.table.create=true cache.jdbc.table.drop=false cache.jdbc.table.primarykey=jbosscache_pk cache.jdbc.fqn.column=fqn cache.jdbc.fqn.type=VARCHAR2(255) cache.jdbc.node.column=node cache.jdbc.parent.column=parent cache.jdbc.node.type=BLOB </properties> </loader>
Name Null? Type ----------------------------------------- -------- ---------------------------- FQN NOT NULL VARCHAR2(255) NODE BLOB PARENT VARCHAR2(255)
Dustin, search before posting: http://www.jboss.org/index.html?module=bb&op=viewtopic&t=157686&postdays=0&postorder=asc&start=0