CODEWITHSUNDEEP
javamysqlpluginsuser-defined-functions
Kaushik Shankar
Kaushik Shankar

Reputation: 5619

Problems setting up an SQL User-Defined Function in MySQL using the Java Language

I have had quite some difficulty trying to make a User Defined Function (UDF) in Java for my MySQL Server. I was hoping I could ask for some help on this subject.

Here is what I have done so far:

I have followed the instructions on a Planet MySQL post but I fear that it may be outdated, as the plugin files do not contain a psm_java.so file which was expected to exist in the tutorial.

I need to implement the Levenshtein distance in Java given two strings so that I can return that value back. I know how to do that part, but I have not been able to do the SQL interaction part.

Any help is MUCH appreciated.

System information:

Mac OS X 10.7.2 MySQL 5.5.16

Upvotes: 1

Views: 756

Answers (1)

Paul Sasik
Paul Sasik

Reputation: 81537

Why go outside the RDBMS? You can implement the Levenshtein distance in a MySQL UDF pretty easily.

Upvotes: 1

Related Questions