X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 0AD9C474E5C for ; Fri, 7 Feb 2003 02:47:45 -0500 (EST) Received: from qube.efkonasia.com.my (unknown [210.19.88.130]) by postgresql.org (Postfix) with ESMTP id 89526474E4F for ; Fri, 7 Feb 2003 02:47:32 -0500 (EST) Received: from waimeng ([10.0.1.14]) by qube.efkonasia.com.my (8.9.3/8.9.2) with SMTP id PAA15965 for ; Fri, 7 Feb 2003 15:28:33 +0800 Message-ID: <001c01c2ce7d$faabeb80$0e01000a@waimeng> From: "waimeng" To: Subject: PostgreSQL 7.3.1 multiple schema select query error: java.sql.SQLException: ERROR: parser: parse error at or near "." Date: Fri, 7 Feb 2003 15:53:18 +0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0019_01C2CEC1.08411C50" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/136 X-Sequence-Number: 11534 This is a multi-part message in MIME format. ------=_NextPart_000_0019_01C2CEC1.08411C50 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am using postgresql 7.3.1 on windows 2000. I downloaded the lattest postg= res jdbc driver for version 7.3.1, called pg73jdbc3.jar and using JBoss-3.04_Tomcat-4.0.6. I created one database called 'testdb', and a scheme called 'sc_test', with= a table called 'tbl_company' under the sc_test scheme. When i execute the following query from java code, i get the following erro= r: java.sql.Statement stmt1 =3D conn.createStatement(); Resultset rs =3D stmt1.executeQuery("SELECT * FROM sc_test.tbl_company"); 15:43:39,877 ERROR [STDERR] java.sql.SQLException: ERROR: parser: parse er= ror at or near "." 15:43:39,877 ERROR [STDERR] at org.postgresql.core.QueryExecutor.execut= e(QueryExecutor.java:131) 15:43:39,877 ERROR [STDERR] at org.postgresql.jdbc1.AbstractJdbc1Connec= tion.ExecSQL(AbstractJdbc1Connection.java:505 ) 15:43:39,888 ERROR [STDERR] at org.postgresql.jdbc1.AbstractJdbc1Statem= ent.execute(AbstractJdbc1Statement.java:320) 15:43:39,888 ERROR [STDERR] at org.postgresql.jdbc2.AbstractJdbc2Statem= ent.execute(AbstractJdbc2Statement.java:48) 15:43:39,888 ERROR [STDERR] at org.postgresql.jdbc1.AbstractJdbc1Statem= ent.executeQuery(AbstractJdbc1Statement.java: 153) 15:43:39,898 ERROR [STDERR] at org.postgresql.jdbc1.AbstractJdbc1Statem= ent.executeQuery(AbstractJdbc1Statement.java: 141) 15:43:39,908 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.local.Lo= calStatement.executeQuery(LocalStatement.java :211) 15:43:39,908 ERROR [STDERR] at com.ilium.eapps.compmenu.dao.GenericModu= leDAO.list(GenericModuleDAO.java:246) 15:43:39,908 ERROR [STDERR] at com.ilium.eapps.compmenu.ejb.sb.SBModule= Bean.getList(SBModuleBean.java:258) 15:43:39,918 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.inv= oke0(Native Method) 15:43:39,918 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.inv= oke(NativeMethodAccessorImpl.java:39) 15:43:39,918 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl= .invoke(DelegatingMethodAccessorImpl.java:25) 15:43:39,928 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.j= ava:324) 15:43:39,928 ERROR [STDERR] at org.jboss.ejb.StatelessSessionContainer$= ContainerInterceptor.invoke(StatelessSessionC ontainer.java:660) 15:43:39,938 ERROR [STDERR] at org.jboss.resource.connectionmanager.Cac= hedConnectionInterceptor.invoke(CachedConnect ionInterceptor.java:186) 15:43:39,938 ERROR [STDERR] at org.jboss.ejb.plugins.StatelessSessionIn= stanceInterceptor.invoke(StatelessSessionInst anceInterceptor.java:77) 15:43:39,948 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxIntercep= tor.invokeNext(AbstractTxInterceptor.java:107 ) 15:43:39,948 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.r= unWithTransactions(TxInterceptorCMT.java:178) 15:43:39,958 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.i= nvoke(TxInterceptorCMT.java:60) 15:43:39,958 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityIntercepto= r.invoke(SecurityInterceptor.java:130) 15:43:39,958 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.inv= oke(LogInterceptor.java:204) 15:43:39,968 ERROR [STDERR] at org.jboss.ejb.StatelessSessionContainer.= invoke(StatelessSessionContainer.java:313) 15:43:39,968 ERROR [STDERR] at org.jboss.ejb.Container.invoke(Container= .java:712) 15:43:39,968 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invo= ke(MBeanServerImpl.java:517) 15:43:39,978 ERROR [STDERR] at org.jboss.invocation.local.LocalInvoker.= invoke(LocalInvoker.java:98) 15:43:39,978 ERROR [STDERR] at org.jboss.invocation.InvokerInterceptor.= invoke(InvokerInterceptor.java:102) 15:43:39,978 ERROR [STDERR] at org.jboss.proxy.TransactionInterceptor.i= nvoke(TransactionInterceptor.java:77) 15:43:39,988 ERROR [STDERR] at org.jboss.proxy.SecurityInterceptor.invo= ke(SecurityInterceptor.java:80) 15:43:39,988 ERROR [STDERR] at org.jboss.proxy.ejb.StatelessSessionInte= rceptor.invoke(StatelessSessionInterceptor.ja va:111) 15:43:39,988 ERROR [STDERR] at org.jboss.proxy.ClientContainer.invoke(C= lientContainer.java:76) 15:43:39,998 ERROR [STDERR] at $Proxy33.getList(Unknown Source) 15:43:39,998 ERROR [STDERR] at com.ilium.eapps.compmenu.controller.Modu= leAction.performList(ModuleAction.java:163) 15:43:39,998 ERROR [STDERR] at com.ilium.eapps.compmenu.controller.Modu= leAction.execute(ModuleAction.java:131) 15:43:40,008 ERROR [STDERR] at org.apache.struts.action.RequestProcesso= r.processActionPerform(RequestProcessor.java: 465) 15:43:40,008 ERROR [STDERR] at org.apache.struts.action.RequestProcesso= r.process(RequestProcessor.java:274) 15:43:40,008 ERROR [STDERR] at org.apache.struts.action.ActionServlet.p= rocess(ActionServlet.java:1422) 15:43:40,018 ERROR [STDERR] at org.apache.struts.action.ActionServlet.d= oGet(ActionServlet.java:505) 15:43:40,018 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(H= ttpServlet.java:740) 15:43:40,018 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(H= ttpServlet.java:853) 15:43:40,028 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilt= erChain.internalDoFilter(ApplicationFilterCha in.java:247) 15:43:40,028 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilt= erChain.doFilter(ApplicationFilterChain.java: 193) 15:43:40,038 ERROR [STDERR] at com.ilium.eapps.syswar.filter.SetCharact= erEncodingFilter.doFilter(SetCharacterEncodin gFilter.java:147) 15:43:40,038 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilt= erChain.internalDoFilter(ApplicationFilterCha in.java:213) 15:43:40,048 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilt= erChain.doFilter(ApplicationFilterChain.java: 193) 15:43:40,048 ERROR [STDERR] at org.apache.catalina.core.StandardWrapper= Valve.invoke(StandardWrapperValve.java:243) 15:43:40,058 ERROR [STDERR] at org.apache.catalina.core.StandardPipelin= e.invokeNext(StandardPipeline.java:566) 15:43:40,058 ERROR [STDERR] at org.apache.catalina.core.StandardPipelin= e.invoke(StandardPipeline.java:472) 15:43:40,058 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.i= nvoke(ContainerBase.java:943) 15:43:40,068 ERROR [STDERR] at org.apache.catalina.core.StandardContext= Valve.invoke(StandardContextValve.java:190) 15:43:40,068 ERROR [STDERR] at org.apache.catalina.core.StandardPipelin= e.invokeNext(StandardPipeline.java:566) 15:43:40,068 ERROR [STDERR] at org.apache.catalina.valves.CertificatesV= alve.invoke(CertificatesValve.java:246) 15:43:40,068 ERROR [STDERR] at org.apache.catalina.core.StandardPipelin= e.invokeNext(StandardPipeline.java:564) 15:43:40,078 ERROR [STDERR] at org.apache.catalina.core.StandardPipelin= e.invoke(StandardPipeline.java:472) 15:43:40,078 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.i= nvoke(ContainerBase.java:943) 15:43:40,078 ERROR [STDERR] at org.apache.catalina.core.StandardContext= .invoke(StandardContext.java:2347) 15:43:40,088 ERROR [STDERR] at org.apache.catalina.core.StandardHostVal= ve.invoke(StandardHostValve.java:180) 15:43:40,088 ERROR [STDERR] at org.apache.catalina.core.StandardPipelin= e.invokeNext(StandardPipeline.java:566) 15:43:40,088 ERROR [STDERR] at org.apache.catalina.valves.ErrorDispatch= erValve.invoke(ErrorDispatcherValve.java:170) 15:43:40,098 ERROR [STDERR] at org.apache.catalina.core.StandardPipelin= e.invokeNext(StandardPipeline.java:564) 15:43:40,098 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportVa= lve.invoke(ErrorReportValve.java:170) 15:43:40,098 ERROR [STDERR] at org.apache.catalina.core.StandardPipelin= e.invokeNext(StandardPipeline.java:564) 15:43:40,108 ERROR [STDERR] at org.apache.catalina.valves.AccessLogValv= e.invoke(AccessLogValve.java:468) 15:43:40,108 ERROR [STDERR] at org.apache.catalina.core.StandardPipelin= e.invokeNext(StandardPipeline.java:564) 15:43:40,108 ERROR [STDERR] at org.apache.catalina.core.StandardPipelin= e.invoke(StandardPipeline.java:472) 15:43:40,108 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.i= nvoke(ContainerBase.java:943) 15:43:40,118 ERROR [STDERR] at org.apache.catalina.core.StandardEngineV= alve.invoke(StandardEngineValve.java:174) 15:43:40,118 ERROR [STDERR] at org.apache.catalina.core.StandardPipelin= e.invokeNext(StandardPipeline.java:566) 15:43:40,118 ERROR [STDERR] at org.apache.catalina.core.StandardPipelin= e.invoke(StandardPipeline.java:472) 15:43:40,128 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.i= nvoke(ContainerBase.java:943) 15:43:40,128 ERROR [STDERR] at org.apache.catalina.connector.http.HttpP= rocessor.process(HttpProcessor.java:1027) 15:43:40,128 ERROR [STDERR] at org.apache.catalina.connector.http.HttpP= rocessor.run(HttpProcessor.java:1125) 15:43:40,128 ERROR [STDERR] at java.lang.Thread.run(Thread.java:536) What would the possible cause of the error?? The above query run fine when using pgadmin2 client. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 1/27/2003 ------=_NextPart_000_0019_01C2CEC1.08411C50 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I am using postgresql 7.3.1 on windows 200= 0. I=20 downloaded the lattest postgres jdbc driver
for version 7.3.1, called=20 pg73jdbc3.jar and using JBoss-3.04_Tomcat-4.0.6.
 
