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:
anonymous wrote : org.jboss.cache.CacheException: java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column Our cache loader configuration looks like this (without connection pooling): <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> The table created by JBoss Cache looks like this: Name Null? Type | ----------------------------------------- -------- ---------------------------- | FQN NOT NULL VARCHAR2(255) | NODE BLOB | PARENT VARCHAR2(255) The length of the data stored in the FQN and PARENT fields has a maximum size of about 50 characters. Most of the objects stored in the cache are around 2k but some may exceed 4k. Does anyone know what causes this error and how to prevent it? Thanks! Dustin View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4264640#4264640 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4264640 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
