Apache OpenOffice (AOO) Bugzilla – Issue 14556
basic join impossible with ODBC and JDBC
Last modified: 2006-05-31 14:29:06 UTC
ugh! i have just spent 3 full days trying to get the OO spreadsheet to work like i need it to with mysql. i started on a fresh complete install of RedHat Linux 9 which includes OpenOffice 1.0.2. i got OpenOffice to work with MySql 2.50 and unixODBC without too much trouble. but then i tried to do a join like this: select COUNT(*) from bugs,versions group by bugs.reported_by This simple query worked fine using mysql, but in OpenOffice it returned COUNT(*) equal to 0 for every row. The following, similar query did work fine in OpenOffice: select COUNT(*) from bugs,versions where bugs.reported_by=22 I decided that I must be running into this bug: Error occurred during initialization of VM Unable to load native library: libjvm.so: cannot open shared object file: No such file or directory **************** Another exception has been detected while we were handling last error. Dumping information about last error: ERROR REPORT FILE = (N/A) PC = 0x0x40343088 SIGNAL = 11 FUNCTION NAME = _ZNK8SalFrame13GetSystemDataEv LIBRARY NAME = (N/A) Please check ERROR REPORT FILE for further information, if there is any. Good bye. Aborted http://www.openoffice.org/project/www/issues/show_bug.cgi?id=10479 So I tried to install MyODBC-3.51. This was a major pain. I was finally able to get it to install with iodbc and I was able to execute queries using odbctest. But then I couldn't get OpenOffice to find the driver (I assume OpenOffice doesn't work with iodbc?). So I tried to get MyODBC-3.51 to work with unixODBC. I never was able to get this to work. the MyODBC install file says that it requires the Alpha 3 version of unixODBC, but the only version I could find anywhere was 2.2.3-6. I finally gave up on ODBC and decided to try and get JDBC to work. The OpenOffice install that I have keeps telling me that java is not installed and I can't figure out how to change the configuration. If I run oosetup, the option to change the configuration is greyed out. I decided to install OpenOffice 1.0.3. This went without problems and I pointed it at my install of java 1.3.1_08. Then I tried to get the new install to work with JDBC and it crashed OpenOffice completely. I get the following error which I can't even begin to deal with. I'm going home! If you can give me any advice on how to make this work, I'd be most appreciative. Thanks! Eric Error occurred during initialization of VM Unable to load native library: libjvm.so: cannot open shared object file: No such file or directory **************** Another exception has been detected while we were handling last error. Dumping information about last error: ERROR REPORT FILE = (N/A) PC = 0x0x40343088 SIGNAL = 11 FUNCTION NAME = _ZNK8SalFrame13GetSystemDataEv LIBRARY NAME = (N/A) Please check ERROR REPORT FILE for further information, if there is any. Good bye. Aborted
Wrong component
krevice, we should focus on one problem per IssueZilla issue - let's take the "select count(*)..." problem here. (For the problems of setting up MySQL, I suggest users@dba.openoffice.org). Can you attach a mysqldump of the table in question - just to be sure that we're all talking about the same when we try to reproduce this. Perhaps you want to fill it with some dummy data, if the original data is confidential.
sorry for the delay in my response. i've been pugnaciously twiddling with my system trying to get MySQL 3.51 to work with UNIXodbc 2.2.5 and I have blown away MySQL 2.50 so I can't reproduce the problem. I finally got MySQL 3.51 to work with OpenOffice and the problem really doesn't occur. I still can't get the UNIXodbc gui, ODBCConfig, to work at all. In case anyone has similar problems, I get the error: ------- Session management error: Authentication Rejected, reason : None of the authentication protocols specified are supported and host-based authentication failed and a gui window pops up saying: Failed to execute SQLManageDataSources(). <OK> when i click <OK>, i get a window that says: The most likely reason for this is that the Qt GUI plugin could not be found or could not be loaded. Ensure that libodbcinstQ.* files are in the library search path. The patch can be altered by setting the LTDL_LIBRARY_PATH environment variable. <OK> but the files exist in /usr/local/lib which is in my LD_LIBRARY_PATH and my LTDL_LIBRARY_PATH. ------- In summary, the following query works correctly for me now, but it didn't work with MySql 2.50: select count(*), publish from bugs left join buggroups on bug_id=bug_b where bug_b IS NULL and publish<>'rejected' and publish<>'batch-rejected' group by publish Therefore, this bug can be closed as a duplicate of 10479. Thanks and sorry for the duplicate! *** This issue has been marked as a duplicate of 10479 ***
closing
change subcomponent to 'none'