Hi , Can I have a java class , which will accept one oracle connection and return an array of connections which will be used to do database transactions . All these connections , should use the main connection for querying. Can someone provide the class ? Your help will be highly appreciated . Also , is there any way to break a connection into number of connections which can run the queries in parallel ? Thanks one again .
Sounds like what you should be looking at is a Connection Pooling mecahnism of some sort. I'm not sure you can do it the way you want - you can't 'clone' database connections. ie given a connection, create others with the same properties. One reason for this is that the original may have been created with a username and password, and you are not allowed to access this. Dave