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

Hi,

First of call can you make sure you are using the latest source. There
are binaries at http://jdbc.fastcrypt.com

Second, my instincts are telling me that there is some sort of overflow
occurring with 6k records. Is there some way to reduce the size of the
resultset?

Dave

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Binoy
Sent: July 30, 2001 11:48 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Please Help JDBC Error!!


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.ja
va:1
08)
 at
org.opentools.minerva.jdbc.PreparedStatementInPool.executeQuery(Prepared
Stat
ementInPool.java:71)
 at
org.jboss.security.auth.spi.DatabaseServerLoginModule.getUsersPassword(D
atab
aseServerLoginModule.java:94)
 at
org.jboss.security.auth.spi.UsernamePasswordLoginModule.login(UsernamePa
sswo
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:52
8)
 at javax.security.auth.login.LoginContext.login(LoginContext.java:449)
 at
org.jboss.security.plugins.JaasSecurityManager.defaultLogin(JaasSecurity
Mana
ger.java:333)
 at
org.jboss.security.plugins.JaasSecurityManager.authenticate(JaasSecurity
Mana
ger.java:301)
 at
org.jboss.security.plugins.JaasSecurityManager.isValid(JaasSecurityManag
er.j
ava:193)
 at
org.jboss.jetty.JBossUserRealm$User.authenticate(JBossUserRealm.java:46)
 at
com.mortbay.HTTP.Handler.SecurityHandler.basicAuthenticated(SecurityHand
ler.
java:259)
 at
com.mortbay.HTTP.Handler.SecurityHandler.authenticatedInRole(SecurityHan
dler
.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.ja
va:1
08)
[Jetty]  at
org.opentools.minerva.jdbc.PreparedStatementInPool.executeQuery(Prepared
Stat
ementInPool.java:71)
[Jetty]  at
org.jboss.security.auth.spi.DatabaseServerLoginModule.getUsersPassword(D
atab
aseServerLoginModule.java:94)
[Jetty]  at
org.jboss.security.auth.spi.UsernamePasswordLoginModule.login(UsernamePa
sswo
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:52
8)
[Jetty]  at
javax.security.auth.login.LoginContext.login(LoginContext.java:449)
[Jetty]  at
org.jboss.security.plugins.JaasSecurityManager.defaultLogin(JaasSecurity
Mana
ger.java:333)
[Jetty]  at
org.jboss.security.plugins.JaasSecurityManager.authenticate(JaasSecurity
Mana
ger.java:301)
[Jetty]  at
org.jboss.security.plugins.JaasSecurityManager.isValid(JaasSecurityManag
er.j
ava:193)
[Jetty]  at
org.jboss.jetty.JBossUserRealm$User.authenticate(JBossUserRealm.java:46)
[Jetty]  at
com.mortbay.HTTP.Handler.SecurityHandler.basicAuthenticated(SecurityHand
ler.
java:259)
[Jetty]  at
com.mortbay.HTTP.Handler.SecurityHandler.authenticatedInRole(SecurityHan
dler
.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)


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly