Critical JBoss Isssue

[gothemilan]

Hi,

Help will be greatly appriciated.

We have apache and Jboss with mod_jk in Linux Machine configured.
And we are connecting our application with MSSQL Server 2000 SP4 in Windows 2003 Server. And we are facing some error with these configuration they are "Connection reset" and Broken Pipe""

And i've also include some of the error code:

------------------------------------------------------------------------
Broken pipe - ERROR
-----------------------------------------------------------------------
2008-05-06 08:54:40,893 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/].[jsp]] Servlet.service() for servlet jsp threw exception
com.inet.tds.SQLException: java.net.SocketException: Broken pipe
java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
at com.inet.tds.j.a(Unknown Source)
at com.inet.tds.a.a(Unknown Source)
at com.inet.tds.b.try(Unknown Source)
at com.inet.tds.b.executeQuery(Unknown Source)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:211)
--------------------------------------------------------------------------------------------------------------------------
Connection resrt - ERROR
-----------------------------------------------------------------------
2008-05-06 09:32:03,635 INFO [STDOUT] com.inet.tds.SQLException: java.net.SocketException: Connection reset
2008-05-06 09:32:03,635 INFO [STDOUT] java.net.SocketException: Connection reset
2008-05-06 09:32:03,636 INFO [STDOUT] at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:96)
2008-05-06 09:32:03,636 INFO [STDOUT] at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
2008-05-06 09:32:03,636 INFO [STDOUT] at com.inet.tds.j.a(Unknown Source)
2008-05-06 09:32:03,636 INFO [STDOUT] at com.inet.tds.a.a(Unknown Source)
2008-05-06 09:32:03,636 INFO [STDOUT] at com.inet.tds.b.try(Unknown Source)
2008-05-06 09:32:03,636 INFO [STDOUT] at com.inet.tds.b.execute(Unknown Source)
2008-05-06 09:32:03,636 INFO [STDOUT] at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:183)


----------------------------------------------------------------------------------------------------------------------------------
the above error code may help to find the solutions.

Thanks
Milan Gothe

[george001]

Hello,

This is not particularly on your topic but I have seen similar messages when trying to use the apache http-upload library with IIS 5.0 (I am not entirely sure on the version) the IIS server would end signals in a non standard fashion (completely disregarding the RFC specs) and this would cause the AJP connector to "malfunction" by detecting a not properly ended transmission i.e. do a trace on the line to see what is going on if you think your app is perfectly OK.

Another thing that I am not seeing here is what driver are you using for MSSQL, I hope it is the MS stuff:

org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:211)

If you are using hibernate I hope it is configured to use their driver.

Also make sure you can connect to the db with other tools. I had a case in which MSSQL server would not work until the latest XP patch was applied something to do with the firewall breaking SQL, no official statement on msdn.

And last but not least make sure you servlet will work with another MSSQL DB or a local one, switch you stuff to detect where the issue is. Post versions they may help other people steer you in the right direction I am not much into MSSQL and Java at the moment.

HTH,
George

[gothemilan]

Hi George,

Thanks for the reply.

I have my application using Apache 2.0.52 and JBoss4.0.3SP1 version configured in Enterprise Linux 4ES and database server MS-SQL Server 2000 in Windows 2003 Server.

And Apache and Jboss is integrated with mod_jk as a AJP13 connector. And 've configured JBoss in a default mode. How can we check whether the JBoss is running in the hibernet mode?

And i'm using Merlia driver for Database.I'd also like to tell you that it is working fine locally with the same configuration. And is it possible to send me some kind of detail procedures to test everything all the services.

Thanks
Milan Gothe