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: [email protected]
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
