"User defined functions can be created with source code" in 1.2.124

Thomas Kellerer

unread,

Nov 20, 2009, 1:39:22 PM11/20/09

to H2 Database

Hi,

I have seen the new feature to add new function directly with Java
source code. Pretty cool feature.

Is there a way to retrieve the Java source somehow, or is that not
stored in the system tables?

I checked INFORMATION_SCHEMA.FUNCTION_ALIAS but as far as I can tell,
the source is not stored in there.

Regards
Thomas

Thomas Mueller

unread,

Nov 20, 2009, 5:14:13 PM11/20/09

to h2-da...@googlegroups.com

Hi,

> I have seen the new feature to add new function directly with Java
> source code. Pretty cool feature.

Unfortunately I forgot a critical part: the source code is not stored
in the database :-/ When you close the database, the function is lost.
Pretty embarrassing.

> I checked INFORMATION_SCHEMA.FUNCTION_ALIAS but as far as I can tell,
> the source is not stored in there.

You are right, I will have to add a column with the source code.

And more tests...

Regards,
Thomas

Thomas Kellerer

unread,

Nov 20, 2009, 5:50:56 PM11/20/09

to H2 Database

> > I checked INFORMATION_SCHEMA.FUNCTION_ALIAS but as far as I can tell,
> > the source is not stored in there.
>
> You are right, I will have to add a column with the source code.

I want to include the display of the source in SQL Workbench, that's
why I'm asking.

> And more tests...

:)

Thanks
Thoams

Reply all

Reply to author

Forward