> Now with the type4-driver i have the problem that sometimes the
> same select for one user gets the correct resultset and for another
> user it gets an empty resultset (no sqlexception is thrown).
> (mostly after the connection is 'old', direct after the creation of
> the connection all users gets the same resultset)
>
> The only difference i see is that they use different connections
> for their select.
>
> Have someone a explanation for this behavior (and a solution) ?

It seems that you have problems with transaction isolation. Check if
you use Connection.TRANSACTION_READ_COMMITTED in connection that only
reads. By default it is TRANSACTION_REPEATABLE_READ (or am i wrong?),
this means that you will not see any changes before you call
Connection.commit() on read-only connection.

Hope this helps.

Best regards,
Roman Rokytskyy