[log4plsql] sqlj runtime problems

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

To resend to "log...@li..."

Hi,
	my name is Francesco Cadili and I start to use log4plsql. I 
use it inside a Oracle 9iR2 (version 9.2.0.4) in a linux server 
machine through a Oracle 9.0.1 Client installed into a Windows XP 
machine.

I had some problem with the oracle java package stored in my local 
workstation with the ./startLog4JbackgroundProcess.bat process. With 
the Oracle 9.0.1 package the give the following error:

$ ./startLog4JbackgroundProcess.bat

d:\Lib\open-source\sourgeforge\Log4plsql\Log4plsql\cmd>setlocal

d:\Lib\open-source\sourgeforge\Log4plsql\Log4plsql\cmd>call setVariable.bat
variable setup
2004-02-17 15:18:20,605 INFO  [main] backgroundProcess (     Run.java:62)     -
start log4plsql.properties: .\properties\log4plsql.xml
2004-02-17 15:18:20,980 INFO  [main] 
backgroundProcess.ReaderLogDataBase (Reader
LogDataBase.sqlj:83)     - Startup logSource:logSource1 
dbURI:jdbc:oracle:thin:@
oracle9ir2:1527:KIRK dbUser:ulog dbPass:ulog pipeName:LOG_PIPE_gm
java.lang.NoSuchMethodError
         at 
log4plsql.backgroundProcess.ReaderLogDataBase.readlog(ReaderLogDataBa
se.sqlj:166)
         at log4plsql.backgroundProcess.ReaderThread.run(ReaderThread.java:56)
2004-02-17 15:18:21,090 INFO  [main] 
backgroundProcess.ReaderLogDataBase (Reader
LogDataBase.sqlj:83)     - Startup logSource:logSource2 
dbURI:jdbc:oracle:thin:@
oracle9ir2:1527:KIRK dbUser:ulog dbPass:ulog pipeName:LOG_PIPE
java.lang.NoSuchMethodError
         at 
log4plsql.backgroundProcess.ReaderLogDataBase.readlog(ReaderLogDataBa
se.sqlj:166)
         at log4plsql.backgroundProcess.ReaderThread.run(ReaderThread.java:56)

My jdk version is 1.3.1_09-b3. The problem seems to be related to one 
of the oracle java package (I think this is a problem inside the 
runtime12.jar).

The problem is resolved using the java library released with Oracle 
9.2.0.4. I have upgraded both the runtime12.jar and the jdbc library 
(classes_12.jar and nls_charset.jar).

 From my past esperience with Oracle library I remember that new java 
library were released with Oracle 9.0.1.4, but now I can't do more 
testing.

Regards,
	Francesco