Problem persisting JMS w/sqlserver sp3 on WL5.1 sp7

[David Neiman]

Using Weblogic 5.1 SP 7, on Windows NT using SQLServer 7.0 SP 2
using the MSSqlserver4 (SQLServer 6.5) drivers provided by Weblogic
JMS works just fine.

Then we upgraded to SQLServer SP 3.
Via Weblogic the application was able to read/write to various database
tables ust fine except when it got to the application sending a
persistent JMS message. Upon Weblogic writing the message to the
JMSMessage table the following 2 exceptions were thrown depending on
which sqlserver drivers were used:
( The first appears to me an I/O exception while the second a JMS
exception.)

Has anyone seen this, know of a known problem? Thanks

Fri Jun 29 14:23:04 EDT 2001:<I> <JMS>
weblogic.jdbcbase.mssqlserver4.TdsException: I/O exception while talking
to the server, java.net.SocketException: Connect
ion reset by peer: socket write error
at
weblogic.jdbcbase.mssqlserver4.TdsStatement.execute(TdsStatement.java
, Compiled Code)
at
weblogic.jdbcbase.mssqlserver4.TdsStatement.executeUpdate(TdsStatemen
t.java, Compiled Code)
at
weblogic.jdbcbase.mssqlserver4.TdsStatement.executeUpdate(TdsStatemen
t.java, Compiled Code)
at
weblogic.jdbcbase.jts.Statement.executeUpdate(Statement.java:317)
at weblogic.jms.server.JDBCStore.storeMessage(JDBCStore.java:268)
at
weblogic.jms.server.SessionState.persistMessage(SessionState.java:384
)
at weblogic.jms.server.SessionState.publish(SessionState.java:340)
at
weblogic.jms.server.SessionState.sendMessage(SessionState.java:316)
at weblogic.jms.client.JMSSession.sendMessage(JMSSession.java:391)
at
weblogic.jms.client.JMSMessageProducer.send(JMSMessageProducer.java:1
19)
at
com.micrologic.server.interfaces.AlarmClient.sendMsg(AlarmClient.java

**** Next Weblogic was pointed to the MSSqlserver4v70 (SQLServer 7.0)
drivers provided by Weblogic

javax.jms.JMSException: Error allocating key for JMSMessage
at
weblogic.jms.common.JMSUtilities.jmsException(JMSUtilities.java:18)
at weblogic.jms.server.JDBCStore.reserveDbKeys(JDBCStore.java:978)
at weblogic.jms.server.JDBCStore.nextMessageId(JDBCStore.java:892)
at weblogic.jms.server.JDBCStore.storeMessage(JDBCStore.java:225)
at
weblogic.jms.server.SessionState.persistMessage(SessionState.java:384
)
at weblogic.jms.server.SessionState.publish(SessionState.java:340)
at
weblogic.jms.server.SessionState.sendMessage(SessionState.java:316)
at weblogic.jms.client.JMSSession.sendMessage(JMSSession.java:391)
at
weblogic.jms.client.JMSMessageProducer.send(JMSMessageProducer.java:1
19)
at
com.micrologic.server.interfaces.AlarmClient.sendMsg(AlarmClient.java