JDBC driver issue (weblogic.jdbc.mssqldriver4) with WL7.0 SP5

[Guillermo De La Rosa]

We have just upgrade from SP2 to SP5 and we are getting the following errors:

Errors on console: weblogic.jdbc.mssqlserver4.TdsException: Statement.executeQuery - No result sets were produced by ' execute sp_storedprocedure_data ?,? '].>

weblogic.jdbc.mssqlserver4.TdsException: Statement.executeQuery - No result sets were produced by 'SELECT XXX ............... WHERE ( YYY ) ORDER BY ZZZ DESC '

weblogic.jdbc.mssqlserver4.TdsException: getXXX cannot be used to get type 4 (int).
at weblogic.jdbc.mssqlserver4.TdsEntry.invalidConversion(TdsEntry.java:1287)

We have received a possible patch for solve this apparently JDBC issue, the patch is : CR196738_70sp4.jar
but when we applied this patch to our weblogic server (SP5) we´re getting the following error when server A came up:(admin server works fine..)

Critical> <WebLogicServer> <000364> <Server failed during initialization. Exception:weblogic.rmi.extensions.RemoteRuntimeException: Unexpected Exception - with nested exception:
[java.rmi.UnmarshalException: failed to unmarshal interface weblogic.management.WebLogicMBean; nested exception is:
java.io.UTFDataFormatException]
java.rmi.UnmarshalException: failed to unmarshal interface weblogic.management.WebLogicMBean; nested exception is:
java.io.UTFDataFormatException
java.io.UTFDataFormatException
at weblogic.utils.io.DataIO.readUTF(DataIO.java:686)
at weblogic.utils.io.ChunkedDataInputStream.readUTF(ChunkedDataInputStream.java:117)
at weblogic.rjvm.MsgAbbrevInputStream.resolveProxyClass(MsgAbbrevInputStream.java:311)
at weblogic.common.internal.ChunkedObjectInputStream$NestedObjectInputStream.resolveProxyClass(ChunkedObjectInputStream.java:331)
at java.io.ObjectInputStream.inputProxyClassDescriptor(ObjectInputStream.java:977)
at java.io.ObjectInputStream.readObject(ObjectInputStream.java:365)
at java.io.ObjectInputStream.readObject(ObjectInputStream.java:231)
at java.io.ObjectInputStream.inputObject(ObjectInputStream.java:1181)
at java.io.ObjectInputStream.readObject(ObjectInputStream.java:381)
at java.io.ObjectInputStream.readObject(ObjectInputStream.java:231)
at weblogic.common.internal.ChunkedObjectInputStream.readObject(ChunkedObjectInputStream.java:120)
at weblogic.rjvm.MsgAbbrevInputStream.readObject(MsgAbbrevInputStream.java:103)
at weblogic.rmi.internal.ObjectIO.readObject(ObjectIO.java:56)
at weblogic.rjvm.ResponseImpl.unmarshalReturn(ResponseImpl.java:161)
at weblogic.rmi.internal.BasicRemoteRef.invoke(BasicRemoteRef.java:128)
at weblogic.management.internal.AdminMBeanHomeImpl_WLStub.getMBean(Unknown Source)
at weblogic.management.ManagedServerAdmin.getAdminServer(ManagedServerAdmin.java:428)
at weblogic.ldap.EmbeddedLDAP.initReplicas(EmbeddedLDAP.java:1178)
at weblogic.ldap.EmbeddedLDAP.initialize(EmbeddedLDAP.java:287)
at weblogic.t3.srvr.T3Srvr.initialize1(T3Srvr.java:721)
at weblogic.t3.srvr.T3Srvr.initialize(T3Srvr.java:594)
at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:282)
at weblogic.Server.main(Server.java:32)
--------------- nested within: ------------------
weblogic.rmi.extensions.RemoteRuntimeException: Unexpected Exception - with nested exception:
[java.rmi.UnmarshalException: failed to unmarshal interface weblogic.management.WebLogicMBean; nested exception is:
java.io.UTFDataFormatException]
at weblogic.management.internal.AdminMBeanHomeImpl_WLStub.getMBean(Unknown Source)
at weblogic.management.ManagedServerAdmin.getAdminServer(ManagedServerAdmin.java:428)

Does any one have a patch for this JDBC problem with SP5 ? or is there any other sql jdbc driver besides the one that came with bea (weblogic.jdbc.mssqldriver4) or the one from microsoft?

Any ideas??

Thanks a lot!
Guillermo