2 Replies Latest reply on Oct 24, 2005 7:52 PM by Hubert Iwaniuk

    JDBCCacheLoader: primary key creation fails

    Hubert Iwaniuk Newbie

      Hello,
      I can't find a way to configure two caches so thay have two different tables for JDBCCacheLoader on one scheme.
      I get creating primary key exception:

      --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
      ObjectName: test.cache:service=SecondCache
       State: FAILED
       Reason: org.postgresql.util.PSQLException: ERROR: relation "jbosscache_pk" already exists
      
       I Depend On:
       jboss:service=Naming
       jboss:service=TransactionManager
       jboss.jca:name=/ds/Test/secondcache,service=DataSourceBinding

      In my DB:
      Indexes:
       "jbosscache_pk" PRIMARY KEY, btree (fqn)
      


      Is there a way of naming primary key?
      This would solve the problem.

      CacheLoaderConfig:
      cache.jdbc.datasource=java:/ds/Test/secondcache
       cache.jdbc.table.name=secondcache