Re: When Will This Happen?

    Never mind, it was the "SQLException invalidates transaction"
issue.  Turned out to be caused by a configuration problem with my code,
but it seems evident that WebLogic is not expecting this behavior (which
is to say, it doesn't rollback CMP transactions immediately when it gets a
SQLException).
    I'll put my vote in for changing the behavior to kepp working fine
after a SQLException in a transaction, even though I know this won't be
done soon.  :)

Aaron

On Sat, 9 Nov 2002, Aaron Mulder wrote:
> I'm trying to use the beta 3 JDBC driver in WebLogic.  I'm getting:
>
> No results were returned by the query.
>         at
> org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:157)
>
>     As far as I can tell, the statements being executed are:
>
> SELECT rolename, username FROM user_roles WHERE 1 = 0
> SELECT user_id, username FROM users WHERE 1 = 0
> SELECT * FROM users WHERE 1 = 0
>
>     I don't have any trouble executing those outside WebLogic.  What
> can cause that "No results were returned" SQLException to come up instead
> of just a value ResultSet with no rows?
>
> Thanks,
>     Aaron
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>