Subject Re: [Firebird-Java] Re: Java trigger & SP future....
Author Juan Pedro López Sáez

where can I get some information about using UDF to call java code via JNI. I'm using Jaybird. I would improve my system's perfomance. Now I make a poll in orden to know whether something has happened in my db.

Another question related: is there any way to use Firebird Database Events with Jaybird. It could be other possible solution for my problem.

Thank you.
Juan Pedro
> Is there anyway to implement it outside FB ? since there's no plan
> to from FB... :-(   because I really need this features... at least
> I not need to rewrite my SP and triggers....

Can you explain, what you are going to achieve?

It is not possible to call Java code from within a database server,
unless you create User Defined Functions (UDFs) that in turn will
call your Java code via JNI. But even having your Java code
accessible via JNI, you will need to write wrappers in PSQL.

But please explain your usage of Java in database. Maybe there is a
possibility to achieve what you want in other way.

Also you might consider using JDataStore (not free, not open source,
but if you need Java triggers and SP, might be a good choice; till
recently license costed $1,000 for server with 10 users, or $100 for
an embedded version).

Best regards,
Roman Rokytskyy

Yahoo! Groups Sponsor

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to the
Yahoo! Terms of Service.