JBoss 3.2.5 and SQLServer 2005

[ivanlc]

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

[ivanlc]

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