Subject Re: firebird stored procedure for calling java program.
Author hanif.sayyad
Hi,
when i tried to download the Firebird 3.0 server,i am getting the below error.

Not Found

The requested URL /downloads/rabbits/asfernandes/fbjava/fbjava-m1.zip was not found on this server.
Apache/2.2.3 (CentOS) Server at www.firebirdsql.org Port 80

please guide me.

Thanks & Regards,
Hanif

--- In Firebird-Java@yahoogroups.com, "Mark Rotteveel" <Avalanche1979@...> wrote:
>
> > Hi Evgeny Putilin,
> >
> > Thanks for reply. I want to call java program from stored
> > prcedure or trigger. I am using firebird 2.1.3, is this alpha version? if yes
> > then can you please guide me with example.
>
> No Firebird 2.1.3 is the latest release version. The FB/Java plugin only works in Firebird 3.0, an experimental version, including a 32 bit Firebird 3.0 server is available at http://www.firebirdsql.org/index.php?op=devel&sub=plugins&id=external_java
>
> This is very experimental, so don't use it for production work. Questions should most likely be addressed to the firebird-devel mailinglist.
>
> Mark
>
> >
> > CREATE PROCEDURE add_emp (
> > senderid NUMBER, recepientno NUMBER, mes VARCHAR2)
> > AS LANGUAGE JAVA
> > NAME 'DBTrigger.addEmp(int, int, java.lang.String)';
> >
> > when i am executing this query getting below error.
> >
> > Engine Error (code = 335544569):
> > Dynamic SQL Error.
> > SQL error code = -104.
> > Token unknown - line 3, column 4.
> > LANGUAGE.
> >
> > SQL Error (code = -104):
> > Invalid token.
> >
> > Please guide me.
>
> This functionality is not available in Firebird 2.1.3
> --
> GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
> Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01
>