[NETBEANS-3318] NoClassDefFoundError: java/sql/Date when trying to profile sql queries

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 11.1
• Component/s: profiler - Engine
• Assignee: Unassigned
• Reporter: Eric Francis
• Created: 31/Oct/19 15:46
• Updated: 31/Oct/19 19:41

Description

I'm trying to profile an application running in Tomcat 7.0.91 using Java 11 (11.0.4).  When I attach the profiler to the application and certain sql queries are run I end up with a stacktrace like the following:

 

java.lang.NoClassDefFoundError: java/sql/Date
         org.netbeans.lib.profiler.server.ProfilerRuntimeCPU.converToString(ProfilerRuntimeCPU.java:768)
         org.netbeans.lib.profiler.server.ProfilerRuntimeCPU.addParameter(ProfilerRuntimeCPU.java:663)
         org.apache.commons.dbcp2.DelegatingPreparedStatement.setDate(DelegatingPreparedStatement.java:378)
         io.tekniq.jdbc.TqConnectionExtKt.applyParams(TqConnectionExt.kt:80)
... <snip additional lines of application code>

 

A similar issue was reported in VisualVM: https://github.com/oracle/visualvm/issues/123. They fixed the issue on their end, but it looks like the same fix needs to be made for Netbeans' profiler: https://github.com/apache/netbeans/blob/master/profiler/lib.profiler/src/org/netbeans/lib/profiler/server/ProfilerRuntimeCPU.java#L761