-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Jon Hancock wrote:
| Carlos Proal wrote: | | |>Hi, i have been using Lucene & MySQL but separately, MySQL is written |>in C/C++ with a JDBC driver available and Lucene is coded in Java, so |>(besides the mysql team opinion) you can mix searches throught both |>apis and referring to each other with the PrimaryKey. | | | Does anyone know if/how a JVM using Lucene could be used in the MySQL 5 | Stored Procedure architecture (or maybe as Functions in the 4.0 | architecture). If the architecture (MySQL 5) would allow for a | continuous running JVM with an entry point into the Java search code | then could you use Lucene code against the MySQL DB tables directly? | There are obvious places where too much data marshalling between C and | Java may make the solution too slow, but I would like to investigate the | possibilities. | thanks, Jon
Jon,
5.0 most likely won't ship with 'external' stored procedures. However, even today, it is straightforward to write user-defined functions in any language you wish. One of our employees has even posted a UDF which allows you to call any arbitrary Java code, so it should be pretty straightforward to automatically update your Lucene index and query it inside MySQL queries:
http://freshmeat.net/projects/judf/?topic_id=66
-Mark
- -- Mr. Mark Matthews MySQL AB, Software Development Manager, J2EE and Windows Platforms Office: +1 708 332 0507 www.mysql.com
MySQL Guide to Lower TCO http://www.mysql.com/it-resources/white-papers/tco.php -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFBCWD8tvXNTca6JD8RAsjoAJ0Z+z5Ac/LE8LI50OieQWb425jzegCfVONa 0wn9ay0mGKDvcfZ214oSZRU= =xqTw -----END PGP SIGNATURE-----
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
