From: | "Binoy" <binoyatpgsql(at)yahoo(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Please Help JDBC Error!! |
Date: | 2001-07-31 03:48:30 |
Message-ID: | 004d01c11973$ad4b4810$12c809c0@rsplsys18 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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)
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2001-07-31 08:56:12 | RE: Please Help JDBC Error!! |
Previous Message | Joshua D. Drake | 2001-07-31 00:38:10 | LXP PostgreSQL application server |