You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Marco Spinetti <m....@pisa.iol.it> on 2000/12/21 09:12:57 UTC

SERIOUS PROBLEM WITH ESQL.

PS:I have already sent this letter but my mail server had some problem, so I don't know if it arrived.
******************************************************************************************** 
Hi all,
a serious mistake happens to me while I use Esql and do not know if depends on me or is a Cocoon limitation. My real application of I list telephone. In a Xml page two forms exist: one to find a person through the number and one to find the person's phone number. The two forms send two different Xsp files that use two different pools, or better the database is the itself one( driver and url are the same) but the User-Name and the password are different , therefore I have created two different connection  pools ( Elenco and Elenco1 ). 
If I try to use a form everything works well; if then I go back to the Page home and use the second form it does not work but I obtain the following mistake. 
java.sql.SQLException: ORA-00942: table or view does not exist

	at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java)
	at oracle.jdbc.ttc7.Oall7.receive(Oall7.java)
	at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java)
	at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java)
	at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java)
	at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java)
	at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java)
	at _usr._local._jakarta_tomcat._webapps._cocoon._elenco._risposta_elenco.populateDocument(_risposta_elenco.java:787)
	at org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:96)
	at org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:494)
	at org.apache.cocoon.Engine.handle(Engine.java:359)
	at org.apache.cocoon.Cocoon.service(Cocoon.java:167)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
	at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
	at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:160)
	at org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338)
	at java.lang.Thread.run(Thread.java:475)

The mistake I do not obtain it if I use a form and then, after making Cocoon restart, use the second. I obtain the only mistake when I use them, first one and then the other, without making restart of new Cocoon.
It is as if it kept the table old. What's the mistake? 
Thanks for the help
Marco
m.spinetti@pisa.iol.it


Re: R: SERIOUS PROBLEM WITH ESQL.

Posted by Ugo Cei <u....@cbim.it>.
Marco Spinetti wrote:

> Hi Ugo
> What do you mean? I qualify the table with the table's name.
> At second of the sent parameters I choose the name of the table and build
> the query: but when I execute the query I have the problem.

You are using Oracle, right? You know every object in an Oracle DB 
belongs to a schema? The schema of your table is tyipically the name of 
the user who created the table. So the fully qualified name of the table 
is SCHEMANAME.TABLENAME, not just TABLENAME. When you log onto Oracle 
with a username, the default schema is the logged user's name, thus when 
you log on as "user1" and execute:

	SELECT * FROM TABLENAME

you are actually executing:

	SELECT * from user1.TABLENAME

But if you log on as "user2", TABLENAME refers to "user2.TABLENAME" 
which might not exist.

To make a long story short, if you are using different usernames to log 
on, always prefix the name of objects with the owner's name.

	Ugo





R: SERIOUS PROBLEM WITH ESQL.

Posted by Marco Spinetti <m....@pisa.iol.it>.
Hi Ugo
What do you mean? I qualify the table with the table's name.
At second of the sent parameters I choose the name of the table and build
the query: but when I execute the query I have the problem. Read the  letter
between me and  Drasko in which I explain the problem. In the last letter I
explain how try the service (it's a multiterminal service) and in which URL
you can find this.
Can you try it, please?
Tell me what do you think about it.
Marco

----- Original Message -----
From: Ugo Cei <u....@cbim.it>
To: <co...@xml.apache.org>
Sent: Thursday, December 21, 2000 3:32 PM
Subject: Re: SERIOUS PROBLEM WITH ESQL.


> Marco Spinetti wrote:
>
>
> > two different Xsp files that use two different pools, or better the
> > database is the itself one( driver and url are the same) but the
> > User-Name and the password are different , therefore I have created two
> > different connection  pools ( Elenco and Elenco1 ).
>
> Are you qualifying the table name with the schema name in both cases?
> --
> Ugo Cei - Consorzio di Bioingegneria e Informatica Medica
> P.le Volontari del Sangue, 2 - 27100 Pavia - Italy
> Phone: +39.0382.525100 - E-mail: u.cei@cbim.it
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org
>
>


Re: SERIOUS PROBLEM WITH ESQL.

Posted by Ugo Cei <u....@cbim.it>.
Marco Spinetti wrote:


> two different Xsp files that use two different pools, or better the 
> database is the itself one( driver and url are the same) but the 
> User-Name and the password are different , therefore I have created two 
> different connection  pools ( Elenco and Elenco1 ).

Are you qualifying the table name with the schema name in both cases?
-- 
Ugo Cei - Consorzio di Bioingegneria e Informatica Medica
P.le Volontari del Sangue, 2 - 27100 Pavia - Italy
Phone: +39.0382.525100 - E-mail: u.cei@cbim.it