Hi Magnus,

> Take the following case:
>
> I have two connections to the same database using the same user.
>
> In session 1, I run an insert-statement. The newly inserted values
> are not visible in session 2. Then I commit in session 2.

I think you mean to say that you commit in Session 1, right? If not,
case closed :)

>Still, the
> values are not visible in session 2. They remail "unavailable" till i
> commit or rollback in session 2!
>
> Why this odd behaviour?

What's the transaction isolation for session 2 - is it "read committed"
or something else (snapshot?)

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."