[JBoss-user] [JBossCache] - JDBCCacheLoader: primary key creation fails

[neotyk <do-...@jb...>]

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
  | 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3903122#3903122

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3903122