[Pljava-dev] I: ERROR: Unable to find static method

stefano bianchi stefano.bianchi at iskranet.net
Sun Feb 25 17:39:00 UTC 2007


Hi,

I'm try to load a class on db, but something go wrong.

net.gesttec.gbedidi.storedP.yate.ldapGetSeatInfo.searchSeatPass with
signature (Ljava/lang/String;)Ljava/lang/String;

My class :

package net.gesttec.gbedidi.storedP.yate; public class ldapGetSeatInfo {

	public static java.lang.String searchSeatPass( 
			java.lang.String seatId
			) throws SQLException {
			String gkPassS = "-";
	<..snip>
		return gkPassS;
	}

...


Etc

I loat it 

SELECT * from sqlj.install_jar('file:///temp/SPyate.jar', 'SPYATE_jar',
false); SELECT sqlj.set_classpath('public','SPYATE_jar');

CREATE OR REPLACE FUNCTION user_check(character varying)
  RETURNS character varying AS
'net.gesttec.gbedidi.storedP.yate.ldapGetSeatInfo.searchSeatPass(java.lang.S
tring)'
  LANGUAGE 'javaU' VOLATILE;


Butr when i call the function

select * from user_check('alllsoi'),
I got
ERROR: Unable to find static method
net.gesttec.gbedidi.storedP.yate.ldapGetSeatInfo.searchSeatPass with
signature (Ljava/lang/String;)Ljava/lang/String;
Stato SQL: XX000

Under winXP

Please note, in the same jar, a different class work fine.

PS
Since in this week eclipse IDE was update, now the pljava souce fail in
compile, I don't know if are you inform about.

By & thanks in advace


Stefano Bianchi






More information about the Pljava-dev mailing list