On 3/2/15 10:45 PM, BalNagendra wrote:
Dear All,
I am having the following problem:
Derby is good but functions which are available for database are not many.
I wanted to dump a character of its Hex value, there was no function. I had
to write a Java Program to do the same. It is a tedious process of loading
the function JAR to database and they create a database mapping to it.
Java has rich set of functions under Math, IO and UTIL libraries. Is there
any way to use them as Derby Library. I was trying to avoid mapping each of
these functions to Derby functions.
Thanks and regards
--
View this message in context:
http://apache-database.10148.n7.nabble.com/Derby-How-to-enrich-database-functions-with-Java-Library-tp143832.html
Sent from the Apache Derby Developers mailing list archive at Nabble.com.
This is an interesting problem. Take a look at the code which implements
the databaseMetaData optional tool:
http://db.apache.org/derby/docs/10.11/tools/rtoolsoptdbmetadata.html
That code introspects a Java interface and declares functions and table
functions for all of the methods in the interface.
You may hit some speed bumps with methods which take Object parameters.
But, provided that those Objects implement Serializable, you should be
able to declare user-defined types for them.
Hope this helps,
-Rick
