Hello, I am trying to JBoss Cache working with a Firebird database using the Jaybird JDBC driver. However, when I start up my example I get the following exception (see below). I am sure this is because of the BLOB type size limitations, however I'm not entirely sure. I know there is a workaround for Mysql to use "longblob" instead of "blob" in the configuration file. Is there something similar for Firebird? Any help is greatly appreciated.
Thanks, Ryan Exception in thread "main" org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544351. unsuccessf ul metadata update key size too big for index JBOSSCACHE_PK at org.firebirdsql.jdbc.AbstractStatement.executeUpdate(AbstractStatement.java:281) at org.jboss.cache.loader.JDBCCacheLoader.start(JDBCCacheLoader.java:726) at org.jboss.cache.loader.AsyncCacheLoader.start(AsyncCacheLoader.java:303) at org.jboss.cache.loader.CacheLoaderManager.startCacheLoader(CacheLoaderManager.java:353) at org.jboss.cache.TreeCache.startService(TreeCache.java:1413) at org.jboss.cache.aop.PojoCache.startService(PojoCache.java:94) at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274) at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:181) at TestCache1.main(TestCache1.java:25) at org.firebirdsql.gds.GDSException: unsuccessful metadata update key size too big for index JBOSSCACHE_PK at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.readStatusVector(AbstractJavaGDSImpl.ja va:2113) at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.receiveResponse(AbstractJavaGDSImpl.jav a:2063) at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscDsqlExecute2(AbstractJavaGDSImpl.jav a:1155) at org.firebirdsql.gds.impl.GDSHelper.executeStatement(GDSHelper.java:223) at org.firebirdsql.jdbc.AbstractStatement.internalExecute(AbstractStatement.java:1109) at org.firebirdsql.jdbc.AbstractStatement.executeUpdate(AbstractStatement.java:277) at org.jboss.cache.loader.JDBCCacheLoader.start(JDBCCacheLoader.java:726) at org.jboss.cache.loader.AsyncCacheLoader.start(AsyncCacheLoader.java:303) at org.jboss.cache.loader.CacheLoaderManager.startCacheLoader(CacheLoaderManager.java:353) at org.jboss.cache.TreeCache.startService(TreeCache.java:1413) at org.jboss.cache.aop.PojoCache.startService(PojoCache.java:94) at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274) at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:181) at TestCache1.main(TestCache1.java:25) Configuration file: org.jboss.cache.loader.JDBCCacheLoader <!-- same as the old CacheLoaderConfig attribute --> cache.jdbc.table.name=jbosscache cache.jdbc.table.create=true cache.jdbc.table.drop=true cache.jdbc.table.primarykey=jbosscache_pk cache.jdbc.fqn.column=fqn cache.jdbc.fqn.type=varchar(255) cache.jdbc.node.column=node cache.jdbc.node.type=blob cache.jdbc.parent.column=parent cache.jdbc.driver=org.firebirdsql.jdbc.FBDriver cache.jdbc.url=jdbc:firebirdsql:127.0.0.1/3050:pango.fdb cache.jdbc.user=sysdba cache.jdbc.password=xxx <!-- whether the cache loader writes are asynchronous --> true <!-- only one cache loader in the chain may set fetchPersistentState to true. An exception is thrown if more than one cache loader sets this to true. --> true <!-- determines whether this cache loader ignores writes - defaults to false. --> false <!-- if set to true, purges the contents of this cache loader when the cache starts up. Defaults to false. --> false View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4004892#4004892 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4004892 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user