Marco Casavecchia Morganti wrote:
Hello,
I just upgraded fron HippoCMS 6.05.03 to 6.05.04.
I use PostgresSQL as Database backend. when i switch to the "to do"
perspective i get this error:
An error occured during loading: SQL Exception in query: Cannot create
PoolableConnectionFactory (ERROR: relation "dual" does not exist)
Any suggestion?
Check you servermanager templates, you probably use the ones for MySQL
or Oracle, am I correct?
There should be a validationquery defined which says 'SELECT 1 FROM
DUAL', for Postgres that should probably be be 'SELECT 1'
Regards,
--
Bartosz Oudekerk
.---------------------------------.-----------------------------------.
| Hippo B.V. | Hippo USA Inc. |
| Oosteinde 11 | 101 H Street, suite Q Petaluma CA |
| 1017 WT Amsterdam | 94952-3329 San Francisco |
| The Netherlands | United States |
| Tel +31 (0)20 5224466 | +1 (707) 773-4646 |
+---------------------------------+-----------------------------------+
| [EMAIL PROTECTED] | http://www.onehippo.com |
`---------------------------------^-----------------------------------'
********************************************
Hippocms-dev: Hippo CMS development public mailinglist
Searchable archives can be found at:
MarkMail: http://hippocms-dev.markmail.org
Nabble: http://www.nabble.com/Hippo-CMS-f26633.html
