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
