On 3/1/07, James Mckenzie <[EMAIL PROTECTED]> wrote:
>Johan says: >Claiming the JDBC driver is unreliable is a bit strange. This same >JDBC driver is use d by WebObjects (Java) applications in production >environments. I hava also used other JDBC drivers very succesfully >against WebObjects applications: Oracle, MySQL. My first choice >therefore is to use JDBC. No reason to change a winning team, until >OpenOffice comes around. > There are known issues with the Apple version of Java. This is because Apple mangles Java for several reasons, mostly to deal with security holes that exist in the Java program that allow things to be done, like writing to/from system files. Apple does not allow this. So, JDBC programs will work with some programs that have worked around this and others will not. This is why I recommended using an Open Database Connectoer (ODBC) which is made for Mac. There are several open issues with JDBC connectivity with other databases (MySQL, MS SQL) that only exist on the Mac.
??? I have never heard of that. Could you point me to some documentation on that? I know that applets are not permitted to do so, which is standard procedure. I have run several java programs (ImageJ, VisualRoute, Limewire, Readerware) which are perfectly capable of reading and writing to the filesystem. Nothing special. Compile. Run. If you mean system files like /var/vm/swapfile, or /var/log/system.log, I think the normal permissions kick in: if the effective user has rights to write, he can do so. Otherwise bad luck. Perhaps it is the case that Open Office uses the applet interface, which would explain the failure to run. Even than, I would expect OpenOffice to abort the request gracefully, giving an error message and then continue, not to crash.
>If you could explain to me what, according to your insight, is the >problem, with the Apple JVM that prevents OpenOffice to make use of >this driver, I can compile the driver myself, and see if your >observations hold. Please do. I would be very interested if this works. You are the first to offer to build a Mac specific JDBC for any of the affected databases.
I will just compile Postgresql source on my machine, including JDBC, as per www.entropy.ch instructions. Nothing special. Just dump the driver in /Library/Java/Extensions, and that is it. I am only doing it as you are claiming that Apple does something special with java source code that other platforms do not do.
James McKenzie --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
-- Best Regards, Johan Henselmans --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
