Hello, Looking at the lokahi status page, it appears that they do plan to include MySQL support. http://svn.apache.org/repos/asf/incubator/lokahi/lokahi/trunk/STATUS Also, the org.apache.lokahi.core.common.database.[Derby|Oracle]Broker classes do appear to hide the specifics of a database. By creating a new broker object, it looks like the user will be able to work with different types of dbs without having to worry about their differences. As far as the hard coded references to Oracle in the classes you mentioned, I can only assume that these will be removed (or modified) when the integration of MySQL support takes place.
-Jeff -----Original Message----- From: Ludovic Maitre [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 7:08 AM To: [email protected] Subject: MySQL support ? Hi all, I'm very interested in Lokahi, and i don't know of other OSS alternatives which fit my needs like it, but unfortunately i haven't Oracle or an Oracle license, so i would like to use MySQL with Lokahi. I have ported the tables.sql, procedures.sql, views.sql files to MySQL 5.1, but i cannot port the functions because they use a REF CURSOR as return value, and this is only supported by Oracle AFAIK (i guess i can deal with the types defined in packages.sql, these are not supported obviously in MySQL but this can be tackled at a higher level (java code)). So i have began to dig into the code of Lokahi and i see some hardcoded references to Oracle in org.apache.lokahi.core.controller.AdminBean. Before hacking this file (and the other ones which will exhibit the problem) so it doesn't use a sql function which return cursors, i would like to know what are the plans regarding the support of other dbs than Oracle (well there is a support for Derby that i haven't tested but i focus on MySQL and would like to help develop to support it -> i'm wondering if the derby support is functional even with the references to OracleTypes in Adminbean?), because perhaps you have already defined something. For instance, are the classes org.apache.lokahi.core.common.database.[Derby|Oracle]Broker designed to hide the databases particularisms ? Are you planning to use an existing ORM framework in the future so you will not have to support yourself the db part for each server ? (My personal preference go to OJB, but any framework would be interesting (hibernate...)) If this is the case have you a preliminar design ? So i would appreciate any answer/hint/link to documentation/..., and i apologize in advance if the post is too long, Thanks in advance and have a good day, PS: Is the JIRA functional ? I haven't investigated but when i click on the link on the lokahi website JIRA say "Project not found". -- Cordialement, Ludo - http://www.ubik-products.com --- "L'amour pour principe et l'ordre pour base; le progres pour but" (A.Comte) ------------------------------------------------------------------------------ Notice: This e-mail message, together with any attachments, contains information of Merck & Co., Inc. (One Merck Drive, Whitehouse Station, New Jersey, USA 08889), and/or its affiliates (which may be known outside the United States as Merck Frosst, Merck Sharp & Dohme or MSD and in Japan, as Banyu - direct contact information for affiliates is available at http://www.merck.com/contact/contacts.html) that may be confidential, proprietary copyrighted and/or legally privileged. It is intended solely for the use of the individual or entity named on this message. If you are not the intended recipient, and have received this message in error, please notify us immediately by reply e-mail and then delete it from your system. ------------------------------------------------------------------------------
