db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dheeraj Dhiman (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-1212) Problem in calling a function !!
Date Thu, 13 Apr 2006 12:54:59 GMT
Problem in calling a function !!
--------------------------------

         Key: DERBY-1212
         URL: http://issues.apache.org/jira/browse/DERBY-1212
     Project: Derby
        Type: Bug

    Versions: 10.0.2.0    
 Environment: embedded driver 
    Reporter: Dheeraj Dhiman
    Priority: Blocker


I want to know about how to call a function !!

My case is ::

I have create a function like this ;

create function result(id bigint) returns varchar(34) PARAMETER STYLE JAVA NO SQL LANGUAGE
JAVA EXTERNAL NAME 'testderby.function.result';

class function{
public static String result(long id){
 connection conn;
Statemnt stmt ;
stmt = conn.createstatement();
ResultSet rs = stmt.excuteQuery("select col1 from tablename");
while(rs.next()){
String str=  rs.getString(1);
System.out.println(str);
}
}
}


so now how can i call this function from ij > prompt !!
or from any main function of a class !!


Pls give respose as early as possible !!



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message