Hi Emmanuel Thanks for your reply it gave us the clue to find the culprit.
We found that the table was created manually, so after I restarted sequioa everything is ok. Thanks again. > Date: Wed, 20 Feb 2008 19:04:57 +0100 > From: [EMAIL PROTECTED] > To: [email protected] > Subject: Re: [Sequoia] sequoia 2.10 DriverSQLException doing an insert or > update > > 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
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