I created one database called 'testdb', an= d a=20 scheme called 'sc_test', with a table called 'tbl_company' under the sc_tes= t=20 scheme.
When i execute the following query from java code, i get the=20 following error:
 
java.sql.Statement stmt1 =3D=20 conn.createStatement();
Resultset rs =3D stmt1.executeQuery("SELECT * FR= OM=20 sc_test.tbl_company");
 

15:43:39,877 ERROR [STDERR] java.sql.SQLException: ERROR:  pa= rser:=20 parse error at or near "."
15:43:39,877 ERROR=20 [STDERR]     at=20 org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
15:43:= 39,877=20 ERROR [STDERR]     at=20 org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connectio= n.java:505
)
15:43:39,888=20 ERROR [STDERR]     at=20 org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.= java:320)
15:43:39,888=20 ERROR [STDERR]     at=20 org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.= java:48)
15:43:39,888=20 ERROR [STDERR]     at=20 org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1State= ment.java:
153)
15:43:39,898=20 ERROR [STDERR]     at=20 org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1State= ment.java:
141)
15:43:39,908=20 ERROR [STDERR]     at=20 org.jboss.resource.adapter.jdbc.local.LocalStatement.executeQuery(LocalStat= ement.java
:211)
15:43:39,908=20 ERROR [STDERR]     at=20 com.ilium.eapps.compmenu.dao.GenericModuleDAO.list(GenericModuleDAO.java:24= 6)
15:43:39,908=20 ERROR [STDERR]     at=20 com.ilium.eapps.compmenu.ejb.sb.SBModuleBean.getList(SBModuleBean.java:258)=
15:43:39,918=20 ERROR [STDERR]     at=20 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
15:43:39,918= =20 ERROR [STDERR]     at=20 sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3= 9)
15:43:39,918=20 ERROR [STDERR]     at=20 sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp= l.java:25)
 
