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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>