Re: [Firebird-docs] Limbo Transactions

[Helen B. <he...@ii...>]

At 06:23 PM 15/06/2007, you wrote:
>Hi Helen,
>
>first of all, thanks - you are a star!
>
>I was having trouble getting the stat1 embedded sql example to link. 
>You mentioned 'embedded' in a refernce to 'real programmers' and 
>that gave me a clue. I was linking with libfbclient.so but a quick 
>ldd on the executables in the bin directory showed that they all 
>linked wil libfbemded.so. A quick change to my gcc commandline and 
>yipee - I have sucessfully compiled and run the stat1 example - I 
>now have the peso in my 'employee' database !
>
>Interestingly, if I link with both the above mentioned libraries, I 
>get a permission denied' error when running stat1. It tells me I 
>cannot access my own database.

There's a reason for that.  If you connect using libfbembed.so and a 
local pathname (not localhost or the hostname/IP address) you are 
actually starting an exclusive instance of the firebird server 
(that's what the "embed" part in "libfbembed.so" is about.  IINET is 
not involved:  it is a direct connection between that embedded server 
code and the database file, in the user space of the user running the 
app.  When you then attempt to connect with libfbclient.dll, or to 
make an IINET connection with libfbembed.so, access is denied.

It's the model you use for writing embedded applications on POSIX 
platforms.  There is a separate branch of SQL known as "embedded sql" 
that you use directly in a C application in a block following an EXEC SQL tag.

g*pre* is a *pre*compiler.  What it does is it goes through your 
program source code, picks up all these tagged blocks and converts 
them into "precompiled" embedded API-like function and macro 
calls.  Remember "Embed, Deploy, Relax"?  That's what that was about.

>I got an email from New Scientist magazine this morning telling me 
>all about the long running drought in Australia - seems a tad ironic 
>considering current events.

Well, the drought has played its part in causing the flood to be so 
disastrous.  Creek beds that have been dry for years were like 
concrete runways, all pointing downhill for 100's of Kms.  At 
Somersby, south of here, an old creek bed running underneath a main 
highway filled up and caused a section of the highway to crumple and 
collapse to become a 40-metre-deep chasm.  A whole family (mum, dad 
and three kids in a car) was lost down it.


> > I hope Rodney's folks are OK...I heard there were some pockets of
> > really bad tree-fall damage around Wamberal and those neighbouring
> > leafy coastal suburbs...
>
>We've only heard about the Newcastle area in the UK

Go down the coast about a couple millimetres south of Newcastle on 
your little map - that where I live (and Rodney's parents too).

Helen