You can't invoke a table function which is stored in a jar file inside the database

• Key: DERBY-4126
• Type: Bug
• Status: Closed
• Resolution: Fixed
• Priority: Major
• Assignee: Rick Hillegas
• Reporter: Rick Hillegas
• Component/s: SQL
• Affects Version/s: 10.4.1.3, 10.4.2.0, 10.5.1.1, 10.6.0.0
• Fix Version/s: 10.4.2.1, 10.5.1.1, 10.6.0.0

Description

You get a ClassNotFoundException when you try to invoke a table function which lives in a jar file stored inside the database. This is because FromVTI.implementsDerbyStyleVTICosting() looks up the class using Class.forName() rather than using the session classloader. A similar bug is in FromVTI.getVTICosting(). This bug was reported by Krzysztof N in the following user list thread: http://www.nabble.com/Uinable-to-use-Table-function-due-to-java.lang.ClassNotFoundException--while-class-is-clearly-reachable..-td22478383.html#a22699492

Comments

[Rick Hillegas]

Attaching derby-4126-01-aa-useSessionClassloader.diff. This patch causes Derby to lookup VTI optimizer overrides using the session's classloader. This fixes the bug. I will run regression tests now.

Touches the following files:

M java/engine/org/apache/derby/impl/sql/compile/FromVTI.java

Use the session class loader when looking for optimizer overrides.


A java/testing/org/apache/derbyTesting/functionTests/tests/lang/dummy_vti.jar
M java/testing/org/apache/derbyTesting/functionTests/tests/lang/DatabaseClassLoadingTest.java

New test to verify that this fixes the problem.

[Rick Hillegas]

Attaching second rev of the patch. The regression tests turned up a follow-on problem: in order to determine if the VTI class implements VTICosting, we need to get the VTICosting class from the same classloader as the table function class. Running tests again...

[Rick Hillegas]

Tests ran cleanly for me except for the heisenbug in the stress-multi tests. Committed second rev of the patch at subversion revision 759360.

[Rick Hillegas]

Ported 759360 from main to 10.5 branch at subversion revision 759363.

[Rick Hillegas]

Ported 759360 from main to 10.4 branch at subversion revision 759978.

[Rick Hillegas]

Krzysztof, who reported this bug, says that the fix works for him. Closing this bug.