A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
retrieve data from SQL Server 2005 using Microsoft's JDBC driver
Joined: Mar 05, 2007
Nov 28, 2010 07:23:27
Hi dears ,
My j2ee application was running fine but suddenlly this error occurs
[#|2010-11-28T17:13:07.382+0300|SEVERE|glassfish3.0.1|javax.enterprise.system.std.com.sun.enterprise.v3.services.impl |_ThreadID=28;_ThreadName=Thread-1; |java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer] The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 1 (""): Data type 0x38 is unknown.
i tried the solution mentioned
but still getting the same error , I'm using GlassFish Server Open Source Edition 3.0.1 (build 22) , i just upgraded from glassfish v3 ,
by the way there is another j2ee application running on the same server and fetching data from the same DB and it;s working fine
DB is Microsoft SQL server 2005
Any suggestions ?
Joined: Jun 01, 2010
Nov 28, 2010 07:58:24
You say that the error suddenly occurred but then say you recently upgraded. Could there be a correlation?
Googling the error suggests that you are using the SQLServer 2000 Driver when you should be using
the SQLServer >>2005<< Driver.
Joined: Mar 05, 2007
Nov 28, 2010 09:37:23
ya i mean i didnt change anything in the application itself , only upgrading the server..
Joined: Apr 14, 2004
Nov 29, 2010 02:39:07
I'd second what Tom says. The log shows you are using the MS 2000 driver, which is an awful, bug ridden thing. Upgrade your driver to the 2005 or 2008 versions, or swap to jTDS and things may improve.
I agree. Here's the link:
subject: retrieve data from SQL Server 2005 using Microsoft's JDBC driver
Issue Connecting to MS SQL Server using WAS Embedded connectjdbc Driver
Datasource Test Connection is successful but the application is not able to connect to the Database
SQL Server 2005 & Microsoft JDBC driver
"Could not find stored procedure" Error
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013