From: stefano.bianchi at iskranet.net (stefano bianchi)
Date: Sun, 25 Feb 2007 18:39:00 +0100
Subject: [Pljava-dev] I: ERROR: Unable to find static method
Message-ID: <000401c75903$d5d1f830$0fc7a8c0@thinkstefano>

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