Also I face this issue only with ClientDataSource Driver. With Embedded driver it works fine. Do we need to set some short of class path to use context aware functions while using ClientDataSource Driver?
On Thu, Jun 25, 2015 at 11:44 AM, ankita savaliya <[email protected]> wrote: > Hi, > > Yes I wrote 'test.vti.VTITest which is public class. > > I am creating context aware function, > > "CREATE FUNCTION Fun1(applicationName VARCHAR(32672)) RETURNS TABLE (Col1 > BIGINT, col2 VARCHAR(32672), col3 VARCHAR(32672) ) LANGUAGE JAVA PARAMETER > STYLE derby_jdbc_result_set reads sql data EXTERNAL NAME > ''test.vti.VTITest'" > > "Create view Test_view as select * from table (Fun1('demoWS1')) > my_view" > > I checked derby.log but nothing is there related to this error. > > On Wed, Jun 24, 2015 at 7:06 PM, Bryan Pendleton < > [email protected]> wrote: > >> Caused by: java.sql.SQLSyntaxErrorException: The class 'test.vti.VTITest' >>> does not exist or is inaccessible. >>> >> >> Is this a class that you wrote? >> >> What is the "context aware function" that you are trying to create? >> >> Can you use the 'derby.log' on your Derby server to isolate the >> specific SQL statement that is failing? >> >> bryan >> >> >> >
