RE: [Log4plsql] JDBC to stored procedure using LOG4PLSQL: How to avoid file handles being closed?

[<log...@li...>]

Finn,

with LOG4PLSQL, we have not this problem. Whe have make a choise
do not use a java in database.

In LOG4PLSQL architeture we have write a backgroun process for
fetch a data in log4plsq table and send this data to log4J.

see:http://log4plsql.sourceforge.net/src/contribs/GuillaumeMoulard/java/log=
4plsql/backgroundProcess/ReaderLogDataBase.sq
lj

--g

-----Message d'origine-----
De : log...@li...
[mailto:log...@li...]
Envoy=E9 : mardi 6 ao=FBt 2002 10:55
=C0 : log...@li...
Objet : [Log4plsql] JDBC to stored procedure using LOG4PLSQL: How to
avoid file handles being closed?


Hi there.

Half a year ago I built a PL/SQL wrapper around Log4J that was loaded into
an 8.1.6 database. I had the following severe problem with that solution:
When calling a stored procedure (that used the PL/SQL wrapper) from Java
through JDBC it turned out that the Oracle VM closed all open file handles
(and also sockets) on purpose when the JDBC call finished even though stati=
c
objects that could survive the call were used. Oracle explained that this i=
s
by design and documented in the section "Operating System Resources Affecte=
d
Across Calls" at
http://technet.oracle.com/doc/oracle8i_816/java.816/a81353/03writed.htm.

Have you been able to find a workaround with LOG4PLSQL for this serious
issue?

Cheers,

Finn

---------------------------------------------------------------------------=

 Finn Ellebaek Nielsen                           ChangeGroup ApS
 Product Manager, Principal Consultant, Partner  Kronprinsessegade 54, 4.
 E-mail: fe...@ch...                      DK-1306  Koebenhavn K
 Mobile: +45 20 32 49 25                         Denmark
 Phone:  +45 33 32 77 78                         http://www.changegroup.dk
---------------------------------------------------------------------------=

                      "Where do you want to GPF today?"




-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Log4plsql-all-info mailing list
Log...@li...
https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info
log4plsq : http://log4plsql.sourceforge.net