I think I found the problem:
the query is sent with the table name double-quoted:
select "ana_paz"."COGNOME", "ana_paz"."NOME" from "ana_paz" where
"ana_paz"."COGNOME"='ROSSI' <--- doesn't not work ("table or view does
not exists")
select ana_paz."COGNOME", ana_paz."NOME" from "ana_paz" where
ana_paz."COGNOME"='ROSSI' <---- works
Setting
entity_quoting = False
in the database connection solved the problem.
Il giorno venerdì 12 aprile 2019 17:00:14 UTC+2, gliporace ha scritto:
>
> Hi,
> I just updated my web2py installation from 2.11 to 2.18.5, but the apps
> who make use of cx_Oracle for connecting to a Oracle database show this
> error
> when ther try to query a table/view:
>
> Exception ORA-00942: table or view does not exist
>
> The old web2py installation run without problems on a Ubuntu server 14.04
> and cx_Oracle 5.3, the new installation is on Ubuntu server 16.04 with the
> same version of cx_Oracle.
>
> Is there any means to check what is the query before is sent to the server?
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
