Several Connection to Oracle8i

Thread view:

pierrerama@keromail.com - 13 Jun 2007 08:11 GMT

Hello,

Excuse for my bad english.

I would like make an multitask application (not web application). This
application could ask several request in a same time.
The problem, with an only connection, it's not possible, because the
second request waits the first request ended.

How resolving this issue? If I create an pool connexion on the server,
could I transfer a connection to another computer via RMI?

Is it correct?

Thanks for advance.

Reply to this Message

stefanomnn - 13 Jun 2007 10:02 GMT

On 13 Giu, 09:11, pierrer...@keromail.com wrote:

> Hello,
>
[quoted text clipped - 11 lines]
>
> Thanks for advance.

you should centralize on server methods who acces database:
you have getting a new connection for each request, a lot of
containers provide a connection pool, to help you for thiis goal!

Reply to this Message

Real Gagnon - 13 Jun 2007 12:33 GMT

> How resolving this issue? If I create an pool connexion on the server,
> could I transfer a connection to another computer via RMI?

Oracle JDBC driver has a built-in connection pool.

See http://www.rgagnon.com/javadetails/java-0545.html

Bye.

Signature

Real Gagnon from Quebec, Canada
* Java, Javascript, VBScript and PowerBuilder code snippets
* http://www.rgagnon.com/howto.html
* http://www.rgagnon.com/bigindex.html

Reply to this Message

Several Connection to Oracle8i

Free Magazines