Debug SQL query / JDBC troubleshooting for Autosys Web Server (AEWS)

book

Article ID: 226077

calendar_today

Updated On:

Products

CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

Autosys Web Server uses its own database connections using JDBC,  $AUTOUSER/webserver/webapps/AEWS/WEB-INF/lib/ojdbc8.jar  is the default jdbc module that we utilize for that.  This article documents the steps needed to enable SQL debug for AEWS

Resolution

For the JDBC connection pool for AEWS, it is being coded as part of EclipseLink libraries that we use.   $AUTOUSER/webserver/webapps/AEWS/META-INF/persistence.xml  could be tweaked with values like below. 

 

change the value: 

<property name="eclipselink.logging.level" value="WARNING" />

to

<property name="eclipselink.logging.level" value="FINE" />  

 

Save the file, restart the webserver

 

To undo the change flip the option back to WARNING like it was before the change, save, and restart the webserver again

 

$AUTOUSER/out/waae_webservices_wrapper.log now will have entries like this

 

INFO   | jvm 1    | 2021/10/13 14:16:47 | [EL Info]: 2021-10-13 14:16:47.736--ServerSession(1003738837)--Thread(Thread[AEConnMgr Monitor,5,main])--EclipseLink, version: Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd
INFO   | jvm 1    | 2021/10/13 14:16:47 | [EL Config]: connection: 2021-10-13 14:16:47.741--ServerSession(1003738837)--Connection(-1708284655)--Thread(Thread[AEConnMgr Monitor,5,main])--connecting(DatabaseLogin(
INFO   | jvm 1    | 2021/10/13 14:16:47 |       platform=>OracleExtensions
INFO   | jvm 1    | 2021/10/13 14:16:47 |       user name=> "AUTOSYSR12"
INFO   | jvm 1    | 2021/10/13 14:16:47 |       datasource URL=> "jdbc:oracle:thin:@AUTOSYSR12"
INFO   | jvm 1    | 2021/10/13 14:16:47 | ))
INFO   | jvm 1    | 2021/10/13 14:16:48 | [EL Config]: connection: 2021-10-13 14:16:48.156--ServerSession(1003738837)--Connection(523286611)--Thread(Thread[AEConnMgr Monitor,5,main])--Connected: jdbc:oracle:thin:@AUTOSYSR12
INFO   | jvm 1    | 2021/10/13 14:16:48 |       User: AUTOSYSR12
INFO   | jvm 1    | 2021/10/13 14:16:48 |       Database: Oracle  Version: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
INFO   | jvm 1    | 2021/10/13 14:16:48 |       Driver: Oracle JDBC driver  Version: 12.2.0.1.0
@