Description of problem: I get a JRE is Defective error when I do the followin: Version-Release number of selected component (if applicable): openoffice.org-core-1.9.123-1.2.0.fc5 How reproducible: Every time. Steps to Reproduce: 1. Launch 'openoffice.org-1.9 -base' for a terminal. (Strangely the Database launcher is no longer in Applications > Office and you can't open a new database from New > Database in an OOo window) 2. In the "Database Wizard" dialog, select "Create a new database" and click Finish 3. In the "Save" dialog, click Save 4. In the "New Database x" window click on tables. Actual results: OOo gives a "JRE is Defective" error (see attachment) and then when you click OK it says the connection to the data source couldn't be established (see next two attachments) Expected results: OOo Base lets you into the table section.
Created attachment 117640 [details] JRE is Defective dialog
Created attachment 117641 [details] Initial "connection" warning
Created attachment 117642 [details] More "connection" warning information
a) "launcher is no longer in Applications > Office", install openoffice.org-base to get that. Our UI guys dictated this change b) on the substantive issue, this will almost certainly boil down to a gcj problem or perhaps a hsqldb one what's the output of... rpm -q libgcj rpm -q hsqldb I'm not seeing this error at the moment. i386 platform ? and what's listed in tools->options->openoffice.org->java ?
I have not installed openoffice.org-base. (No change to this after doing that.) libgcj-4.0.1-7 hsqldb-1.80.1-1jpp_1fc Okay, this is where is gets interesting. I looked in tools > options > openoffice.org > java and it 'paused' for a while while it searched for JREs (as there were none listed). After a while it found one called Free Software Foundation v1.4.2. This option was not selected. I selected this JRE and now the database works properly. I'm not going to close this bug, because for some reason OOo isn't finding a JRE to use (even though it was there) and when it's forced to look (using the options) it doesn't select the JRE even though it was the only one, so in my opinion something has gone wrong still (the user shouldn't have to do all this just to get the JRE to be recognised).
indeed, it's supposed to be auto-detected. I wish I'd thought to ask you to attach your ~/.openoffice.org2.0/user/config/javasettings_Linux_x86.xml before I asked ou to check the tools->options :-(, that might have cast light on the problem. Had you ever installed e.g. the sun java, or ibm one and then uninstalled it ?
No, I haven't installed either of these this time around, but I have just done a complete reinstall where I used my existing home directory from my previous install which had the Sun JRE (1.5) installed. This might be the problem?
Yeah, I would expect that the ~/.openoffice.org2.0/user/config/javasettings_Linux_x86.xml contained a reference to the sun java which was no longer there. We can reproduce this problem by installing jdk's getting OOo to autodetect and autoselect one, and the replacing the auto-detected one with something else, i.e, http://qa.openoffice.org/issues/show_bug.cgi?id=53220, we need to see what we should do, e.g. re-detect if the selected jdk is not available. But don't want to search for a jdk on every startup, e.g. there user has no java installed to start with and no intention of installing it