Re: Java language procedure error:

The EXTRNAL NAME string needs to begin with CLASSPATH:

EXTERNAL NAME 
'CLASSPATH:com.bloodhound.sequence.embeded.test.StoredProc.mockNextBlock';

Fred

On Thu, Jun 13, 2013, at 17:05, keithaniz wrote:
> Hello Fred,
>  i've Java language procedure and i think there is everything correct but
> why it is giving such error:
> 
> Failed to execute goal org.codehaus.mojo:sql-maven-plugin:1.5:execute
> (create-db) on project embedded-nexxus-seq-procedure: user lacks
> privilege
> or object not found java.lang.ClassNotFoundException:
> com.bloodhound.sequence.embeded.test.StoredProc
> com.bloodhound.sequence.embeded.test.StoredProc in statement [
> [ERROR] CREATE PROCEDURE NEXXUS_GENERATOR_API_GETNEXTBLOCK (IN realmIn 
> VARCHAR(20),
> [ERROR] IN nameIn VARCHAR(20),
> [ERROR] IN deltaIn BIGINT ,
> [ERROR] OUT startIdOut BIGINT ,
> [ERROR] OUT endIdOut BIGINT)
> [ERROR] LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA
> [ERROR] EXTERNAL NAME
> 'com.bloodhound.sequence.embeded.test.StoredProc.mockNextBlock']
> create table "DUAL"(ID varchar(1));
> insert into DUAL values('1');
> 
> Procedure :
> CREATE PROCEDURE NEXXUS_GENERATOR_API_GETNEXTBLOCK (IN realmIn 
> VARCHAR(20),
>                         IN nameIn VARCHAR(20),
>                        IN deltaIn BIGINT ,
>                     OUT startIdOut BIGINT ,
>                    OUT endIdOut BIGINT)
> LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA 
> EXTERNAL NAME
> 'com.bloodhound.sequence.embeded.test.StoredProc.mockNextBlock';
> 
> Class:
> package com.bloodhound.sequence.embeded.test;
> 
> public class StoredProc {
> private static int seed = 0;
> 
> static Object lock = new Object();
> 
> @SuppressWarnings("unchecked")
> public static void mockNextBlock(String obj1, String obj2, long obj3,
> Long[] obj4, Long[] obj5) throws java.sql.SQLException {
> synchronized (lock) {
> obj4[0] = new Long(++seed);
> while (obj3-- > 0) {
> seed++;
> }
> obj5[0] = new Long(seed);
> }
> }
> }
> 
> 
> Please any suggestion!!!
> Thank you
> 
> 
> 
> 
> 
> --
> View this message in context:
> http://hsqldb.10974.n7.nabble.com/Java-language-procedure-error-tp3915.html
> Sent from the HSQLDB - User mailing list archive at Nabble.com.
> 
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by Windows:
> 
> Build for Windows Store.
> 
> http://p.sf.net/sfu/windows-dev2dev
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user

------------------------------------------------------------------------------
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev