SEO

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.java:503)
at org.postgresql.jdbc1.AbstractJdbc1Statement.execut e(AbstractJdbc1Statement.java:320)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execut e(AbstractJdbc2Statement.java:48)
at org.postgresql.jdbc1.AbstractJdbc1Statement.execut eUpdate(AbstractJdbc1Statement.java:197)
at org.postgresql.jdbc1.AbstractJdbc1Statement.execut eUpdate(AbstractJdbc1Statement.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(ApplicationFilterChain.java:200)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:146)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:209)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava: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.invokeNext(StandardPipeline.j ava: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.invokeNext(StandardPipeline.j ava:596)
at org.apache.catalina.valves.ErrorDispatcherValve.in voke(ErrorDispatcherValve.java:118)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:594)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:116)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava: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:127)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava: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.processConnection(Http11Protocol.jav a: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)

rajiv verma schrieb:
> I'm accessing postgres database through tomcat 4.3.1.

Hi!
This NG is about Progress not Postgres.

Chris

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)