Friday, November 14, 2008

[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect.

Exception
SQLException occured in the SQLPhysicalConnection.select(): | Table or View Name = F98611 | Data Source = System - 811 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.
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.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSCursorRequest.openCursor(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.execute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)
at com.jdedwards.database.impl.physical.PreparedStatementDecorator.executeQuery(Unknown Source)
at com.jdedwards.database.impl.sql.SQLPhysicalConnection.select(Unknown Source)
at com.jdedwards.database.impl.retry.JDBRetryableSelect.lowLevelAttempt(Unknown Source)
at com.jdedwards.database.impl.retry.JDBRetryableReadOperation.attempt(Unknown Source)
at com.jdedwards.base.util.Retryer.retry(Unknown Source)
at com.jdedwards.database.impl.retry.JDBRetryAccess.select(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessDelegate.select(Unknown Source)
at com.jdedwards.database.impl.transform.JDBTransformAccess.select(Unknown Source)
at com.jdedwards.database.impl.logical.JDBLogicalConnection.select(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessExpander.select(Unknown Source)
at com.jdedwards.database.services.base.JDBBaseLookupService.get(Unknown Source)
at com.jdedwards.database.services.base.JDBBaseLookupService.getSingle(Unknown Source)
at com.jdedwards.database.services.base.JDBBaseLookupService.getSingle(Unknown Source)
at com.jdedwards.database.services.ocm.OCM.getDataSource(Unknown Source)
at com.jdedwards.database.services.ocm.OCM.getDatabaseDataSource(Unknown Source)
at com.jdedwards.database.services.ocm.OCMObjectLookupService.getDatabaseDataSource(Unknown Source)
at com.jdedwards.database.jdb.JDBConnectorImpl.getSpecConnection(Unknown Source)
at com.jdedwards.database.jdb.JDBConnectorImpl.connect(Unknown Source)
at com.jdedwards.database.jdb.JDBConnectorImpl.connect(Unknown Source)
at com.jdedwards.database.jdb.JDB.connect(Unknown Source)
at com.jdedwards.runtime.generator.GeneratorEnvironmentUtility.connectToDatabase(Unknown Source)
at com.jdedwards.runtime.generator.Languages.init(Unknown Source)
at com.jdedwards.runtime.generator.Languages.(Unknown Source)
at com.jdedwards.runtime.generator.GUI.GeneratorFrame.showLanguageWindow(Unknown Source)
at com.jdedwards.runtime.generator.Generator.processCommand(Unknown Source)
at com.jdedwards.runtime.generator.GUI.GeneratorFrame$MenuItemListener.actionPerformed(Unknown Source)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)
at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.AbstractButton.doClick(AbstractButton.java:289)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1113)
at javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(BasicMenuItemUI.java:943)
at java.awt.Component.processMouseEvent(Component.java:5100)
at java.awt.Component.processEvent(Component.java:4897)
at java.awt.Container.processEvent(Container.java:1569)
at java.awt.Component.dispatchEventImpl(Component.java:3615)
at java.awt.Container.dispatchEventImpl(Container.java:1627)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
at java.awt.Container.dispatchEventImpl(Container.java:1613)
at java.awt.Window.dispatchEventImpl(Window.java:1606)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
Scenario
When you try to connect to a sqlserver 2005 database using a sqlserver 2000 jdbc driver, you might come across the above exception.
sqlserver 2005 jdbc driver : sqljdbc.jar[com.microsoft.sqlserver.jdbc.SQLServerDriver]
sqlserver 2000 jdbc drivers: msbase,jar,msutil.jar,mssqlserver.jar [com.microsoft.jdbc.sqlserver.SQLServerDriver]
So give a try with the sqlserver 2005 jdbc driver.
In Jas server's JDBJ.ini file set 'SQLSERVER=com.microsoft.sqlserver.jdbc.SQLServerDriver' under [JDBj-JDBC DRIVERS]

Related
Microsoft JDBC Driver Team Blog

No comments: