1 Reply Latest reply on Sep 5, 2006 1:53 PM by ivan

    JBoss 3.2.5 and SQLServer 2005

    ivan Newbie

      Hi all,

      we're migrating from SQLServer 2000 to SQLServer 2005.
      Downloaded sqljdbc_1.1.1501.101_enu.exe from Microsoft
      and installed the driver sqljdbc.jar in jboss-3.2.5\all\lib and removed
      the SQLServer2000 driver files.

      On startup I get no deployment errors.
      However on trying to retrieve data from the database I get



      19:02:19,625 DEBUG [Usuario#findByNombreUsuario] Executing SQL: SELECT DISTINCT
      t0_o.idUsuario FROM dbo.Usuarios t0_o WHERE (t0_o.nombreUsuario = ?)
      19:02:19,656 DEBUG [Usuario#findByNombreUsuario] Find failed
      java.sql.SQLException: [Microsoft][SQLServer JDBC Driver][SQLServer]The incoming
      tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorr
      ect. Parameter 1 (""): Data type 0x38 is unknown.

      Please help.
      Best regards,
      Ivan

        • 1. Re: JBoss 3.2.5 and SQLServer 2005
          ivan Newbie

          On the connection setting I had SelectMethod=Cursor .
          When I put SelectMethod=Direct it removes the
          The incoming tabular data stream (TDS) error
          but
          After a while it complains about not being able to obtain a cloned connection.

          Is there any way out of this?

          Cheers