[jira] Closed: (DERBY-1212) Problem in calling a function !!

["Andrew McIntyre (JIRA)" <de...@db.apache.org>]

     [ http://issues.apache.org/jira/browse/DERBY-1212?page=all ]
     
Andrew McIntyre closed DERBY-1212:
----------------------------------

    Resolution: Invalid

Closing this as Invalid because it is not a bug, it is a question.

Dheeraj, I see that you are subscribed to the derby-user list and have posted questions there. Please continue to direct questions to the derby-user list instead of filing JIRA issues. In general, it is a good idea to search the lists and the documentation for the answers to your questions before posting yours. It is often the case that a previous user has run into the problem you are hitting and there will be a workaround or resolution in the mail archives. Also, take a look at this page for more tips on using the mailing lists:

http://www.apache.org/dev/contrib-email-tips.html

> 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