Return-Path: 
 <ooo-users-return-2334-apmail-incubator-ooo-users-archive=incubator.apache.org@incubator.apache.org>
X-Original-To: apmail-incubator-ooo-users-archive@minotaur.apache.org
Delivered-To: apmail-incubator-ooo-users-archive@minotaur.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id DB74DDBC5
	for <apmail-incubator-ooo-users-archive@minotaur.apache.org>;
 Fri,  3 Aug 2012 17:18:34 +0000 (UTC)
Received: (qmail 23238 invoked by uid 500); 3 Aug 2012 17:18:34 -0000
Delivered-To: apmail-incubator-ooo-users-archive@incubator.apache.org
Received: (qmail 23200 invoked by uid 500); 3 Aug 2012 17:18:34 -0000
Mailing-List: contact ooo-users-help@incubator.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:ooo-users-help@incubator.apache.org>
List-Unsubscribe: <mailto:ooo-users-unsubscribe@incubator.apache.org>
List-Post: <mailto:ooo-users@incubator.apache.org>
List-Id: <ooo-users.incubator.apache.org>
Reply-To: ooo-users@incubator.apache.org
Delivered-To: mailing list ooo-users@incubator.apache.org
Received: (qmail 23192 invoked by uid 99); 3 Aug 2012 17:18:34 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 03 Aug 2012 17:18:34 +0000
X-ASF-Spam-Status: No, hits=0.7 required=5.0
	tests=SPF_NEUTRAL
X-Spam-Check-By: apache.org
Received-SPF: neutral (nike.apache.org: local policy)
Received: from [94.21.128.6] (HELO smarthost01.digicable.hu) (94.21.128.6)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 03 Aug 2012 17:18:25 +0000
Received: from [92.249.128.185] (helo=relay03.digicable.hu)
	by smarthost01.digicable.hu with esmtp
	id 1SxLVk-0008Ka-NX for <ooo-users@incubator.apache.org>;
 Fri, 03 Aug 2012 19:18:04 +0200
Received: from [94.21.206.47] (helo=[192.168.5.100])
	by relay03.digicable.hu with esmtpa
	id 1SxLVj-00051u-Bs for <ooo-users@incubator.apache.org>;
 Fri, 03 Aug 2012 19:18:04 +0200
Message-ID: <501C07C0.7000001@hdsnet.hu>
Date: Fri, 03 Aug 2012 19:17:52 +0200
From: =?ISO-8859-1?Q?Reizinger_Zolt=E1n?= <zreizinger@hdsnet.hu>
User-Agent: Mozilla/5.0 (Windows NT 6.1;
 rv:14.0) Gecko/20120713 Thunderbird/14.0
MIME-Version: 1.0
To: ooo-users@incubator.apache.org
Subject: Re: Connecting to a database
References: <501BD634.9060700@gmail.com> <501BDB47.6020408@hdsnet.hu>
 <501BE82D.5080506@gmail.com>
In-Reply-To: <501BE82D.5080506@gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Original: 94.21.206.47
X-Original: 92.249.128.185

2012.08.03. 17:03 keltez�ssel, Dan �rta:
> Reizinger Zolt�n wrote:
>> 2012.08.03. 15:46 keltez�ssel, Dan �rta:
>>>      I have a database located at 
>>> ~/.openoffice.org/3/user/database/budget-personal/
>>> that extracted from an embedded Base database. I want to use Base to 
>>> connect to this
>>> database. I know that the Datasource URL is hsqldb:file:/home/<user
>>> name>/.openoffice.org/3/user/database/budget-personal/. But what do 
>>> I enter as the JDBC
>>> Class? Should there be something entered in Tools > Openoffice.org > 
>>> Java > Class Path?
>>> Is so what?
>>>      I want to be able to connect to the database files using hsqldb 
>>> 1.8. I can do this
>>> if I use hsqldb 2.2.8. How do I do this using Base?
>
>
>>>
>>> The Datasource URL:
>>>         hsqldb:file:/home/<user 
>>> name>/.openoffice.org/3/user/database/budget-personal/
>>> The JDBC driver class:     org.hsqldb.jdbc.JDBCDriver
>>> Class Path: /usr/local/hsqldb-2.2.8/hsqldb/lib/hsqldb.jar
>>>
>>> --Dan
>
> > Hi Dan,
> > You can not use simultaneously hsqldb 1.8 and 2.2.x version.
> > You can add only one hsqldb.jar to the class path, first remove 
> 2.2.8 version, restart AOO,
> > add 1.8.
> >  From AOO add built in hsqldb 1.8 to classes under win7: from 
> c:\Program
> > Files\OpenOffice.org 3\Basis\program\classes\
> > or under Linux from
> > The driver class is same for the both hsqldb version.
> > If you connected to this file with 2.2.8 version, you can get error 
> message, it created in
> > newer version.
> > Zoltan
>
>      I removed 2.2.8 version of hsqldb from the Class Path.
> Closed AOO.
> Opened AOO.
> Tools > Options > Java > Class Path.
> There are not class paths listed.
> Add Archive
> Browsed to /opt/openoffice.org/basis3.4/program/classes/hsqldb.jar
> Click OK twice.
> Closed AOO
> Opened AOO
> Open the Base Wizard selecting "Connect to an existing database": JDBC.
> Click Next.
> Entered the Datasource URL as above.
> Entered the JDBC driver class: org.hsqldb.jdbc.JDBCDriver
I missed the wrong driver: org.hsqldb.jdbcDriver is the correct one.
This will work with 2.2.8, too.
Zoltan
> Clicked "Test class".
> Error message appears: The JDBC driver could not be loaded.
>
> What is wrong with these steps? I can follow the very same steps, this 
> time using the latest version of hsqldb 
> (/usr/local/hsqldb-2.2.8/lib/hsqldb.jar entered in the Class Path). 
> Then instead of an error message, the message tells me that the JDBC 
> driver was successfully loaded.
>
> --Dan
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org