0 Replies Latest reply: Jun 8, 2010 4:12 AM by sto RSS

    Viewing Collected JDBC Profile data

    sto
      I'm using WLS 10.3.2 on Linux.

      I enabled "Profile Connection Usage" and "Profile Connection Leak" on my data source.

      When I view the EventsDataArcihve from WLS Console, or if I export the collected data via exportDiagnosticDataFromServer(logicalName="EventsDataArchive", exportFileName="myExport.xml"), I can see the events but not the details

      I only see something like this:
      <DataRecord><ColumnData>104</ColumnData><ColumnData>1271807805791</ColumnData><ColumnData></ColumnData><ColumnData></ColumnData><ColumnData>&lt;WLS Kernel&gt;</ColumnData><ColumnData>WEBLOGIC.JDBC.CONN.USAGE</ColumnData><ColumnData>DefaultDomain</ColumnData><ColumnData>DefaultServer</ColumnData><ColumnData></ColumnData><ColumnData></ColumnData><ColumnData></ColumnData><ColumnData></ColumnData><ColumnData>0</ColumnData><ColumnData></ColumnData><ColumnData></ColumnData><ColumnData></ColumnData><ColumnData></ColumnData><ColumnData></ColumnData><ColumnData>weblogic.jdbc.extensions.ProfileDataRecord@14bde07</ColumnData><ColumnData></ColumnData><ColumnData>0</ColumnData><ColumnData>[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'</ColumnData></DataRecord>

      How do I actually see the details of the ProfileDataRecord (e.g pool name, actual stack trace)?

      If I do "strings myExport.xml" I can see the stacks collected, but there must be a better way, right?