Re: [libreoffice-users] Connect Base to External HSQLDB

On 02/06/14 00:59, Jean-Francois Nifenecker wrote:
> Le 06/02/2014 05:50, Mark LaPierre a écrit :
> > Hey all,
> >
> > I have HSQLDB installed here:
> > /home/database/back/hsqldb/lib/hsqldb.jar
> >
> > I want the Base front end here:
> > /home/database/recipe/recipe.odb
> >
> > On the LibreOffice Database Wizard:
> > 1. Select Database
> >      I select the radio button: [Connect to an existing database]
> >      I select [JDBC] in the section box and then click [Next>>]
> >
> > 2. Set up JDBC connection
> >      I fill in [data source URL]:  jdbc:[../back/hsqldb/lib/hsqldb.jar]
> >
> >      What do I put in the [JDBC driver class] box?
> >
> > The HSQLDB documentation suggests that there is a JDBC driver in the
> > hsqldb.jar file but that doesn't work.
> >
> > I assume that the HSQLDB package contains a driver.jar somewhere.  What
> > should I put in for the JDBC driver class path?
>
> (some terms below freely translated from my FR environment)
>
> -- data source (URL)
> hsqldb:file:<path to the
> .odb>;default_schema=true;shutdown=true;hsqldb.default_table_type=cached;get_column_name=false
>
> In <path to the .odb> above do not specify the .odb extension.
> Sset the defaults above as you prefer; these work for me.
>
> -- JDBC driver class
> org.hsqldb.jdbcDriver
>
> -- A question: did you set the class path and configuration for Java?
> If not, go to Tools/Options, LibreOffice / Java.
> Check that "Use a Java setup" is checked, then add the Java environment
> setup on the PC.
>
> Once this is set, click Class path
> In the new dialog:
> (1) Add an archive
> Point to the hsqldb.jar on your PC (mine is C:\Program
> Files\hsqldb-2.2.8.\lib)
> (2) Add a file
> Point to the above \lib subdir
>
> You should be up and running.
>
> HTH,

I've had a lot of distractions, Olympics and Income Tax return, to get
through so I'm working on this again.

On the "Set up a connection to a JDBC database" page I have:

Datasource URL
jdbc:[/home/database/back/hsqldb/lib/hsqldb.jar]

JDBC driver class
[org.hsqldb.jdbcDriver]

When I click on the [Test Class] button I get a dialog box that says the
JDBC driver was loaded successfully.

Jumped through the first hoop.

On the "Set up the user authentication" page I have:

User Name [mlapier] with the Password required check box selected.

When I click the [Test Connection] button I get a dialog box asking for
my password.  I type in my password and click the [OK] button.

I get a message box:
Connection Test
The connection could not be established.

Without the password check box I get the same result.

Does anyone see where I have gone astray?

-- 
    _
   °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