Re: Please Help JDBC Error!!
От | Barry Lind |
---|---|
Тема | Re: Please Help JDBC Error!! |
Дата | |
Msg-id | 3B66DDD0.5010609@xythos.com обсуждение исходный текст |
Ответ на | Please Help JDBC Error!! ("Binoy" <binoyatpgsql@yahoo.com>) |
Список | pgsql-general |
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 > >
В списке pgsql-general по дате отправления:
Предыдущее
От: "Derek Pitts"Дата:
Сообщение: Connecting Ultradev on Win2k to PostgreSQL on Red Hat Linux