How do I implement the new PERSISTENCE.LogLevel introduced in 12.1 Web Viewer Build 169 (RO96287)?

Document ID : KB000014523
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

How do I implement the new PERSISTENCE.LogLevel introduced in 12.1 Web Viewer Build 169 (RO96287)?

Answer:

The PTF RO96287 includes the added JDBC Logging in the Java Persistence Application that will offer you the ability to get more information for certain problems. The documentation on using the new logging follows.  

STEPS TO USE PERSISTENCE.LogLevel: 
1) Add in the WVProfile.properties file the following line in the 
"Database" section: 

PERSISTENCE.LogLevel= 

The output selections in order of granularity are: 

OFF, SEVERE, WARNING, INFO, FINE, FINER, FINEST, ALL 

2) The default is INFO as not a lot of output is generated in options 
before that. 

NOTE 1: If the new PERSISTENCE setting is not added in 
WVProfile.properties, the logging will default to “INFO”. 

NOTE 2: It is necessary to restart the Web Server to pick up any 
change to the WVProfile.properties file.