[DERBY-4126] You can't invoke a table function which is stored in a jar file inside the database

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.4.1.3, 10.4.2.0, 10.5.1.1, 10.6.1.0
• Fix Version/s: 10.4.2.1, 10.5.1.1, 10.6.1.0
• Component/s: SQL
• Assignee: Richard N. Hillegas
• Reporter: Richard N. Hillegas
• Created: 27/Mar/09 13:56
• Updated: 13/Apr/09 23:05
• Resolved: 31/Mar/09 16:49

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

Issue Links

• is related to: DERBY-4133 'testTableFunctionInJar' fails w/ 'The class 'DummyVTI' does not exist or is inaccessible...' on jvm1.4
• relates to: DERBY-4131 test failure in lang.DatabaseClassLoadingTest.testTableFunctionInJar