[Solved] Error Message: "No Java Installation Found"

by **Steve R.** » Mon Oct 29, 2012 2:35 am

Well, Hurricane Sandy didn't give me the opportunity to focus on BASE. just recently upgraded to Ubuntu 12.10 and discovered that BASE no longer worked. I received a couple of error messages, the one that seems to be critical is the "No Java Installation Found". I did locate this post How to Install Java Runtime In Ubuntu 12.04 but that did not help.

I was able to re-connect BASE to MYSQL; by using MySQL Connector for OpenOffice.org. So evidently, these directions appear non-functional because I lack Java??? Connect MySQL and Base

So how do I get BASE to function, as its own database? I assume that I am missing somenthing with Java?

by **RoryOF** » Mon Oct 29, 2012 2:54 am

Java solutions are given in this thread
[Solved] Java Runtime Environment

The certain cure is to install the 32 bit Java 6; it would be helpful if you tried the method of installing the Visual C++ 2010 runtime package advocated by Bill first to see if that worked and reported back to this thread on it, reserving the 32 bit Java fix as a fall-back just in case.

by **Steve R.** » Mon Oct 29, 2012 3:50 am

RoryOF wrote:Java solutions are given in this thread
[Solved] Java Runtime Environment

The certain cure is to install the 32 bit Java 6; it would be helpful if you tried the method of installing the Visual C++ 2010 runtime package advocated by Bill first to see if that worked and reported back to this thread on it, reserving the 32 bit Java fix as a fall-back just in case.

Thanks for the quick reply. I don't think that I can install the Visual C++ 2010 runtime package, as i am running Ubuntu 12.10. I took a look at the packages available on Synaptic Manager but I did not see an obvious candidate.

Alternatively, is to fall-back to Java 6. This will have to wait, out of time for today and I have work tommorrow. We will probably be busy with the after effects of Hurricane Sandy. Anyway, I hope to follow-up on this before next weekend.

by **RoryOF** » Mon Oct 29, 2012 8:32 am

As I posted late at night I did not obseve you were running on Ubuntu; my reply was targetted at Windows, the most common situation. This present machine uses 32 bit Ubuntu 12.04 and Sun Java (6.26); other machines to which I have access use Java (OpenJDK or Iced Tea, from memory) as provided by the Ubuntu Repositories. None of them make any use of Base, or indeed, of Java dependencies other than needed by some word processing extensions, so I have no experience of whether these Javas are adequate, particularly in a 64 bit situation.

edit this topic's initial post · by **Villeroy** » Mon Oct 29, 2012 11:33 am

You can connect to MySQL without any Java. The built-in HSQL database is based on Java, therefore it can not work without it. The built-in database should never be used for anything serious. Not because HSQL is a bad database or because of Java. The way how Base wraps your data into a Base document imposes a high risk of total data loss. I use to use HSQL as an excellent stand-alone database with Base.

Connected to an existing MySQL without any Java installed, you can do the following:
-- Create all kind of queries with no limitation.
-- Design forms manually with no limitation. The Java based form wizard only covers only a tiny fraction of form capabilities.
-- Use Calc as report engine. Both tools to create reports on top of Writer are written in Java.

Under Linux any version of pre-installed Java *should* be usable with OpenOffice if activated under Tools>Options>Java. If you suffer from very low performance with Java databases you can resort to some version of Java 6.

by **Steve R.** » Mon Oct 29, 2012 2:54 pm

Villeroy wrote:You can connect to MySQL without any Java.

That was accomplished.

Villeroy wrote:The built-in HSQL database is based on Java, therefore it can not work without it. The built-in database should never be used for anything serious. Not because HSQL is a bad database or because of Java. The way how Base wraps your data into a Base document imposes a high risk of total data loss. I use to use HSQL as an excellent stand-alone database with Base.

That is what I am trying to resolve. I had developed a primitive test database using BASE as a learning tool, but that is "zapped" for now. Since I experienced an issue with BASE in attempting to access my test database, it just became an issue to solve.

My intent will be to use BASE/MYSQL. One obvious solution is to develop a new test database based on MYSQL.

Will this issue eventually be resolved by fixing the link to Java?

edit this topic's initial post · by **Villeroy** » Mon Oct 29, 2012 3:17 pm

Steve R. wrote:Will this issue eventually be resolved by fixing the link to Java?

Find out.
sudo apt-get install openjdk-6-jre
Then start the office and call Tools>Options>Java
Click the option button left of the Java entry.
Confirm the dialog and restart the office.

by **Steve R.** » Mon Oct 29, 2012 3:37 pm

Thanks. I am at work, so I won't be able to follow-up for a while.

by **Steve R.** » Tue Oct 30, 2012 2:39 am

Villeroy wrote:Click the option button left of the Java entry.

It finally dawned on me to click the option button. I had mistakenly not realized that it was not clickable. Well that was a faulty assumption. :knock:

I thought you were refering to the other check mark which was obviously clickable.
Issue solved. Thank you very much.