Re: [Sequoia] Problem inserting in Sequoia console

Paul Mackay Wed, 01 Nov 2006 05:58:59 -0800

I finally realized that the problem apparently came from a bad parameter setting on my part. I had left "<DatabaseSchema schemaName="public"/>". Removing it fixed the problem. Strangely, though, the "mytable" table used in my example was created in the "public" schema. My understanding of the "DatabaseSchema" parameter is that it still should of been able to recognize the table. Anyway, removing altogether the parameter was the solution for my case and now the Sequoia console works perfectly well. Sorry for the inconvenience.

Regards,
Paul

On 10/27/06, Emmanuel Cecchet <[EMAIL PROTECTED]> wrote:

Paul,

Thanks for the detailed report.

> - Now type : "INSERT INTO mytable VALUES (2,'B')". Console displays :
> "An error occured while executing SQL query (
> org.continuent.sequoia.common.exceptions.driver.DriverSQLException:
> Message of cause: Unknown table 'mytable' in this INSERT statement:
> 'INSERT INTO mytable VALUES (2,'B')')"
>
> - Of notice, adding a ";" at the end of the sql statement produces a
> different error message :
> "An error occured while executing SQL query
> (org.continuent.sequoia.common.exceptions.driver.DriverSQLException :
> Message of cause: Failed to execute request INSERT INTO mytable VALUES
> (2,'B') ;/ because of
> (org.continuent.sequoia.controller.requests.StoredProcedure ))"
Could you send us the full trace that appears in full_cluster.log on the
controller side?
Could you file a JIRA entry with the bug description and copy/paste the
scenario included in your email. This sounds like a bug in the console
or in the controller.

Thanks again for your feedback,
Emmanuel

--
Emmanuel Cecchet
Chief Architect, Continuent

Blog: http://emanux.blogspot.com/
Open source: http://www.continuent.org
Corporate: http://www.continuent.com
Skype: emmanuel_cecchet
Cell: +33 687 342 685

_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia

_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia

Re: [Sequoia] Problem inserting in Sequoia console

Reply via email to