[opencms-dev] AW: Better DbPool to be used with oracle.

[Andreas Schouten]

Hi Anders,

wat is the result of putting that pool into the cvs? Do we get another
subpackage in com.opencms.file? Is there another solution (e.g.
configuration which pool to use)?

Regards,

Andreas Schouten

-----Ursprüngliche Nachricht-----
Von: Anders Peter Fugmann [mailto:anders.fugmann at framfab.dk]
Gesendet: Mittwoch, 25. Oktober 2000 14:37
An: Andreas Schouten
Cc: opencms-dev at opencms.com
Betreff: Better DbPool to be used with oracle.


Hi Andreas.

As you know, we have programed a new CmsDbPool to be used with Oracle.
The pool can restore broken connections, and is by far better that the
existing one, if the connection to the database is unstable, and the
connection to it dies often.

We talked about putting this into the Main CVS, but agreed that it would
increase complexity, and the correct solution was to write a good
generic DbPool.

Now our problem is that the site we are building needs this pool and we
would like to avoid having a local patch, which we need pt "use" each
time there is a new build. Therefore I will ask you if we can put it in
temporarily, and remove it, when the generic pool is done. I know this
is not the best way, but it will be a lot easier for us (here in
Denmark), and also others should have access to this piece of code, if
anyone is experiencing problems with database connections.

What do you think?

We will in the near future implemented a general pool, which includes 
true load balancing, safer usage (a programmer cannot "forget" to put
back a prepared statement), and connection monitoring (removing dead
connections, and creating new ones.).



-- 
. . . . . . . . . . . . F r a m f a b   A / S . . . . . . . . . . . . .
Anders Fugmann                                 Livjægergade 17A, 2.sal.
Systems Developer                              DK-2100 København Ø.
E-mail: anders.fugmann at framfab.dk              Telefon: +45 39 17 48 48
Direkte: +45 39 17 48 38                       http://www.framfab.dk
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .