As someone mentioned, this is for Progress, not PostgreSQL. Two
different databases.

That said, are you sure about your database running as postgres on the
machine?

Are you sure you have a user connection on tomcat into postgreSQL with
permissions to INSERT, etc.

In article <f6217501.0504241358.4411e974@posting.google.com >,
verma.rk@gmail.com (rajiv verma) wrote:

> 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,traderId,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.AbstractJdbc1Connection.ExecS QL(AbstractJdbc1Connection.j
> ava:503)
> at
> org.postgresql.jdbc1.AbstractJdbc1Statement.execut e(AbstractJdbc1Statement.jav
> a:320)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execut e(AbstractJdbc2Statement.jav
> a:48)
> at
> org.postgresql.jdbc1.AbstractJdbc1Statement.execut eUpdate(AbstractJdbc1Stateme
> nt.java:197)
> at
> org.postgresql.jdbc1.AbstractJdbc1Statement.execut eUpdate(AbstractJdbc1Stateme
> nt.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.ApplicationFilterChain.in ternalDoFilter(ApplicationFi
> lterChain.java:200)
> at
> org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChai
> n.java:146)
> at
> org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java
> :209)
> at
> org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeN
> ext(StandardPipeline.java:596)
> at
> org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:433)
> at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:948)
> at
> org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java
> :144)
> at
> org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeN
> ext(StandardPipeline.java:596)
> at
> org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:433)
> at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:948)
> at
> org.apache.catalina.core.StandardContext.invoke(St andardContext.java:2358)
> at
> org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:133)
> at
> org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeN
> ext(StandardPipeline.java:596)
> at
> org.apache.catalina.valves.ErrorDispatcherValve.in voke(ErrorDispatcherValve.ja
> va:118)
> at
> org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeN
> ext(StandardPipeline.java:594)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:116)
> at
> org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeN
> ext(StandardPipeline.java:594)
> at
> org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:433)
> at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:948)
> at
> org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:1
> 27)
> at
> org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeN
> ext(StandardPipeline.java:596)
> at
> org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:433)
> at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:948)
> at org.apache.coyote.tomcat4.CoyoteAdapter.service(Co yoteAdapter.java:152)
> at
> org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:799)
> at
> org.apache.coyote.http11.Http11Protocol$Http11Conn ectionHandler.processConnect
> ion(Http11Protocol.java:705)
> at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(P oolTcpEndpoint.java:577)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:
> 683)
> at java.lang.Thread.run(Thread.java:536)