RE: Please Help JDBC Error!!

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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Binoy
Sent: July 30, 2001 11:48 PM
To: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly