Ok this is it, I guess there is nothing strange?

<DatabaseBackend name="amdelcura.indra.es"
                                 driver="oracle.jdbc.driver.OracleDriver"
                                 
url="jdbc:oracle:thin:@amdelcura.indra.es:1521:itecban"
                                 connectionTestStatement="select * from dual">
                        <ConnectionManager vLogin="itecban"
                                           rLogin="prbgrid"
                                           rPassword="gridgrid">
                                <VariablePoolConnectionManager 
initPoolSize="40"/>
                        </ConnectionManager>
                        <DatabaseSchema schemaName="prbgrid"
                                        gatherSystemTables="false"/>
                </DatabaseBackend>

But why this table is fetched with a select and not with an insert?


On 11/8/06, Emmanuel Cecchet <[EMAIL PROTECTED]> wrote:
Alfonso,
> What could be missconfigured in my controller/virtual database?
Sequoia did not succeed in fetching a table people in schema prbgrid.
This is why you get:
> jdbc:sequoia://aolias.indra.es/ITECBAN_DB (itecban) > insert into
> prbgrid.people (first_name, second_name, id) values ('Felipe',
> 'Lotas', people_seq.nextval)
> An error occured while executing SQL query
> (org.continuent.sequoia.common.exceptions.driver.DriverSQLException:
> Message of cause: Unknown table 'prbgrid.people' in this INSERT
> statement: 'insert into prbgrid.people (first_name, second_name, id)
> values ('Felipe', 'Lotas', people_seq.nextval)')
The table does not belong to Sequoia's schema because it couldn't fetch it.
You should look at your DatabaseSchema settings in your virtual database
configuration file (note that these settings are different for Sequoia
2.10 and 3.0)

Hope this helps,
Emmanuel

--
Emmanuel Cecchet
Chief Scientific Officer, 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

Reply via email to