Re: Testing Firebird SDBC

Thank you for your reply.

I had mistakenly thought that the "Firebird File" option was a client
option, but now my understanding is that this is a normal Firebird .fdb
file connected using the embedded server.

So I have been trying out the 4.2RC1 on both Windows 8 and Ubuntu 12.10.

What I see is that the 'fully' embedded option (i.e. the .fdb
compressed/uncompressed to/from the .odb file) works to a degree, but I
have problems with the "Firebird File" option on both Windows and Linux.

On Windows I get an "Unable to complete network request to host
{myhostname}" message, which is strange for the embedded database.

On Linux everything appears to work, but any data entered is not properly
stored. The data is apparently entered okay, it is even possible to create
a query and query the newly entered data, but if you close and re-open the
file then the data is gone. This looks like a transaction not be committed
or rolled back, but I had always thought that as long as the "Save" button
was greyed out that Base had successfully committed the transaction.

> > This shouldn't be hugely complicated to do, the main issue is in setting
up and/or getting access to a
> > firebird server to test that it actually works, which is why is the main
reason I haven't tried to do this yet
> > -- all contributions in this area would be greatly appreciated :).

I am more than happy to setup various Firebird servers on Windows 8, XP and
Linux and do what ever testing you need. However one problem is that I have
never been able to build LO from source so would you be able to put the
changes into the master?



On Mon, Dec 30, 2013 at 9:16 PM, Andrzej Hunt <andrzej@ahunt.org> wrote:

>  There isn't any firebird server support yet -- however it shouldn't be
> hugely
> complicated to add -- what's needing doing is allowing setting and
> passing the required parameters (url/username/password/etc.) to firebird
> -- the passing of the parameters is actually already in place, we just need
> to add an easy way for the user to pass them in / parse them.
>
> I.e. I would suggest:
>
> 1. Adding a "Firebird Server" driver entry to allow entry of
> username/password
>     in addition to url:
>
>  connectivity/registry/firebird/org/openoffice/Office/DataAccess/Drivers.xcu
>  This would be pretty similar to any of the other remote server driver
> entries in the other connectivity/registry/*/..../Drivers.xcu files.
> (I suspect it's easiest to have separate driver entries, rather than try
> to have one entry dealing with both local files and servers, although we
> can probably share the same sdbc:firebird: prefix).
>
> 2. Add some supporting code to:
>  connectivity/source/drivers/firebird/Connection.cxx
> I.e. we need to parse the username/password/url from the new driver
> configuration added above (the code to pass username/passwords/urls to
> firebird itself is already in place, so we just need to set the parameters
> appropriately based on user input).
>
> 3. Possibly adapt
>  dbaccess/source/ui/dlg/ConnectionHelper.cxx
> To only apply the ".fdb" filter when we're configuring "Firebird File" and
> not for "Firebird Server".
> (I suspect this wouldn't be necessary if we use a separate prefix though).
>
> This shouldn't be hugely complicated to do, the main issue is in setting
> up and/or getting access to a firebird server to test that it actually
> works, which is why is the main reason I haven't tried to do this yet --
> all contributions in this area would be greatly appreciated :).
>
> Cheers,
>
>     Andrzej
>
>
> On 30/12/13 15:34, iwbnwif yiw wrote:
>
>  I would like to join in the testing of the Firebird SDBC as I have been
> using both Firebird and OO/LO for many years and very happy to see them
> being properly integrated.
>
>  Although I have been getting on well with the embedded files (i.e. fdb
> embedded in odb), I can't work out the URL format for connecting with a
> server using the "Firebird File" option in connect to an existing database.
>
>  Thanks...
>
>
>
> _______________________________________________
> LibreOffice mailing 
> listLibreOffice@lists.freedesktop.orghttp://lists.freedesktop.org/mailman/listinfo/libreoffice