JDBCCacheLoader: primary key creation fails

[neotyk]

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

[brian.stansberry]

You're right; this should be configurable. Everything else in the create table DDL is. Can you open a feature request on JIRA for this?

As a workaround, you can manually create your db tables, and set config properties cache.jdbc.table.create and cache.jdbc.table.drop to false.

[neotyk]

JIRA feature request created: http://jira.jboss.com/jira/browse/JBCACHE-345