Thread: Please Help JDBC Error!!

Please Help JDBC Error!!

From

"Binoy"

Date:

31 July 2001, 02:44:48

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)

RE: Please Help JDBC Error!!

From

"Dave Cramer"

Date:

31 July 2001, 07:59:15

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

Re: Please Help JDBC Error!!

From

Barry Lind

Date:

31 July 2001, 19:07:10

Binoy,

What would be more informative is what error was reported on the
postgresql server (I am assuming you have logging for the server
enabled).  This JDBC client trace only indicates that the server dropped
the socket connection.  The real issue is why the server did that.

thanks,
--Barry

Binoy wrote:

> 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)
>
>
> ---------------------------(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
>
>