Hi all,
I am not sure if this is the correct forum but I have a very weird problem:
When connecting to JBoss with two or more users to one or more databases (within JBoss) I sometimes get an empty ResultSet although cutnpasting the statement into the SQL-Server Manager works perfectly well and returns a ResultSet with multiple rows.
Sorry, but being more specific is really difficult for I cannot reproduce this error everytime. All I can say is that there have to be two or more users on JBoss, the statements work when executed directly on SQL-Server and the statement seems to be executed on the correct connection (at least that is what java.sql.Connection.getMetaData().getURL() tells me).
I hope someone can help me on this issue for I am really lost with this one.
Config is:
JBoss 3.0.4 or JBoss 3.2.1
MSSQL-Server 2000
JAAS
Microsoft JDBC-Driver
Stateless Session Beans are used for almost everything
Thank you very much in advance,
Che