15:43:39,928 ERROR [STDERR]     at=20 java.lang.reflect.Method.invoke(Method.java:324)
15:43:39,928 ERROR=20 [STDERR]     at=20 org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(Statele= ssSessionC
ontainer.java:660)
15:43:39,938=20 ERROR [STDERR]     at=20 org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(Cac= hedConnect
ionInterceptor.java:186)
15:43:39,938=20 ERROR [STDERR]     at=20 org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessS= essionInst
anceInterceptor.java:77)
15:43:39,948=20 ERROR [STDERR]     at=20 org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxIntercepto= r.java:107
)
15:43:39,948=20 ERROR [STDERR]     at=20 org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT= .java:178)
 
15:43:39,958 ERROR [STDERR]     at=20 org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:60)
= 15:43:39,958=20 ERROR [STDERR]     at=20 org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:1= 30)
15:43:39,958=20 ERROR [STDERR]     at=20 org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:204)
15:= 43:39,968=20 ERROR [STDERR]     at=20 org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.ja= va:313)
15:43:39,968=20 ERROR [STDERR]     at=20 org.jboss.ejb.Container.invoke(Container.java:712)
15:43:39,968 ERROR=20 [STDERR]     at=20 org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
15:= 43:39,978=20 ERROR [STDERR]     at=20 org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:98)
15:= 43:39,978=20 ERROR [STDERR]     at=20 org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:102)=
15:43:39,978=20 ERROR [STDERR]     at=20 org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:7= 7)
15:43:39,988=20 ERROR [STDERR]     at=20 org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:80)
= 15:43:39,988=20 ERROR [STDERR]     at=20 org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInte= rceptor.ja
va:111)
15:43:39,988=20 ERROR [STDERR]     at=20 org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:76)
15:43:39= ,998=20 ERROR [STDERR]     at $Proxy33.getList(Unknown=20 Source)
15:43:39,998 ERROR [STDERR]     at=20 com.ilium.eapps.compmenu.controller.ModuleAction.performList(ModuleAction.j= ava:163)
15:43:39,998=20 ERROR [STDERR]     at=20 com.ilium.eapps.compmenu.controller.ModuleAction.execute(ModuleAction.java:= 131)
15:43:40,008=20 ERROR [STDERR]     at=20 org.apache.struts.action.RequestProcessor.processActionPerform(RequestProce= ssor.java:
465)
15:43:40,008=20 ERROR [STDERR]     at=20 org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274= )
15:43:40,008=20 ERROR [STDERR]     at=20 org.apache.struts.action.ActionServlet.process(ActionServlet.java:1422)
= 15:43:40,018=20 ERROR [STDERR]     at=20 org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:505)
15:= 43:40,018=20 ERROR [STDERR]     at=20 javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
15:43:40,01= 8=20 ERROR [STDERR]     at=20 javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
15:43:40,02= 8=20 ERROR [STDERR]     at=20 org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio= nFilterCha
in.java:247)
15:43:40,028=20 ERROR [STDERR]     at=20 org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC= hain.java:
193)
15:43:40,038=20 ERROR [STDERR]     at=20 com.ilium.eapps.syswar.filter.SetCharacterEncodingFilter.doFilter(SetCharac= terEncodin
gFilter.java:147)
15:43:40,038=20 ERROR [STDERR]     at=20 org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio= nFilterCha
in.java:213)
15:43:40,048=20 ERROR [STDERR]     at=20 org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC= hain.java:
193)
15:43:40,048=20 ERROR [STDERR]     at=20 org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.j= ava:243)
15:43:40,058=20 ERROR [STDERR]     at=20 org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:= 566)
15:43:40,058=20 ERROR [STDERR]     at=20 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)=
15:43:40,058=20 ERROR [STDERR]     at=20 org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
15= :43:40,068=20 ERROR [STDERR]     at=20 org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.j= ava:190)
15:43:40,068=20 ERROR [STDERR]     at=20 org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:= 566)
15:43:40,068=20 ERROR [STDERR]     at=20 org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:= 246)
15:43:40,068=20 ERROR [STDERR]     at=20 org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:= 564)
15:43:40,078=20 ERROR [STDERR]     at=20 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)=
15:43:40,078=20 ERROR [STDERR]     at=20 org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
15= :43:40,078=20 ERROR [STDERR]     at=20 org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)<= BR>15:43:40,088=20 ERROR [STDERR]     at=20 org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:18= 0)
15:43:40,088=20 ERROR [STDERR]     at=20 org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:= 566)
15:43:40,088=20 ERROR [STDERR]     at=20 org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve= .java:170)
 
