Please Help JDBC Error!! - Mailing list pgsql-general

Hi
I have been  using postgres database since last 7 months working on a
involving JBoss server as an application server and postgres database at
backend lately.. i noticed as the database started growing larger.. today
encountered some error while firing this query

select firstname , last name from mycustomers where firstname between 'A%'
and 'Z%'

the above query returns 6000 + records ;-)

I am using PostgreSQL 7.1.2 and JBoss2.2.2 with jetty 3.1

The error stack trace is :
[Jetty] An I/O error occured while reading from backend - Exception:
java.net.SocketException: Connection reset by peer: JVM_recv in socket input
stream read
Stack Trace:

java.net.SocketException: Connection reset by peer: JVM_recv in socket input
stream read
 at java.net.SocketInputStream.socketRead(Native Method)
 at java.net.SocketInputStream.read(Unknown Source)
 at java.io.BufferedInputStream.fill(Unknown Source)
 at java.io.BufferedInputStream.read(Unknown Source)
 at org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:181)
 at org.postgresql.Connection.ExecSQL(Connection.java:473)
 at org.postgresql.jdbc2.Statement.execute(Statement.java:294)
 at org.postgresql.jdbc2.Statement.executeQuery(Statement.java:59)
 at
org.postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:1
08)
 at
org.opentools.minerva.jdbc.PreparedStatementInPool.executeQuery(PreparedStat
ementInPool.java:71)
 at
org.jboss.security.auth.spi.DatabaseServerLoginModule.getUsersPassword(Datab
aseServerLoginModule.java:94)
 at
org.jboss.security.auth.spi.UsernamePasswordLoginModule.login(UsernamePasswo
rdLoginModule.java:82)
 at java.lang.reflect.Method.invoke(Native Method)
 at javax.security.auth.login.LoginContext.invoke(LoginContext.java:595)
 at javax.security.auth.login.LoginContext.access$000(LoginContext.java:125)
 at javax.security.auth.login.LoginContext$3.run(LoginContext.java:531)
 at java.security.AccessController.doPrivileged(Native Method)
 at
javax.security.auth.login.LoginContext.invokeModule(LoginContext.java:528)
 at javax.security.auth.login.LoginContext.login(LoginContext.java:449)
 at
org.jboss.security.plugins.JaasSecurityManager.defaultLogin(JaasSecurityMana
ger.java:333)
 at
org.jboss.security.plugins.JaasSecurityManager.authenticate(JaasSecurityMana
ger.java:301)
 at
org.jboss.security.plugins.JaasSecurityManager.isValid(JaasSecurityManager.j
ava:193)
 at org.jboss.jetty.JBossUserRealm$User.authenticate(JBossUserRealm.java:46)
 at
com.mortbay.HTTP.Handler.SecurityHandler.basicAuthenticated(SecurityHandler.
java:259)
 at
com.mortbay.HTTP.Handler.SecurityHandler.authenticatedInRole(SecurityHandler
.java:192)
 at
com.mortbay.HTTP.Handler.SecurityHandler.handle(SecurityHandler.java:163)
 at com.mortbay.HTTP.HandlerContext.handle(HandlerContext.java:956)
 at com.mortbay.HTTP.HandlerContext.handle(HandlerContext.java:913)
 at com.mortbay.HTTP.HttpServer.service(HttpServer.java:703)
 at com.mortbay.HTTP.HttpConnection.service(HttpConnection.java:508)
 at com.mortbay.HTTP.HttpConnection.handle(HttpConnection.java:347)
 at
com.mortbay.HTTP.SocketListener.handleConnection(SocketListener.java:107)
 at com.mortbay.Util.ThreadedServer.handle(ThreadedServer.java:294)
 at com.mortbay.Util.ThreadPool$PoolThreadRunnable.run(ThreadPool.java:613)
 at java.lang.Thread.run(Unknown Source)
End of Stack Trace

[Jetty]  at org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:184)
[Jetty]  at org.postgresql.Connection.ExecSQL(Connection.java:473)
[Jetty]  at org.postgresql.jdbc2.Statement.execute(Statement.java:294)
[Jetty]  at org.postgresql.jdbc2.Statement.executeQuery(Statement.java:59)
[Jetty]  at
org.postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:1
08)
[Jetty]  at
org.opentools.minerva.jdbc.PreparedStatementInPool.executeQuery(PreparedStat
ementInPool.java:71)
[Jetty]  at
org.jboss.security.auth.spi.DatabaseServerLoginModule.getUsersPassword(Datab
aseServerLoginModule.java:94)
[Jetty]  at
org.jboss.security.auth.spi.UsernamePasswordLoginModule.login(UsernamePasswo
rdLoginModule.java:82)
[Jetty]  at java.lang.reflect.Method.invoke(Native Method)
[Jetty]  at
javax.security.auth.login.LoginContext.invoke(LoginContext.java:595)
[Jetty]  at
javax.security.auth.login.LoginContext.access$000(LoginContext.java:125)
[Jetty]  at
javax.security.auth.login.LoginContext$3.run(LoginContext.java:531)
[Jetty]  at java.security.AccessController.doPrivileged(Native Method)
[Jetty]  at
javax.security.auth.login.LoginContext.invokeModule(LoginContext.java:528)
[Jetty]  at
javax.security.auth.login.LoginContext.login(LoginContext.java:449)
[Jetty]  at
org.jboss.security.plugins.JaasSecurityManager.defaultLogin(JaasSecurityMana
ger.java:333)
[Jetty]  at
org.jboss.security.plugins.JaasSecurityManager.authenticate(JaasSecurityMana
ger.java:301)
[Jetty]  at
org.jboss.security.plugins.JaasSecurityManager.isValid(JaasSecurityManager.j
ava:193)
[Jetty]  at
org.jboss.jetty.JBossUserRealm$User.authenticate(JBossUserRealm.java:46)
[Jetty]  at
com.mortbay.HTTP.Handler.SecurityHandler.basicAuthenticated(SecurityHandler.
java:259)
[Jetty]  at
com.mortbay.HTTP.Handler.SecurityHandler.authenticatedInRole(SecurityHandler
.java:192)
[Jetty]  at
com.mortbay.HTTP.Handler.SecurityHandler.handle(SecurityHandler.java:163)
[Jetty]  at com.mortbay.HTTP.HandlerContext.handle(HandlerContext.java:956)
[Jetty]  at com.mortbay.HTTP.HandlerContext.handle(HandlerContext.java:913)
[Jetty]  at com.mortbay.HTTP.HttpServer.service(HttpServer.java:703)
[Jetty]  at com.mortbay.HTTP.HttpConnection.service(HttpConnection.java:508)
[Jetty]  at com.mortbay.HTTP.HttpConnection.handle(HttpConnection.java:347)
[Jetty]  at
com.mortbay.HTTP.SocketListener.handleConnection(SocketListener.java:107)
[Jetty]  at com.mortbay.Util.ThreadedServer.handle(ThreadedServer.java:294)
[Jetty]  at
com.mortbay.Util.ThreadPool$PoolThreadRunnable.run(ThreadPool.java:613)
[Jetty]  at java.lang.Thread.run(Unknown Source)

I guess this is a jdbc error and i am stuck without the problem solved.. is
there any body who has faced this kind of problem yet.. and do you have a
probable solution please let me know

Cheers :-)

Binoy

Rishabh Software
(India)