0 Replies Latest reply on Oct 20, 2003 6:59 AM by che

    Empty ResultSet for valid Query

    che Newbie

      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
      Microsoft JDBC-Driver

      Stateless Session Beans are used for almost everything

      Thank you very much in advance,