[DERBY-5366] ClassNotFoundException when invoking a table function stored in a jar file in the database which extends or implements one of the classes/interfaces in org.apache.derby.vti

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 10.8.2.2
• Component/s: SQL
• Urgency: Normal
• Issue & fix info: Repro attached
• Bug behavior facts: Seen in production
• Assignee: Unassigned
• Reporter: Richard N. Hillegas
• Created: 01/Aug/11 20:25
• Updated: 25/Oct/11 17:09
• Resolved: 02/Aug/11 12:16

Description

The class loader created by setting the derby.database.classpath does not see the Derby classes. This means that you can't use table functions which implement VTITemplate if you store those functions in a jar file in the database and then wire that jar file into the database-specific classpath. I will attach a repro. This problem was reported by Brett Berqquist in an email thread titled "Problem in trying to get a Restricted Table Function loaded".

Issue Links

• duplicates: DERBY-5352 Derby table functions stored in a jar file inside the database which implement VTICosting or RestrictedVTI fail with ClassNotFoundException