如何在内存中编写自定义函数HSQL [英] How to write custom functions for in memory HSQL

问题描述

我想在HSQL中编写一个简单的函数，以便它向后兼容DB2函数。理论上我应该能够在java中编写一个自定义函数并将其挂接到HSQL中。

解决方案

HSQLDB指南中记录了用户定义的功能。请参阅本部分以Java编写的功能。

http://hsqldb.org/doc/2.0/guide/sqlroutines-chapt.html#src_jrt_routines

你也可以在SQL中编写您的函数，这在指南的同一章中记录。

I want to write a simple function in HSQL so that it is backwards compatible with DB2 functions. In theory I should be able to write a custom function in java and hook it into HSQL. Is there any direction/documentation on just that?

解决方案

User defined functions are documented in the HSQLDB Guide. See this section for functions written in Java.

http://hsqldb.org/doc/2.0/guide/sqlroutines-chapt.html#src_jrt_routines

You can also write your functions in SQL, which is documented in the same chapter of the Guide.

这篇关于如何在内存中编写自定义函数HSQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！