I/O Error: Unknown packet type 0xff

[Michael Hnat - bluegras]

Hi,

I have following configuration: Windowsserver with a MSSQL Server 2000 and a
CentOS Server with Railo 3.0.2.001 running.
Once, twice a day I'm loosing the database connection for about 5 minutes.
I'm getting an "I/O Error: Unknown packet type 0xff" Error.
My connection to the database is done with the "MSSQL - Microsoft SQL Server
(Vendor jTDS)" driver.

I don't know what is happening and why this error is coming up. I can not
recognize if it is a problem on the railo or the windows machine or a
problem with the connection between the servers.

Here a few lines of the stacktrace:
I/O Error: Unknown packet type 0xff at
net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1049):1049 at
net.sourceforge.jtds.jdbc.TdsCore.microsoftPrepare(TdsCore.java:1175):1175
at
net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareSQL(ConnectionJDBC2.java:64
6):646 at
net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatemen
t.java:474):474 at railo.runtime.type.QueryImpl.<init>(Unknown Source):-1 at
railo.runtime.tag.Query.a(Unknown Source):-1 at
railo.runtime.tag.Query.doEndTag(Unknown Source):-1 at
cms_web180.mvsitedao_mssql$cfc.udfCall2(/var/www/DAO_mssql.cfc:530):530 at
cms_web180.mvsitedao_mssql$cfc.udfCall(/var/www/ DAO_mssql.cfc):-1 at
railo.runtime.type.UDFImpl.implementation(Unknown Source):-1 at
railo.runtime.type.UDFImpl.a(Unknown Source):-1 at
railo.runtime.type.UDFImpl.call(Unknown Source):-1 at
railo.runtime.ComponentImpl.a(Unknown Source):-1 at
railo.runtime.ComponentImpl._call(Unknown Source):-1 at
railo.runtime.ComponentImpl.call(Unknown Source):-1 at

Any ideas??

Cheers
Michi

[melinite]

wondering of this helps.

http://jtds.sourceforge.net/TDS.html

maybe upgrade to Microsoft SQL Server JDBC Driver 2.0.

On Apr 11, 5:55 am, "Michael Hnat - bluegras" <m.h...@bluegras.de>
wrote: