You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Daniel John Debrunner (JIRA)" <de...@db.apache.org> on 2006/04/13 17:12:11 UTC
[jira] Commented: (DERBY-1212) Problem in calling a function !!
[ http://issues.apache.org/jira/browse/DERBY-1212?page=comments#action_12374351 ]
Daniel John Debrunner commented on DERBY-1212:
----------------------------------------------
It is best to ask these type of questions on derby-user before entering a Jira entry. Jira entries are for bugs and feature requests, not questions.
Does this information help you?
http://wiki.apache.org/db-derby/DerbySQLroutines
> 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