Hi All,

our requirement is that we do not want Spring batch tables included in business database. So we have created separate database for Spring batch tables. Database provider is same for both database as Sybase.

1. configured separate data source for Spring batch and business database. Transaction managers are also different for both. Job repository will have batch data source and batch transaction manger where as for our configured Job transaction manager is business data source and business trans manager

2. I tried to run job which is spanning in partitions and it worked fine during committing as well as rollback conditions.
When business operation failed, it rolled back all business data. But Spring Batch tables metadata doesn't rolled back. I believe this is required so that we will come to know that job is failed by looking at spring batch tables.

I like to know whether I should use JTATranactionManager when we have only 1 business database. I believe Spring batch manages transactions for Spring batch schema and business database. But when business databases are multiple then only we have use JTA TranactionManager ?

Does Aysnc processing will have any impact when databases are separate ?

If anybody has idea Sybase will also work in same way ?

Please correct me about my understanding.

Thanks as always.

Regards,
Tushar