Problem with pool connections

[juamd]

Hi !!!


I have an application with which creates a pool connections using OracleConnectionManager and OracleDataSource. I wonder if I have to close the connections or OracleConnectionManeger does it for me.

Thanks a lot.

[juamd]

I posted it in the wrong forum, that's why I am here posting it again.

[Tolls]

And I answered in the other bit of the forum.
Don't you think it might have been an idea to refer to that somehow?

[juamd]

You are right, I haven't seen all of the message, I will close all connections in order to return it to connectionmanager.

Thanks a lot.

[juamd]

Imagine this situation: My application works as follows: we have a client who sends a request to the server, the server sends a request to another application owned by another company, when the server receives another's company checks it, if the answer is ok then the server inserts in own database. All of these in a thread but sometimes when the server is trying to insert in the database it lost the connection. I can't do a rollback in the other's company database. What can I do solve this problem ?

[Tolls]

Common problem.
What if you changed the order.
Insert into your db...while the transaction is open (not good I admit) call the other server to check for "ok". If not "ok" then rollback.

[juamd]

I thought in that way but I also need to store some information that is returned to the server from the other company, and it will need to do an update on the table.

[Tolls]

OK.
Then all you can do is have the remote server provide a way to rewind a change.
Of course how easy that is entirely depends on what data changes that remote server is doing.

[juamd]

Unfortunately the other company said to us that they can't let us to execute rollbacks on their database, so I have some ideas in mind and the number one and which seems very good to me is to have a collection like an arraylist in which each item is an object with the info I want to insert and I couldn't. The collection in mind will be a static member of the class so every thread can access to it. What I want to do is check if the collection has items, if so insert those items in the database. What do you think about this method ?

[Tolls]

Since I have no idea what exactly it is you're doing I really can't advise you.
This is an architectural problem to some extent, and so requires a good knowledge of the ins and outs of your architecture...which is simply not going to happen on a website forum.