Julio,
We run sequoia 2.10 postgresql 8.1.4
I have a table named poolmanager
I can see that table when I do show tables
Could you show the output of 'show tables' ?
jdbc:sequoia://172.20.21.130/mydb (postgres) > select * from poolmanager
+---------------------------+--+---------------------------+-------------+
| gamename | xml | datemodified |
modifiedby~ |
+---------------------------+--+---------------------------+-------------+
| FACILITO | <pool-manager class="com~ | 2008-01-24
14:54:41.822 | 0 |
+---------------------------+--+---------------------------+-------------+
Query executed in 0 s 4 ms .
But when I try to do an update or an Insert I got this error messages
jdbc:sequoia://172.20.21.130/mydb (postgres) > update poolmanager set
gamename = 'x'
An error occured while executing SQL query
(org.continuent.sequoia.common.exceptions.driver.DriverSQLException:
Message of cause: Unknown table 'poolmanager' in this UPDATE
statement: 'update poolmanager set gamename = 'x'')
It looks like your schema is not up-to-date. To force a schema refresh,
you can just do call a stored procedure or rollback an update transaction.
jdbc:sequoia://172.20.21.130/abrazo (postgres) > insert into
poolmanagers (gamename, xml, datemodified, modifiedbyuser) values
('a','b',now(), 0)
An error occured while executing SQL query
(org.continuent.sequoia.common.exceptions.driver.DriverSQLException:
Message of cause: Unknown table 'poolmanagers' in this INSERT
statement: 'insert into poolmanagers (gamename, xml, datemodified,
modifiedbyuser) values ('a','b',now(), 0)')
This one is expected to fail because you used poolmanagers with an s.
I've tried directly and it worked.
How did you create the table?
What happen if you just disable all backends and re-enable them?
Thanks for your feedback,
Emmanuel
--
Emmanuel Cecchet - Research scientist
EPFL - LABOS/DSLAB - IN.N 317
Phone: +41-21-693-7558
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
