This forum is now a read-only archive. All commenting, posting, registration services have been turned off. Those needing community support and/or wanting to ask questions should refer to the Tag/Forum map, and to http://spring.io/questions for a curated list of stackoverflow tags that Pivotal engineers, and the community, monitor.

AnnouncementAnnouncement Module

Collapse

No announcement yet.

Is it possible to add two more columns to the batch_job_execution table?Page Title Module

Is it possible to add two more columns to the batch_job_execution table?

Feb 26th, 2008, 10:16 PM

I am scheduling batch jobs dynamically from web page using quartz scheduler Api.Whatever batch job schedule information user entered into the web page..I am storing to a table called batch_schedule(which has id and version on it with some other scheduling information) in the database and using quartz scheduler to schedule it.When it's executing the job it's entering information into Batch_Job_Execution.Upto that point everything is fine.

To that Batch_Job_Execution we would like to add 2 more columns(id,version) so that we can easily map that table to batch_schedule.

I have batch_job_execution table in my oracle database..so adding 2 more columns is not a big deal.

But how can I change the Spring batch execution hibernate mapping xml files and dao classes in such a way that it should include these 2 columns dynamically whenever it's entering values into batch_job_execution table.
And if I can do that will I need to make changes to any other classes too.