I am OK with the complexity. I can not group sql task as there are dependencies on other tasks. please tell me how to achieve it.
Thanks Ashish On 1/11/07, Steve Loughran <[EMAIL PROTECTED]> wrote:
ashish shrivastava wrote: > I am using ANT for deployment of my product.I need to run different > SQL's at > different stages of my deployment, so if i use ANT SQL task it will > create a > new DB connection each time.Is there any way i can share the DB connection > between different tasks.(may be putting the connection in Project class > thru > my custom SQL task....)? > > Thanks in Advance > Ashish > No, its too complex to do connection pooling. Is it really that expensive to set up the connection? 1. You can do a sequence of operations in one <sql> Tasks. 2 you can use <presetdef> to define a task with all your db bindings. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
