Found it. I defined the library using .class instead of .jar. Oops. On Mon, Apr 4, 2016 at 6:22 PM, Gunnar Tapper <tapper.gun...@gmail.com> wrote:
> Hi, > > This error is driving me batty. :) > > The SPJ information: > > [centos@trafodion trafodion-spjs]$ pwd > /home/centos/trafodion-spjs > [centos@trafodion trafodion-spjs]$ javap Payroll.class > Compiled from "Payroll.java" > public class Payroll { > public Payroll(); > public static void adjustSalary(java.math.BigDecimal, double, > java.math.BigDecimal[]) throws java.sql.SQLException; > public static void employeeJob(int, java.lang.Integer[]) throws > java.sql.SQLException; > public static void projectTeam(int, java.sql.ResultSet[]) throws > java.sql.SQLException; > public static void topSalesReps(int, java.sql.ResultSet[]) throws > java.sql.SQLException; > } > > So, I add the class to Trafodion as a library. > > [centos@trafodion trafodion-spjs]$ trafci > > Welcome to Apache Trafodion Command Interface > Copyright (c) 2015 Apache Software Foundation > > Host Name/IP Address: localhost:23400 > User Name: zz > > Connected to Trafodion > > SQL>create library trafodion.persnl.payroll file > '/home/centos/trafodion-spjs/Payroll.class'; > > --- SQL operation complete. > > SQL>get libraries in schema trafodion.persnl; > > PAYROLL > > --- SQL operation complete. > > Next, I try to create a procedure but Trafodion doesn't seem to see the > Payroll class in the library file. > > SQL>CREATE PROCEDURE trafodion.persnl.adjustsalary( IN empnum NUMERIC(4) > , IN percent FLOAT > , OUT newsalary NUMERIC(8,2) > ) > EXTERNAL NAME 'Payroll.adjustSalary' > LIBRARY trafodion.persnl.payroll > +>+>+>+>+> LANGUAGE JAVA > PARAMETER STYLE JAVA > MODIFIES SQL DATA > ; > +>+>+>+> > *** ERROR[11205] Java class 'Payroll' was not found in external path > '/home/centos/trafodion-spjs/Payroll.class'. [2016-04-05 00:16:46] > *** ERROR[1231] User-defined routine TRAFODION.PERSNL.ADJUSTSALARY could > not be created. [2016-04-05 00:16:46] > > SQL> > > What am I missing? > > Thanks, > > Gunnar > *If you think you can you can, if you think you can't you're right.* > -- Thanks, Gunnar *If you think you can you can, if you think you can't you're right.*