From: hal.hildebrand at me.com (Hal Hildebrand) Date: Thu, 01 Nov 2012 05:03:41 -0700 Subject: [Pljava-dev] unable to invoke sample pljava program. In-Reply-To: References: Message-ID: <2F817EC8-493F-4942-A6E0-159BF2F632EA@me.com> You need to add the parameter type to the java signature in the definition. Sent from my Tricorder On Oct 31, 2012, at 9:56 PM, "Nalamothu, Bhaskar" wrote: > Dear Dev Team, > > i am beginner for pljava. i am struggling a lot to invoke a simple pljava program. > > i have done the following things successfully. > > 1.Sample java class which is having a static method as follows > > public static String hello(String hello){ > return hello; > } > > 2.Installed the jar > > SELECT sqlj.install_jar('file:///D:/Program Files/PostgreSQL/9.1/lib/PLJAVA_Custom.jar', 'PLJAVA_Custom', true); > > jar is loaded into jar_repository table of sqlj schema and also classes are identified and loaded into jar_entry table of sqlj Schema, > > 3. Set the Classpath successfully > > SELECT sqlj.set_classpath('public', 'PLJAVA_Custom'); > > 4. I have created a sample function as follows > > CREATE OR REPLACE FUNCTION handle_data2(character varying) > RETURNS character varying AS > 'pljavaone.DataHandler.hello' > LANGUAGE java VOLATILE > > when i am executing its returning me the following error ERROR: java.lang.ClassNotFoundException: pljavaone.DataHandler. > > Thanks in advance. > > -- > Sudha Bhaskar N > Procreate Techno Systems pvt ltd > +91-9948-678-222 > > _______________________________________________ > Pljava-dev mailing list > Pljava-dev at pgfoundry.org > http://pgfoundry.org/mailman/listinfo/pljava-dev -------------- next part -------------- An HTML attachment was scrubbed... URL: