Re: [libreoffice-users] Re: LibreOffice Base and Java conflict

On 05/27/15 09:47, Tom Davies wrote:
> Hi :)
> If possible it is a good idea to export your database tables to a different
> program such as Postgresql or MariaDb/MySql or any other non-Java external
> "back-end".  Then hopefully Base can connect to your external back-end
> without having to edit your Queries, Forms or Reports much.
>
> This is a good start to "up-scaling" your database so that the data can be
> used in other ways and/or by other programs and maybe even on other
> machines.
>
> Base's internal back-end is not great and is worth moving away from.  It
> was only plugged in to make Base behave more like MS's very limiting
> "Access" program instead of using Base the much more powerful way it was
> initially designed to be used.
> Regards from
> Tom :)
>
>
>
> On 27 May 2015 at 01:13, Andreas Säger <villeroy@t-online.de> wrote:
>
> > Am 26.05.2015 um 17:56 schrieb Алексей Антипов:
> > > Dear sirs!
> > >
> > > I have a problem with using of LibreOffice Base because of message about
> > non-working Java in my system.
> > > Although Java is installed in my system.
> > > My OS is Windows XP SP3 32-bit on my netbook Asus Aspire One D270k, and
> > i tried versions JRE-7u79 and JRE-6u45, and also latest Java 8 (although
> > officially Java 8 is not support Windows XP), and in all cases when i work
> > with LibreOffice Base document and try to open sheet, i have a message that
> > JRE is corrupted. Reinstalling of Java and LibreOffice does not give any
> > positive effect.
> > > I also tried to install Java in directory with installed LibreOffice, it
> > also didn't give positive effect.
> > > I use latest LibreOffice_4.4.3_Win_x86 version.
> >
> >
> > Troubleshooting Open/LibreOffice and Java
> > > https://forum.openoffice.org/en/forum/viewtopic.php?f=74&t=69896
> >
> >
> >
> >
> > --
> > To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> > Problems?
> > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > List archive: http://listarchives.libreoffice.org/global/users/
> > All messages sent to this list will be publicly archived and cannot be
> > deleted
On 05/27/15 09:47, Tom Davies wrote:> Hi :)
> If possible it is a good idea to export your database tables to a
different
> program such as Postgresql or MariaDb/MySql or any other non-Java external
> "back-end".  Then hopefully Base can connect to your external back-end
> without having to edit your Queries, Forms or Reports much.
>
> This is a good start to "up-scaling" your database so that the data can be
> used in other ways and/or by other programs and maybe even on other
> machines.
>
> Base's internal back-end is not great and is worth moving away from.  It
> was only plugged in to make Base behave more like MS's very limiting
> "Access" program instead of using Base the much more powerful way it was
> initially designed to be used.
> Regards from
> Tom :)

Hey Tom,

It is possible to place your data in MySQL, MariaDB, or other database
backends.  Base can link to tables in MySQL.  I've done it, but not very
well, a couple of times.  Seems I've got a lot to learn.

You can also link to tables maintained by a stand alone version of the
same built in database that Base uses.  I've done that too, but not very
well.  It's called HSQLDB.  You can set up an instance on a server and
connect to it over your network, or you can set up an instance on the
same computer and connect to it directly.

-- 
    _
   °v°
  /(_)\
   ^ ^  Mark LaPierre
Registered Linux user No #267004
https://linuxcounter.net/
****

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted