PSQLException instead of java.net.SocketException
От | Nico |
---|---|
Тема | PSQLException instead of java.net.SocketException |
Дата | |
Msg-id | cr8r9n$1v2p$1@news.hub.org обсуждение исходный текст |
Ответы |
Re: PSQLException instead of java.net.SocketException
Re: PSQLException instead of java.net.SocketException |
Список | pgsql-jdbc |
Each time I initiate my servlet, I get an exception. It is thrown when I call the executeQuery method of a statement instance. He throws a PSQLException. However, when I take a look at the stack trace, it appears to be a java.net.SocketException was thrown. My best guess is the exception was catched and a PSQLException was thrown in the catch block. I already have a catch block for PSQLException which is designed to warn me for SQL syntax errors, not socket exceptions. So I want to make an additional catch block for a java.net.SocketException. However I don't know how. Can someone please help me here? Reason I want to do this: I can't solve sql syntax errors automatically, but I can solve socketexceptions automatically by just refreshing the window on the client side. However if someone can solve the cause in stead of the catching exception, that's even better. here is the exception: An I/O error has occured while flushing the output - Exception: java.net.SocketException: Socket closed here is part of the stack trace: java.net.SocketException: Socket closed at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:99) at java.net.SocketOutputStream.write(SocketOutputStream.java:136) at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:66) at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:124) at org.postgresql.PG_Stream.flush(PG_Stream.java:352) at org.postgresql.core.QueryExecutor.sendQuery(QueryExecutor.java:159) at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:70) at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505) at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:153) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:141) at menus.DBMenu.getQuery(DBMenu.java:705) at menus.DBMenu.Menupage(DBMenu.java:165) at menus.DBMenuShow.doGet(DBMenuShow.java:132) Nico.
В списке pgsql-jdbc по дате отправления: