I have done:
- installed log4plsql to database (tested w autonomus transaction working fine :) but i can not use it in other database)
- modified classpath parameters according to O817 (.jar ~ .zip) in variable setup
- create a log4plqsl.jar (w. script makeJar.bat)
- modified connection string in log4plsql.xml
After executing startLog4JbackgroundProcess.bat
i got:
Microsoft(R) Windows NT(TM)
(C) Copyright 1985-1996 Microsoft Corp.
rem generique product
set LOG4PLSQL_HOME=c:\t2\Log4plsql
set ORACLE_HOME=E:\oracle\ora817
rem database user
set LOG_SID=orcl
set LOG_USER=migration
set LOG_PASSW_USER=migration
set OracleVersion=before9.2
rem set OracleVersion=9.2
rem system user only use for install. Please, remove this entry after install
set SYS_USER=sys
set SYS_PASSW_USER=sys
rem ---------------------------------------------------------------
rem only if you use log4j
rem ---------------------------------------------------------------
set JDK_HOME=c:\j2sdk1.4.2_04
set CLASSPATH=%LOG4PLSQL_HOME%\lib\log4plsql.jar;%CLASSPATH%
set CLASSPATH=%LOG4PLSQL_HOME%\lib\;%CLASSPATH%
set CLASSPATH=%LOG4PLSQL_HOME%\lib\log4j-1.2.8.jar;%CLASSPATH%
rem Oraclexmlparser
set CLASSPATH=%ORACLE_HOME%\lib\xmlparserv2.jar;%CLASSPATH%
set CLASSPATH=%ORACLE_HOME%\lib\xmlcomp.jar;%CLASSPATH%
rem OracleDriver
set CLASSPATH=%ORACLE_HOME%\jdbc\lib\classes12.zip;%CLASSPATH%
set CLASSPATH=%ORACLE_HOME%\jdbc\lib\nls_charset12.zip;%CLASSPATH%
rem set CLASSPATH=%ORACLE_HOME%\sqlj\lib\runtime12.jar;%CLASSPATH%
set CLASSPATH=%ORACLE_HOME%\sqlj\lib\runtime12.zip;%CLASSPATH%
rem for SMTPAppender
set CLASSPATH=%JDK_HOME%\..\jre\lib\ext\mail.jar;%CLASSPATH%
set CLASSPATH=%JDK_HOME%\..\jre\lib\ext\activation.jar;%CLASSPATH%
set LOG4PLSQL_API=%LOG4PLSQL_HOME%\Docs\api
set LOG4PLSQL_SQLDOC=%LOG4PLSQL_HOME%\Docs\sql
rem set PLDOC_HOME=E:\GGM\perso\log4plsql\pldoc-0.6.8
set PATH=%PATH%;%JDK_HOME%\bin
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi Laci,
Try compiling the ReaderLogDatabase.sqlj using sqlj available with Oracle 8.1.7.4.1
and copy those classes instead of the one we get originally with the package in the dir ..\lib\log4plsql\backgroundProcess.
It seems the classes which are in the log4plsql package are generated with Oracle sqlj 9.2.0 and when we compiled it with our Oracle sqlj version(in our case its 9.0.1), we got two extra classes.
Ritu Kohli
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I was not able to get running Log4plsql thrue Log4JBackgroundProcess.
Database Oracle 8.1.7.4.1
On WinNT 4.0 SP6
Java J2SDK1.4.2_04
Log4plsql 3.1.2
I have done:
- installed log4plsql to database (tested w autonomus transaction working fine :) but i can not use it in other database)
- modified classpath parameters according to O817 (.jar ~ .zip) in variable setup
- create a log4plqsl.jar (w. script makeJar.bat)
- modified connection string in log4plsql.xml
After executing startLog4JbackgroundProcess.bat
i got:
Microsoft(R) Windows NT(TM)
(C) Copyright 1985-1996 Microsoft Corp.
c:\t2\Log4plsql\cmd>startLog4JbackgroundProcess.bat
c:\t2\Log4plsql\cmd>setlocal
c:\t2\Log4plsql\cmd>call setVariable.bat
variable setup
2004-06-08 15:52:55,181 INFO [main] backgroundProcess ( Run.java:62) -
start log4plsql.properties: .\properties\log4plsql.xml
2004-06-08 15:52:57,495 INFO [main] backgroundProcess.ReaderLogDataBase (Reader
LogDataBase.sqlj:83) - Startup logSource:logSource1 dbURI:jdbc:oracle:thin:@
127.0.0.1:1521:orcl dbUser:migration dbPass:migration pipeName:LOG_PIPE_gm
Exception in thread "main" java.lang.NoSuchMethodError: sqlj.runtime.ExecutionCo
ntext.getOracleContext()Lsqlj/runtime/ExecutionContext$OracleContext;
at log4plsql.backgroundProcess.ReaderLogDataBase._$3214(ReaderLogDataBas
e.sqlj:90)
at log4plsql.backgroundProcess.ReaderLogDataBase.<init>(ReaderLogDataBas
e.sqlj:69)
at log4plsql.backgroundProcess.ReaderThread.<init>(ReaderThread.java:41)
at log4plsql.backgroundProcess.Run.main(Run.java:80)
Taste drcken, um fortzusetzen . . .
C:\t2\Log4plsql\cmd>
in log file i got:
2004-06-08 15:52:57,495 INFO (backgroundProcess.ReaderLogDataBase) - Startup logSource:logSource1 dbURI:jdbc:oracle:thin:@127.0.0.1:1521:orcl dbUser:migration dbPass:migration pipeName:LOG_PIPE_gm []
I' not wery familiar with java, could someone help me please, what can be a problem.
Thanks a lot...
Laci
See http://sourceforge.net/forum/message.php?msg_id=2474384
Manuel Romeiro
Thaks, i already checked the settings for the classpaths - seems to be ok xmlparserv2.jar is also present. Have some other idea?
Thanks
Laci
Here are my enviroment settings:
@@echo off
echo variable setup
rem generique product
set LOG4PLSQL_HOME=c:\t2\Log4plsql
set ORACLE_HOME=E:\oracle\ora817
rem database user
set LOG_SID=orcl
set LOG_USER=migration
set LOG_PASSW_USER=migration
set OracleVersion=before9.2
rem set OracleVersion=9.2
rem system user only use for install. Please, remove this entry after install
set SYS_USER=sys
set SYS_PASSW_USER=sys
rem ---------------------------------------------------------------
rem only if you use log4j
rem ---------------------------------------------------------------
set JDK_HOME=c:\j2sdk1.4.2_04
set CLASSPATH=%LOG4PLSQL_HOME%\lib\log4plsql.jar;%CLASSPATH%
set CLASSPATH=%LOG4PLSQL_HOME%\lib\;%CLASSPATH%
set CLASSPATH=%LOG4PLSQL_HOME%\lib\log4j-1.2.8.jar;%CLASSPATH%
rem Oraclexmlparser
set CLASSPATH=%ORACLE_HOME%\lib\xmlparserv2.jar;%CLASSPATH%
set CLASSPATH=%ORACLE_HOME%\lib\xmlcomp.jar;%CLASSPATH%
rem OracleDriver
set CLASSPATH=%ORACLE_HOME%\jdbc\lib\classes12.zip;%CLASSPATH%
set CLASSPATH=%ORACLE_HOME%\jdbc\lib\nls_charset12.zip;%CLASSPATH%
rem set CLASSPATH=%ORACLE_HOME%\sqlj\lib\runtime12.jar;%CLASSPATH%
set CLASSPATH=%ORACLE_HOME%\sqlj\lib\runtime12.zip;%CLASSPATH%
rem for SMTPAppender
set CLASSPATH=%JDK_HOME%\..\jre\lib\ext\mail.jar;%CLASSPATH%
set CLASSPATH=%JDK_HOME%\..\jre\lib\ext\activation.jar;%CLASSPATH%
set LOG4PLSQL_API=%LOG4PLSQL_HOME%\Docs\api
set LOG4PLSQL_SQLDOC=%LOG4PLSQL_HOME%\Docs\sql
rem set PLDOC_HOME=E:\GGM\perso\log4plsql\pldoc-0.6.8
set PATH=%PATH%;%JDK_HOME%\bin
The xmlparserv2.jar file is present, but probably isnt up to date.
Try update it from:
http://otn.oracle.com/software/tech/java/sqlj_jdbc/index.html
Manuel Romeiro
Hi Laci,
Try compiling the ReaderLogDatabase.sqlj using sqlj available with Oracle 8.1.7.4.1
and copy those classes instead of the one we get originally with the package in the dir ..\lib\log4plsql\backgroundProcess.
It seems the classes which are in the log4plsql package are generated with Oracle sqlj 9.2.0 and when we compiled it with our Oracle sqlj version(in our case its 9.0.1), we got two extra classes.
Ritu Kohli