PL/Java problem.
От | Scott Petersen |
---|---|
Тема | PL/Java problem. |
Дата | |
Msg-id | 44FF298D.3050000@softhome.net обсуждение исходный текст |
Ответы |
Re: PL/Java problem.
|
Список | pgsql-jdbc |
Greetings, Before I start I must admit that I am a newbie to Java. This means that this might actually be my problem and NOT a software issue, but I need help. I am attempting to execute the "Hello World" demo from http://wiki.tada.se/wiki/display/pljava/User+Guide which is part of the user guide for the software. In the process I created the following class, and compiled (JAR) with NO errors: package com.mycompany.helloworld; public HelloWorld { public String helloWorld() { return "Hello World"; } } Next I ran psql with the following result: #psql -U mfgadmin mlp204 Password for user mfgadmin: Welcome to psql 8.1.3, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit Warning: Console code page (437) differs from Windows code page (1252) 8-bit characters may not work correctly. See psql reference page "Notes for Windows users" for details. mlp204=# select sqlj.install_jar('file:///Java source/helloworld.jar', 'hellowor ld_jar', false); install_jar ------------- (1 row) mlp204=# select sqlj.set_classpath('public', 'helloworld_jar'); set_classpath --------------- (1 row) mlp204=# CREATE OR REPLACE FUNCTION helloworld() mlp204-# RETURNS "varchar" AS mlp204-# 'com.mycompany.helloworld.HelloWorld.helloWorld' mlp204-# LANGUAGE 'java' VOLATILE; CREATE FUNCTION mlp204=# select * from helloworld(); ERROR: java.lang.ClassNotFoundException: com.mycompany.helloworld.HelloWorld mlp204=# Everything seems to be working fine except I receive a "ClassNotFoundException". Any help in understanding what I did wrong would be appreciated. Thanks Scott.
В списке pgsql-jdbc по дате отправления: