Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Stored Procedures, Triggers and Functions in Java [CORE816] #1202

Closed
firebird-automations opened this issue Mar 8, 2004 · 10 comments
Closed

Stored Procedures, Triggers and Functions in Java [CORE816] #1202

firebird-automations opened this issue Mar 8, 2004 · 10 comments
Assignees
@asfernandes
Labels
component: udf fix-version: 3.0 Alpha 1 priority: major type: new feature

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: fpeinado (fpeinado)

Is related to QA624

Votes: 9

SFID: 912251#⁠
Submitted By: fpeinado

I want suggest you to be able to create UDF that points
to a JavaBean Class.

A JavaBean Class is a Java class that points to it??s
properties as funcions of type get / set (Getter??s and
Setter??s) for sample:

public class TestUDF {
private int code;
private String description;

public void setCode\(int value\) \{
    code = value;
\}
public int getCode\(\) \{
    return code;
\}
public void setDescription\(String value\) \{
    description = value;
\}
public String getDescription\(\) \{
    return description;
\}

public boolean doSomeThing\( String Arg1, int Arg2 \) \{
    \.\.\.\. // Some Stuff
\}

}

The UDF of JavaBean above can be:

TestUDF_doSomeThing( CString Arg1, INTEGER Arg2 );
@firebird-automations
Copy link
Collaborator Author

Commented by: Alice F. Bird (firebirds)

Date: 2005-05-30 16:50
Sender: dimitr
Logged In: YES
user_id=61270

Already prototyped, although a bit differently.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0 [ 10048 ]

SF_ID: 912251 =>

@firebird-automations
Copy link
Collaborator Author

Commented by: Roman Rokytskyy (rrokytskyy)

There will be a general Java support in next major version of Firebird. Currently the code is used in Fyracle, but it will be refactored before committing to the main tree.

Firebird will support both UDFs and stored procedures written at least in Java, but since the framework is open, other implementations like C#⁠ and Delphi will be possible (former is also available in Fyracle). The Java part will support the de-facto standard SQLJ Level 1. This gives a possibility to call any public static Java method from within SQL, pass parameters and return values back. It is also possible to perform loopback connection within the Java method using "jdbc:default:connection" URL. As an extension we will support selectable stored procedures that will return java.sql.ResultSet implementation.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 10840 ] => Firebird [ 15280 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Roman Rokytskyy [ rrokytskyy ] => Adriano dos Santos Fernandes [ asfernandes ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0 Alpha 1 [ 10331 ]

Fix Version: 3.0.0 [ 10048 ] =>

@firebird-automations
Copy link
Collaborator Author

Commented by: Ivan (patuljak)

if UDF writing in Java or C#⁠ (in language which is on virtual machine) then query with this UDF is slower.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

summary: UDF in Java => Stored Procedures, Triggers and Functions in Java

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA624 [ QA624 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@asfernandes asfernandes

Labels
component: udf fix-version: 3.0 Alpha 1 priority: major type: new feature
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@asfernandes @firebird-automations