[EMAIL PROTECTED] wrote:
Hi all,
I'm trying the new OOo 3.0 Base in stead of Access 2007.
The system is:
OS: OpenSUSE 10.3 - Linux ~ 2.6.22.19-0.1-default #1 SMP 2008-10-14
22:17:43 +0200 x86_64 x86_64 x86_64 GNU/Linux
Openoffice: OpenOffice.org 3.0.0, OOO300m9 (Build:9358), Copyright
2000-2008 Sun Microsystems Inc., Build 3.0.0.3.5
[First - I will assume you are not using an MDB file, rather that you
have created an embedded HSQLdb database in a Base file)
I take it this is the version of OpenOffice.org supplied by OpenSuse.
That's fine, but one thing I've found is that this will try (to be clear
here, under a different Linux distro ) to use a Java Runtime Engine
(JRE) other then one supplied by Sun. Of late I see that many are
beginning to use OpenJDK, but that is not complete yet.
So - first thing I would recommend is that you ensure that you have a
JRE from Sun Microsystems. I run the latest 10.6.0_10 (x64) from SUN
under my Ubuntu 8.10 (X64) with good results.
I have 3 Tables. Table 1: 3 Col x 11227 Rows (ABC-SAM-Nr-Realtion)
Table 2: 8 Col x 16987 Rows
(erp2-Inventa-81203)
Table 3: 3 Col x 2559 Rows
(SAM-Article-Invent-2008-1)
## Problem 1 ##
When I create relationships between the tables, save it and open it up
again; the relationships are gone. If I open up the relationships again,
the tables are there, but the field-links are gone. If I redo them and
save again, they are lost again on opening up the relationships.
I have not seen this with the embedded HSQLdb engine with 3.0, however
there is an open Issue with this when running 3.0 against MySQL. It is
already marked fixed in the upcoming 3.0.1 release (about 4 weeks out).
I suppose this could be another manifestation of said anomaly.
This is actually irrelevant with regards to your Query - whether the
relation exists or not. If you can not wait for the update you can still
add these relations by using standard SQL commands in the SQL window. If
you want to or need to do so, respond back on the list and I'll try to
help you there.
## Probblem 2 ##
If I try to create a query that links the three tables, errors ( SQL
Status: S1000 Error code: 72 out of memory) occur, probably as a result
of the failing relationships.
To solve this you need to increase the max amount of memory that Java
can allocate.
There are two command line options available for Java that can be
utilized here.
-Xmsn(k/m) - sets the Starting amount of memory to set aside for Java
-Xmxn(k/m) - sets the Maximum amount of memory that Java can allocate
For example then one could set the following options:
-Xms128m (this tells Java to start with 128 meg of memory)
-Xmx256m (tells Java to allocate up to 256 meg of memory - the default
for this is 64 Meg by the way )
[note that each option ends with 'm' this is required to designate that
the value is in Megs]
Adding start up options for Java under OpenOffice.org with the following:
Tools>Options>OpenOffice.org>Java
Click the button 'Parameters'
The dialog "Java start parameters" is now displayed.
Enter the options in the 'Java start parameter' text box and click OK.
(any current options will be displayed in this dialog also)
HTH
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
