Thread: java.lang.ClassNotFoundException: batchprint.Batch

java.lang.ClassNotFoundException: batchprint.Batch

From

Atul Kumar

Date:

07 January 2022, 21:21:23

Hi,

I have a function with below definition:

CREATE OR REPLACE FUNCTION onesam.batchprint_individual(
p1 character varying,
p2 character varying,
p3 character varying,
p4 boolean,
p5 boolean,
p6 character varying,
p7 integer,
p8 integer)
RETURNS integer
LANGUAGE 'javau'
COST 100
VOLATILE PARALLEL UNSAFE
AS $BODY$
batchprint.Batch.individual(java.lang.String, java.lang.String, java.lang.String, java.lang.Boolean, java.lang.Boolean, java.lang.String, java.lang.Integer, java.lang.Integer)
$BODY$;

And I am trying to execute below query:

SELECT batchprint_INDIVIDUAL(
'96674538',
'',
'',
't',
'f',
'UsysOfficial',
'1103003',
'1020')

and the ERROR I am getting is:

ERROR: java.lang.ClassNotFoundException: batchprint.Batch SQL state: XX000

My postgres version is 11.14.

Could anyone suggest any kind of solution for it, as I couldn't find anything informative from a database perspective.

Regards,

Atul

Re: java.lang.ClassNotFoundException: batchprint.Batch

From

Rob Sargent

Date:

07 January 2022, 21:27:44

'1103003',
'1020')

and the ERROR I am getting is:
ERROR: java.lang.ClassNotFoundException: batchprint.Batch SQL state: XX000

My postgres version is 11.14.

Could anyone suggest any kind of solution for it, as I couldn't find anything informative from a database perspective.

And your CLASSPATH is what exactly?

\! echo $CLASSPATH might show it

Regards,
Atul