15:43:40,098 ERROR [STDERR]     at=20 org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:= 564)
15:43:40,098=20 ERROR [STDERR]     at=20 org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:17= 0)
15:43:40,098=20 ERROR [STDERR]     at=20 org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:= 564)
15:43:40,108=20 ERROR [STDERR]     at=20 org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)15:43:40,108=20 ERROR [STDERR]     at=20 org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:= 564)
15:43:40,108=20 ERROR [STDERR]     at=20 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)=
15:43:40,108=20 ERROR [STDERR]     at=20 org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
15= :43:40,118=20 ERROR [STDERR]     at=20 org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.jav= a:174)
15:43:40,118=20 ERROR [STDERR]     at=20 org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:= 566)
15:43:40,118=20 ERROR [STDERR]     at=20 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)=
15:43:40,128=20 ERROR [STDERR]     at=20 org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
15= :43:40,128=20 ERROR [STDERR]     at=20 org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java= :1027)
15:43:40,128=20 ERROR [STDERR]     at=20 org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:112= 5)
15:43:40,128=20 ERROR [STDERR]     at=20 java.lang.Thread.run(Thread.java:536)
 

What would the possible cause of the error??
The above query ru= n=20 fine when using pgadmin2 client.
 
 

---
Outgoing mail is certified Virus Free.
Checked by AVG=20 anti-virus system (http://www.grisoft.com).
Version: 6.= 0.449 /=20 Virus Database: 251 - Release Date: 1/27/2003
------=_NextPart_000_0019_01C2CEC1.08411C50--