pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL 7.3.1 multiple schema select query error: java.sql.SQLException: ERROR: parser: parse error at or near "."
3+ messages / 2 participants
[nested] [flat]
* PostgreSQL 7.3.1 multiple schema select query error: java.sql.SQLException: ERROR: parser: parse error at or near "."
@ 2003-02-07 07:53 waimeng <waimeng@efkonasia.com.my>
0 siblings, 0 replies; 3+ messages in thread
From: waimeng @ 2003-02-07 07:53 UTC (permalink / raw)
To: pgsql-sql
I am using postgresql 7.3.1 on windows 2000. I downloaded the lattest postgres 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 error:
java.sql.Statement stmt1 = conn.createStatement();
Resultset rs = stmt1.executeQuery("SELECT * FROM sc_test.tbl_company");
15:43:39,877 ERROR [STDERR] java.sql.SQLException: ERROR: parser: parse error at or near "."
15:43:39,877 ERROR [STDERR] at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
15:43:39,877 ERROR [STDERR] at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505
)
15:43:39,888 ERROR [STDERR] at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320)
15:43:39,888 ERROR [STDERR] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48)
15:43:39,888 ERROR [STDERR] at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:
153)
15:43:39,898 ERROR [STDERR] at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:
141)
15:43:39,908 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.local.LocalStatement.executeQuery(LocalStatement.java
:211)
15:43:39,908 ERROR [STDERR] at com.ilium.eapps.compmenu.dao.GenericModuleDAO.list(GenericModuleDAO.java:246)
15:43:39,908 ERROR [STDERR] at com.ilium.eapps.compmenu.ejb.sb.SBModuleBean.getList(SBModuleBean.java:258)
15:43:39,918 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
15:43:39,918 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(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.java: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.CachedConnectionInterceptor.invoke(CachedConnect
ionInterceptor.java:186)
15:43:39,938 ERROR [STDERR] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInst
anceInterceptor.java:77)
15:43:39,948 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:107
)
15:43:39,948 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:178)
15:43:39,958 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:60)
15:43:39,958 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:130)
15:43:39,958 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invoke(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.invoke(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.invoke(TransactionInterceptor.java:77)
15:43:39,988 ERROR [STDERR] at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:80)
15:43:39,988 ERROR [STDERR] at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.ja
va:111)
15:43:39,988 ERROR [STDERR] at org.jboss.proxy.ClientContainer.invoke(ClientContainer.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.ModuleAction.performList(ModuleAction.java:163)
15:43:39,998 ERROR [STDERR] at com.ilium.eapps.compmenu.controller.ModuleAction.execute(ModuleAction.java:131)
15:43:40,008 ERROR [STDERR] at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:
465)
15:43:40,008 ERROR [STDERR] at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
15:43:40,008 ERROR [STDERR] at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1422)
15:43:40,018 ERROR [STDERR] at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:505)
15:43:40,018 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
15:43:40,018 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
15:43:40,028 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterCha
in.java:247)
15:43:40,028 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:
193)
15:43:40,038 ERROR [STDERR] at com.ilium.eapps.syswar.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodin
gFilter.java:147)
15:43:40,038 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterCha
in.java:213)
15:43:40,048 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:
193)
15:43:40,048 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
15:43:40,058 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
15:43:40,058 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
15:43:40,058 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
15:43:40,068 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
15:43:40,068 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
15:43:40,068 ERROR [STDERR] at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
15:43:40,068 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
15:43:40,078 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
15:43:40,078 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke(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.StandardHostValve.invoke(StandardHostValve.java:180)
15:43:40,088 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
15:43:40,088 ERROR [STDERR] at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
15:43:40,098 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
15:43:40,098 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
15:43:40,098 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
15:43:40,108 ERROR [STDERR] at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
15:43:40,108 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
15:43:40,108 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
15:43:40,108 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
15:43:40,118 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
15:43:40,118 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
15:43:40,118 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
15:43:40,128 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
15:43:40,128 ERROR [STDERR] at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027)
15:43:40,128 ERROR [STDERR] at org.apache.catalina.connector.http.HttpProcessor.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
^ permalink raw reply [nested|flat] 3+ messages in thread
* PostgreSQL 7.3.1 multiple schema select query error: java.sql.SQLException: ERROR: parser: parse error at or near "."
@ 2003-02-07 08:29 waimeng <waimeng@efkonasia.com.my>
0 siblings, 1 reply; 3+ messages in thread
From: waimeng @ 2003-02-07 08:29 UTC (permalink / raw)
To: pgsql-sql
I am using postgresql 7.3.1 on windows 2000. I downloaded the lattest
postgres 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
error:
java.sql.Statement stmt1 = conn.createStatement();
Resultset rs = stmt1.executeQuery("SELECT * FROM sc_test.tbl_company");
15:43:39,877 ERROR [STDERR] java.sql.SQLException: ERROR: parser: parse
error at or near "."
15:43:39,877 ERROR [STDERR] at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
15:43:39,877 ERROR [STDERR] at
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection
.java:505
)
15:43:39,888 ERROR [STDERR] at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.j
ava:320)
15:43:39,888 ERROR [STDERR] at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j
ava:48)
15:43:39,888 ERROR [STDERR] at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statem
ent.java:
153)
15:43:39,898 ERROR [STDERR] at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statem
ent.java:
141)
15:43:39,908 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.local.LocalStatement.executeQuery(LocalState
ment.java
:211)
15:43:39,908 ERROR [STDERR] at
com.ilium.eapps.compmenu.dao.GenericModuleDAO.list(GenericModuleDAO.java:246
)
15:43:39,908 ERROR [STDERR] at
com.ilium.eapps.compmenu.ejb.sb.SBModuleBean.getList(SBModuleBean.java:258)
15:43:39,918 ERROR [STDERR] at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
15:43:39,918 ERROR [STDERR] at
sun.reflect.NativeMethodAccessorImpl.invoke(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.java:324)
15:43:39,928 ERROR [STDERR] at
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(Stateles
sSessionC
ontainer.java:660)
15:43:39,938 ERROR [STDERR] at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(Cach
edConnect
ionInterceptor.java:186)
15:43:39,938 ERROR [STDERR] at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSe
ssionInst
anceInterceptor.java:77)
15:43:39,948 ERROR [STDERR] at
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor
.java:107
)
15:43:39,948 ERROR [STDERR] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.
java:178)
15:43:39,958 ERROR [STDERR] at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:60)
15:43:39,958 ERROR [STDERR] at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:13
0)
15:43:39,958 ERROR [STDERR] at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:204)
15:43:39,968 ERROR [STDERR] at
org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.jav
a: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.invoke(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.invoke(TransactionInterceptor.java:77
)
15:43:39,988 ERROR [STDERR] at
org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:80)
15:43:39,988 ERROR [STDERR] at
org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInter
ceptor.ja
va:111)
15:43:39,988 ERROR [STDERR] at
org.jboss.proxy.ClientContainer.invoke(ClientContainer.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.ModuleAction.performList(ModuleAction.ja
va:163)
15:43:39,998 ERROR [STDERR] at
com.ilium.eapps.compmenu.controller.ModuleAction.execute(ModuleAction.java:1
31)
15:43:40,008 ERROR [STDERR] at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces
sor.java:
465)
15:43:40,008 ERROR [STDERR] at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
15:43:40,008 ERROR [STDERR] at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1422)
15:43:40,018 ERROR [STDERR] at
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:505)
15:43:40,018 ERROR [STDERR] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
15:43:40,018 ERROR [STDERR] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
15:43:40,028 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterCha
in.java:247)
15:43:40,028 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:
193)
15:43:40,038 ERROR [STDERR] at
com.ilium.eapps.syswar.filter.SetCharacterEncodingFilter.doFilter(SetCharact
erEncodin
gFilter.java:147)
15:43:40,038 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterCha
in.java:213)
15:43:40,048 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:
193)
15:43:40,048 ERROR [STDERR] at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:243)
15:43:40,058 ERROR [STDERR] at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
15:43:40,058 ERROR [STDERR] at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
15:43:40,058 ERROR [STDERR] at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
15:43:40,068 ERROR [STDERR] at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:190)
15:43:40,068 ERROR [STDERR] at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
15:43:40,068 ERROR [STDERR] at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2
46)
15:43:40,068 ERROR [STDERR] at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
15:43:40,078 ERROR [STDERR] at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
15:43:40,078 ERROR [STDERR] at
org.apache.catalina.core.ContainerBase.invoke(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.StandardHostValve.invoke(StandardHostValve.java:180
)
15:43:40,088 ERROR [STDERR] at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
15:43:40,088 ERROR [STDERR] at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:170)
15:43:40,098 ERROR [STDERR] at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
15:43:40,098 ERROR [STDERR] at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170
)
15:43:40,098 ERROR [STDERR] at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
15:43:40,108 ERROR [STDERR] at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
15:43:40,108 ERROR [STDERR] at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
15:43:40,108 ERROR [STDERR] at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
15:43:40,108 ERROR [STDERR] at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
15:43:40,118 ERROR [STDERR] at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:174)
15:43:40,118 ERROR [STDERR] at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
15:43:40,118 ERROR [STDERR] at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
15:43:40,128 ERROR [STDERR] at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
15:43:40,128 ERROR [STDERR] at
org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:
1027)
15:43:40,128 ERROR [STDERR] at
org.apache.catalina.connector.http.HttpProcessor.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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: PostgreSQL 7.3.1 multiple schema select query error:
@ 2003-02-07 13:03 Achilleus Mantzios <achill@matrix.gatewaynet.com>
parent: waimeng <waimeng@efkonasia.com.my>
0 siblings, 0 replies; 3+ messages in thread
From: Achilleus Mantzios @ 2003-02-07 13:03 UTC (permalink / raw)
To: waimeng <waimeng@efkonasia.com.my>; +Cc: pgsql-sql
On Fri, 7 Feb 2003, waimeng wrote:
The Exception is thrown in
public java.sql.ResultSet execute()
method of QueryExecutor.java
This method implements the native protocol of postgres server/client
communication.
So, the message is actually from the backend.
See line 104:
errorMessage.append(pg_stream.ReceiveString(connection.getEncoding()));
and then
if ( errorMessage != null )
throw new SQLException( errorMessage.toString());
and thats where you get your Exception.
Be sure you have the right postgres-service.xml
in /usr/local/jboss-3.0.3/server/default/deploy/.
(or whatever it is for windows).
(Could it be that you are pointing to a 7.2.x backend??)
Also place your postgres jdbc driver in /usr/local/jboss-3.0.3/lib/
Do a simple test
Quit any app that uses the DB.
start your jboss, and then invoke some pages that use your database.
then do
ps -ax | grep postgres
Do you see any lines???
If yes then are you sure you are running 7.3.1???
If no then you are hitting another server.
>
> I am using postgresql 7.3.1 on windows 2000. I downloaded the lattest
> postgres 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
> error:
>
> java.sql.Statement stmt1 = conn.createStatement();
> Resultset rs = stmt1.executeQuery("SELECT * FROM sc_test.tbl_company");
>
>
> 15:43:39,877 ERROR [STDERR] java.sql.SQLException: ERROR: parser: parse
> error at or near "."
> 15:43:39,877 ERROR [STDERR] at
> org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
> 15:43:39,877 ERROR [STDERR] at
> org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection
> .java:505
> )
> 15:43:39,888 ERROR [STDERR] at
> org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.j
> ava:320)
> 15:43:39,888 ERROR [STDERR] at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j
> ava:48)
> 15:43:39,888 ERROR [STDERR] at
> org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statem
> ent.java:
> 153)
> 15:43:39,898 ERROR [STDERR] at
> org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statem
> ent.java:
> 141)
> 15:43:39,908 ERROR [STDERR] at
> org.jboss.resource.adapter.jdbc.local.LocalStatement.executeQuery(LocalState
> ment.java
> :211)
> 15:43:39,908 ERROR [STDERR] at
> com.ilium.eapps.compmenu.dao.GenericModuleDAO.list(GenericModuleDAO.java:246
> )
> 15:43:39,908 ERROR [STDERR] at
> com.ilium.eapps.compmenu.ejb.sb.SBModuleBean.getList(SBModuleBean.java:258)
> 15:43:39,918 ERROR [STDERR] at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 15:43:39,918 ERROR [STDERR] at
> sun.reflect.NativeMethodAccessorImpl.invoke(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.java:324)
> 15:43:39,928 ERROR [STDERR] at
> org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(Stateles
> sSessionC
> ontainer.java:660)
> 15:43:39,938 ERROR [STDERR] at
> org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(Cach
> edConnect
> ionInterceptor.java:186)
> 15:43:39,938 ERROR [STDERR] at
> org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSe
> ssionInst
> anceInterceptor.java:77)
> 15:43:39,948 ERROR [STDERR] at
> org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor
> .java:107
> )
> 15:43:39,948 ERROR [STDERR] at
> org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.
> java:178)
>
> 15:43:39,958 ERROR [STDERR] at
> org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:60)
> 15:43:39,958 ERROR [STDERR] at
> org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:13
> 0)
> 15:43:39,958 ERROR [STDERR] at
> org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:204)
> 15:43:39,968 ERROR [STDERR] at
> org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.jav
> a: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.invoke(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.invoke(TransactionInterceptor.java:77
> )
> 15:43:39,988 ERROR [STDERR] at
> org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:80)
> 15:43:39,988 ERROR [STDERR] at
> org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInter
> ceptor.ja
> va:111)
> 15:43:39,988 ERROR [STDERR] at
> org.jboss.proxy.ClientContainer.invoke(ClientContainer.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.ModuleAction.performList(ModuleAction.ja
> va:163)
> 15:43:39,998 ERROR [STDERR] at
> com.ilium.eapps.compmenu.controller.ModuleAction.execute(ModuleAction.java:1
> 31)
> 15:43:40,008 ERROR [STDERR] at
> org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces
> sor.java:
> 465)
> 15:43:40,008 ERROR [STDERR] at
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
> 15:43:40,008 ERROR [STDERR] at
> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1422)
> 15:43:40,018 ERROR [STDERR] at
> org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:505)
> 15:43:40,018 ERROR [STDERR] at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
> 15:43:40,018 ERROR [STDERR] at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> 15:43:40,028 ERROR [STDERR] at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
> FilterCha
> in.java:247)
> 15:43:40,028 ERROR [STDERR] at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
> ain.java:
> 193)
> 15:43:40,038 ERROR [STDERR] at
> com.ilium.eapps.syswar.filter.SetCharacterEncodingFilter.doFilter(SetCharact
> erEncodin
> gFilter.java:147)
> 15:43:40,038 ERROR [STDERR] at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
> FilterCha
> in.java:213)
> 15:43:40,048 ERROR [STDERR] at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
> ain.java:
> 193)
> 15:43:40,048 ERROR [STDERR] at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
> va:243)
> 15:43:40,058 ERROR [STDERR] at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> 66)
> 15:43:40,058 ERROR [STDERR] at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> 15:43:40,058 ERROR [STDERR] at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> 15:43:40,068 ERROR [STDERR] at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
> va:190)
> 15:43:40,068 ERROR [STDERR] at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> 66)
> 15:43:40,068 ERROR [STDERR] at
> org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2
> 46)
> 15:43:40,068 ERROR [STDERR] at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> 64)
> 15:43:40,078 ERROR [STDERR] at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> 15:43:40,078 ERROR [STDERR] at
> org.apache.catalina.core.ContainerBase.invoke(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.StandardHostValve.invoke(StandardHostValve.java:180
> )
> 15:43:40,088 ERROR [STDERR] at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> 66)
> 15:43:40,088 ERROR [STDERR] at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
> java:170)
>
> 15:43:40,098 ERROR [STDERR] at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> 64)
> 15:43:40,098 ERROR [STDERR] at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170
> )
> 15:43:40,098 ERROR [STDERR] at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> 64)
> 15:43:40,108 ERROR [STDERR] at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
> 15:43:40,108 ERROR [STDERR] at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> 64)
> 15:43:40,108 ERROR [STDERR] at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> 15:43:40,108 ERROR [STDERR] at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> 15:43:40,118 ERROR [STDERR] at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
> :174)
> 15:43:40,118 ERROR [STDERR] at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> 66)
> 15:43:40,118 ERROR [STDERR] at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> 15:43:40,128 ERROR [STDERR] at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> 15:43:40,128 ERROR [STDERR] at
> org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:
> 1027)
> 15:43:40,128 ERROR [STDERR] at
> org.apache.catalina.connector.http.HttpProcessor.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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel: +30-10-8981112
fax: +30-10-8981877
email: achill@matrix.gatewaynet.com
mantzios@softlab.ece.ntua.gr
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-02-07 13:03 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-02-07 07:53 PostgreSQL 7.3.1 multiple schema select query error: java.sql.SQLException: ERROR: parser: parse error at or near "." waimeng <waimeng@efkonasia.com.my>
2003-02-07 08:29 PostgreSQL 7.3.1 multiple schema select query error: java.sql.SQLException: ERROR: parser: parse error at or near "." waimeng <waimeng@efkonasia.com.my>
2003-02-07 13:03 ` Re: PostgreSQL 7.3.1 multiple schema select query error: Achilleus Mantzios <achill@matrix.gatewaynet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox