Call a Script via JDBC

[rogermax]

In FM5 through 6 it was possible to call a script using JDBC with syntax like --

{CALL script_name(db_name)}

Can this still be done with FM8.5, and if so can we pass script parameters with it? I haven't found it in the documentation I have.

tx.

[ave!]

No, you cannot execute script via JDBC (or ODBC) with FM 7 or later.

FYI, FM PHP API seems to have a way to do this.

[rogermax]

Bummer, that would have worked swell. I will look into the php route. tx

[Jesse Barnum]

You can use the WooF JDBC driver (https://woof.dev.java.net) to call scripts as stored procedures. The driver is open source, and was written as a replacement for the JDBC driver that ships with FM 5.5 - 8.5.

[rogermax]

Thanks for the tip. I will look into that.