From: | claudio(dot)sistemica at gmail(dot)com (Claudio Campos) |
---|---|
To: | |
Subject: | [Pljava-dev] Unable to find static method with signature (LJava/lang/String) |
Date: | 2010-07-15 16:36:22 |
Message-ID: | B6332BC2ECB94B18869D15561898A1B1@Workstation |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pljava-dev |
Hello,
I have the following error with pl/java and a java function that receive an
string as parameters:
select javatest.resultSetToken('HOLA MUNDO')
ERROR: Unable to find static method
org.postgresql.pljava.lucenetest.ResultSetToken.executeSelect with signature
(Ljava/lang/String;)Ljava/util/Iterator;
********** Error **********
ERROR: Unable to find static method
org.postgresql.pljava.lucenetest.ResultSetToken.executeSelect with signature
(Ljava/lang/String;)Ljava/util/Iterator;
SQL state: XX000
********** Error **********
follow the suggestions described here
(http://pgfoundry.org/pipermail/pljava-dev/2006/000714.html) but did not
work
could someone help me?
Thanks in advance,
Claudio Campos
********** SCRIPT POSGRESQL **********
select sqlj.remove_jar('lucenetest',true)
select sqlj.install_jar('file:///C:/Archivos de
programa/PostgreSQL/8.4/lib/lucenetest.jar' ,'lucenetest', true)
CREATE OR REPLACE FUNCTION javatest.resultSetToken(text)
RETURNS SETOF text
AS
'org.postgresql.pljava.lucenetest.ResultSetToken.executeSelect(java.lang.String)'
LANGUAGE 'java'
COST 100;
ALTER FUNCTION javatest.resultSetToken(text) OWNER TO postgres;
SELECT sqlj.set_classpath('javatest', 'lucenetest');
select javatest.resultSetToken('HOLA MUNDO')
********** JAVA FUNCTION **********
package org.postgresql.pljava.lucenetest;
import java.sql.ResultSet;
import java.sql.SQLException;
import org.apache.lucene.analysis.Analyzer;
import org.apache.lucene.analysis.TokenStream;
import org.apache.lucene.analysis.SimpleAnalyzer;
import java.io.StringReader;
import java.io.IOException;
import org.postgresql.pljava.ResultSetProvider;
public class ResultSetToken implements ResultSetProvider
{
private final java.lang.String m_string;
private TokenStream m_stream;
public static org.postgresql.pljava.ResultSetProvider
executeSelect(java.lang.String paramStr)
throws SQLException
{
return new ResultSetToken(paramStr);
}
From | Date | Subject | |
---|---|---|---|
Next Message | swaroop | 2010-07-17 08:11:14 | [Pljava-dev] PlJava for Postgres 8.4 |
Previous Message | Caleb Welton | 2010-07-12 20:47:27 | [Pljava-dev] pljava error logging levels |