Java method not found running on oracle database

Question

I have can not deal with execute my java method on oracle server. I load my java class on database using loadjava and create function using this query:

create or replace function getPeriodIdDay (multiplicity number, stardDate date, endDate date) return number
as language java
name 'Period.getPeriodIdDay(int, oracle.sql.Date, oracle.sql.Date) return int';

My method in class is:

  public static int getPeriodIdDay(int multiplicity, DATE startDate, DATE date){
       // day period calculation
       int dayPeriodId =  (date.dateValue().getTime() - startDate.dateValue().getTime()) / MILLIS_IN_DAY;
       return dayPeriodId / multiplicity;
   }

Each time when try to execute this function I have get this error:

29531. 00000 -  "no method %s in class %s"
*Cause:    An attempt was made to execute a non-existent method in a
           Java class.
*Action:   Adjust the call or create the specified method.

What am I doing wrong?

Timothy Truckle · Accepted Answer · 2017-01-11 11:31:33Z

3

The signature of the java method in your function declaration is:

Period.getPeriodIdDay(int, oracle.sql.Date, oracle.sql.Date) return int

but the signatur of the metho in the java class itself is:

int getPeriodIdDay(int multiplicity, DATE startDate, DATE date)

If the capitalisation of DATE is no mistake when copying it here then this is a different type.

And even if it is a copy mistake: check with the imports of the java class that the same Date class is used.

answered Jan 11, 2017 at 11:31

Timothy Truckle

15.7k2 gold badges31 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ice Over a year ago

Yep, u have right i should use DATE insted of Date.

hmmftg · Accepted Answer · 2017-01-11 12:10:24Z

1

the problem seems to be the DATE class, I suggest you to use String instead

You better change your method class like this:

CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED JTESTDATE AS 
import java.text.SimpleDateFormat;
import java.util.Date;

public class TestDate {
    public static int getDate(int multiplicity, String startDate,
            String endDate) {
        SimpleDateFormat sf = new SimpleDateFormat();
        sf.applyPattern("yyyymmdd");//You Have to specify format here
        Date sd;
        try {
            sd = sf.parse(startDate);
        } catch (Exception e) {
            return -1;
        }
        Date ed;
        try {
            ed = sf.parse(endDate);
        } catch (Exception e) {
            return -2;
        }
        long dayPeriodId = (ed.getTime() - sd.getTime()) / 24 * 60 * 60;//this is replaced with your code
        return (int) (dayPeriodId / multiplicity);
    }
}

edited Jan 11, 2017 at 12:10

answered Jan 11, 2017 at 11:12

hmmftg

1,8501 gold badge25 silver badges38 bronze badges

1 Comment

Ice Over a year ago

Sorry, that was mistake, function name in oracle and java are the same.

Collectives™ on Stack Overflow

Java method not found running on oracle database

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related