Article - CS342771
SQL Server JDBC driver debugging performance issues in Windchill
Modified: 14-Apr-2021
Applies To
- Windchill PDMLink 10.0 to 12.0
- Microsoft SQL Server
Description
- All database activity taking longer than expected
- Perftables show a large amount of time unaccounted for in each db related method context
- All db related stack traces show java.util.logging.Logger lines similar to the following:
- at java.io.FileOutputStream.writeBytes(Native Method)
at java.io.FileOutputStream.write(FileOutputStream.java:326)
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
at java.util.logging.FileHandler$MeteredStream.flush(FileHandler.java:214)
at sun.nio.cs.StreamEncoder.implFlush(StreamEncoder.java:297)
at sun.nio.cs.StreamEncoder.flush(StreamEncoder.java:141)
at java.io.OutputStreamWriter.flush(OutputStreamWriter.java:229)
at java.util.logging.StreamHandler.flush(StreamHandler.java:259)
at java.util.logging.FileHandler.publish(FileHandler.java:702)
at java.util.logging.Logger.log(Logger.java:738)
at java.util.logging.Logger.doLog(Logger.java:765)
at java.util.logging.Logger.log(Logger.java:788)
at java.util.logging.Logger.finest(Logger.java:1542)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:41)
- at java.io.FileOutputStream.writeBytes(Native Method)
- The method server logs do not show any verbose debug logging
This is a printer-friendly version of Article 342771 and may be out of date. For the latest version click CS342771