Hi Drew, Its been a while since this post, that I tried Base again today. I have a new OO 3.1.0 on OpenSUSE 11.1 in the mean time. Various JRE's are on the system, but OO is configured to use the newest Sun Version from OpenSUSE that I installed today: java-1_6_0-sun - Java(TM) 6 Runtime Environment java-1_6_0-sun-alsa - ALSA support for java-1_6_0-sun java-1_6_0-sun-devel - Java(TM) 6 SDK, Standard Edition java-1_6_0-sun-jdbc - JDBC/ODBC bridge driver for java-1_6_0-sun java-1_6_0-sun-plugin - Browser plugin files for java-1_6_0-sun java-1_6_0-sun-src - Source files for java-1_6_0-sun
Other versions installed are: java-1_5_0-gcj-compat - JPackage Runtime Scripts for GCJ java-1_5_0-gcj-compat-devel - JPackage development scripts for GCJ java-1_5_0-sun - Java(TM) 5 Runtime Environment java-1_5_0-sun-jdbc - JDBC/ODBC bridge driver for java-1_5_0-sun java-1_6_0-openjdk - Java runtime environment based on OpenJDK 6 and IcedTea 6 java-1_6_0-openjdk-plugin - Java web browser plugin based on OpenJDK 6 and IcedTea 6 Drew Jensen wrote: > [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) > Right. > 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. > OO takes the newest version automatically it seems. > 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) I added these two options. The problem remains with a out of memory error in a query as described. The original data was transferred from calc via a copy from calc and an insert in base's tables. The query was created with the wizard. Any ideas what to try next? :-) Al --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
