Debug SQL query / JDBC troubleshooting for Autosys Web Server (AEWS)
Article ID: 226077
Updated On:
Products
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
@
Feedback
