| Rajiv Verma 2005-04-24, 8:23 pm |
| I'm accessing postgres database through tomcat 4.3.1.
I'm able to execute the select and update query through my application
but Insert query is giving following SQLException :
Connection is closed. Operation is not permitted.
If I execute the same insert query by simple java program using jdbc
connection, It's working. But the same query is giving above exception
in tamcat.
Please help me. Thanx in advance.
following is the ExceptionStackTrace :
IN insert : insert into account(accNo,trader
Id,dbcNo,bal) values (1,
'rajiv', 1, 5000.0 )
Insertion Failed : Connection is closed. Operation is not permitted.
Connection is closed. Operation is not permitted.
at org.postgresql.jdbc1. AbstractJdbc1Connect
ion. ExecSQL(AbstractJdbc
1Connection.java:503)
at org.postgresql.jdbc1. AbstractJdbc1Stateme
nt. execute(AbstractJdbc
1Statement.java:320)
at org.postgresql.jdbc2. AbstractJdbc2Stateme
nt. execute(AbstractJdbc
2Statement.java:48)
at org.postgresql.jdbc1. AbstractJdbc1Stateme
nt. executeUpdate(Abstra
ctJdbc1Statement.java:197)
at org.postgresql.jdbc1. AbstractJdbc1Stateme
nt. executeUpdate(Abstra
ctJdbc1Statement.java:183)
at src.DataManager.Insert(DataManager.java:64)
at src.Bank.createAccount(Bank.java:149)
at src.Trader.getAccount(Trader.java:314)
at CreateAccount. doPost(CreateAccount
.java:144)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:716)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
at org.apache.catalina.core. ApplicationFilterCha
in. internalDoFilter(App
licationFilterChain.java:200)
at org.apache.catalina.core. ApplicationFilterCha
in. doFilter(Application
FilterChain.java:146)
at org.apache.catalina.core. StandardWrapperValve
. invoke(StandardWrapp
erValve.java:209)
at org.apache.catalina.core. StandardPipeline$Sta
ndardPipelineValveCo
ntext. invokeNext(StandardP
ipeline.java:596)
at org.apache.catalina.core.StandardPipeline. invoke(StandardPipel
ine.java:433)
at org.apache.catalina.core.ContainerBase. invoke(ContainerBase
.java:948)
at org.apache.catalina.core. StandardContextValve
. invoke(StandardConte
xtValve.java:144)
at org.apache.catalina.core. StandardPipeline$Sta
ndardPipelineValveCo
ntext. invokeNext(StandardP
ipeline.java:596)
at org.apache.catalina.core.StandardPipeline. invoke(StandardPipel
ine.java:433)
at org.apache.catalina.core.ContainerBase. invoke(ContainerBase
.java:948)
at org.apache.catalina.core.StandardContext. invoke(StandardConte
xt.java:2358)
at org.apache.catalina.core.StandardHostValve. invoke(StandardHostV
alve.java:133)
at org.apache.catalina.core. StandardPipeline$Sta
ndardPipelineValveCo
ntext. invokeNext(StandardP
ipeline.java:596)
at org.apache.catalina.valves. ErrorDispatcherValve
. invoke(ErrorDispatch
erValve.java:118)
at org.apache.catalina.core. StandardPipeline$Sta
ndardPipelineValveCo
ntext. invokeNext(StandardP
ipeline.java:594)
at org.apache.catalina.valves.ErrorReportValve. invoke(ErrorReportVa
lve.java:116)
at org.apache.catalina.core. StandardPipeline$Sta
ndardPipelineValveCo
ntext. invokeNext(StandardP
ipeline.java:594)
at org.apache.catalina.core.StandardPipeline. invoke(StandardPipel
ine.java:433)
at org.apache.catalina.core.ContainerBase. invoke(ContainerBase
.java:948)
at org.apache.catalina.core.StandardEngineValve. invoke(StandardEngin
eValve.java:127)
at org.apache.catalina.core. StandardPipeline$Sta
ndardPipelineValveCo
ntext. invokeNext(StandardP
ipeline.java:596)
at org.apache.catalina.core.StandardPipeline. invoke(StandardPipel
ine.java:433)
at org.apache.catalina.core.ContainerBase. invoke(ContainerBase
.java:948)
at org.apache.coyote.tomcat4.CoyoteAdapter. service(CoyoteAdapte
r.java:152)
at org.apache.coyote.http11.Http11Processor. process(Http11Proces
sor.java:799)
at org.apache.coyote.http11. Http11Protocol$Http1
1ConnectionHandler. processConnection(Ht
tp11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread. runIt(PoolTcpEndpoin
t.java:577)
at org.apache.tomcat.util.threads. ThreadPool$ControlRu
nnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:536)
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
|