Hi Ilkan,
I changed the entries you suggested in my virtualdatabase.xml as follows
<DatabaseSchema dynamicPrecision="table" gatherSystemTables="false"
schemaName="HR"/>
And
<ConnectionManager vLogin="user" rLogin="HR" rPassword="hr"> because I
enabled the hr schema
Note that specifying a schema name will restrict the visibility of the
controllers to that schema only. This means that you won't be able to
access any table outside the HR schema (I am not sure if this can be
case sensitive or not with Oracle).
In the log4j.properties I changed
log4j.logger.org.continuent.sequoia.controller.backend.DatabaseBackend=DEBUG
, Info, Console,Filetrace
After forcing enable node1 and 2 I can connect through the jdbc:sequoia url
to my virtual database.
I am able to query all the tables owned by hr, I am able to insert and
update for example the employees table.
But I still can not create a new table
create table mytest (z number): An error occured while executing SQL query
(org.continuent.sequoia.common.exceptions.driver.DriverSQLException: Message
of cause: No database backend has the required table (mytest))
What if you force the schema name as in 'create table hr.mytest(z number)' ?
In the controller.sh is the same entry without more information.
I tried some other things like
Desc employees: error: Unable to get target table in request desc
employees/)
I hope you have any idea. Maybe forcing enabling the nodes cause this
errors?
No it is unlikely. The force enabling just bypasses the
resynchronization using the recovery log.
Just to be sure, you are trying to execute these queries using the
Sequoia console?
Oh, I just got it. I looked again at your configuration file and you are
using RAIDb-0 (partitioning instead of replication).
You have to add a 'CreateTable' element to your configuration file (see
sequoia.dtd) to tell where you want new tables to be created.
Note that the RAIDb-0 code has not been tested for quite a long time and
might not be stable.
Hope this helps.
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
