> Now with the type4-driver i have the problem that sometimes theIt seems that you have problems with transaction isolation. Check if
> 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) ?
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.