I did it and you can see in the logs that it is working but I have found something that it might be a bug?
[EMAIL PROTECTED]:/usr/sequoia-2.10.1$ sudo ./bin/controller.sh -f ./config/controller/controller-itecban-oracle.xml 10:09:58,730 INFO controller.core.Controller Sequoia controller (2.10.2) 10:09:58,882 INFO controller.core.Controller Loading configuration file: ./config/controller/controller-itecban-oracle.xml 10:09:59,183 INFO controller.core.Controller JMX is enabled 10:09:59,275 INFO controller.core.Controller Starting JMX server on host: 172.22.61.6 10:10:00,650 DEBUG sequoia.controller.connection Pool connection manager created for backend amdelcura.indra.es for 40 connection(s) 10:10:00,651 INFO amdelcura.indra.es Adding connection manager for virtual user "itecban" 10:10:00,652 DEBUG controller.virtualdatabase.ITECBAN_DB Checking driver compliance 10:10:00,677 DEBUG controller.virtualdatabase.ITECBAN_DB Backend amdelcura.indra.es added successfully 10:10:00,843 INFO controller.RequestManager.ITECBAN_DB Request manager will parse requests with the following granularity: TABLE 10:10:00,870 WARN controller.virtualdatabase.ITECBAN_DB No recovery log has been configured, enabling backend without checkpoint. 10:10:01,362 DEBUG controller.virtualdatabase.ITECBAN_DB Initializing connections for backend amdelcura.indra.es 10:10:01,369 DEBUG controller.connection.DriverManager we are using default classloader and driverClassName =oracle.jdbc.driver.OracleDriver 10:10:01,371 DEBUG controller.connection.DriverManager loading driver with name /usr/sequoia-2.10.1/drivers for class oracle.jdbc.driver.OracleDriver 10:10:01,973 DEBUG controller.connection.DriverManager Driver oracle.jdbc.driver.OracleDriver loaded. 10:10:04,530 DEBUG sequoia.controller.connection Initialized 40 connections on "jdbc:oracle:thin:@amdelcura.indra.es:1521:itecban" 10:10:04,672 INFO amdelcura.indra.es Detected backend as: Oracle 10:10:04,738 WARN amdelcura.indra.es Statement.setCursorName not supported. 10:10:04,738 WARN amdelcura.indra.es Statement.getGeneratedKeys not supported. 10:10:05,150 DEBUG controller.virtualdatabase.ITECBAN_DB Checking schema for backend amdelcura.indra.es 10:36:02,922 INFO controller.RequestManager.ITECBAN_DB Setting new virtual database schema. 10:36:02,923 INFO sequoia.controller.cache Setting new database schema. 10:36:03,001 INFO controller.loadbalancer.SingleDB Enabling backend amdelcura.indra.es 10:36:03,007 INFO controller.RequestManager.ITECBAN_DB Database backend amdelcura.indra.es is now enabled 10:36:03,033 DEBUG VirtualDatabaseWorkerThread.ITECBAN_DB.metadata fetching static metadata for backend:amdelcura.indra.es 10:36:03,034 INFO controller.core.Controller Adding VirtualDatabase ITECBAN_DB 10:36:03,059 INFO controller.core.Controller Waiting for connections on 0.0.0.0:25322 10:36:03,089 INFO controller.core.Controller Controller started on 2006.11.13 46 at 10:36:03 AM CET 10:36:03,090 INFO controller.core.Controller Controller 172.22.61.6:25322 ready, listening to requests ... 10:36:25,882 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB Login accepted for itecban from /172.22.61.6 10:36:34,980 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB Login accepted for itecban from /172.22.61.6 10:36:41,517 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB Begin command 10:36:41,521 DEBUG controller.RequestManager.ITECBAN_DB Begin transaction 0 10:36:41,539 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB StatementExecuteQuery command 10:36:41,559 DEBUG controller.RequestManager.ITECBAN_DB Database schema is dirty, refreshing it 10:36:59,854 DEBUG controller.RequestManager.ITECBAN_DB Scheduling read Request (0): select people_seq.nextval from dual/ 10:36:59,855 DEBUG controller.RequestManager.ITECBAN_DB Getting from cache read request (0): select people_seq.nextval from dual/ 10:36:59,855 DEBUG controller.RequestManager.ITECBAN_DB Load balancing read request (0): select people_seq.nextval from dual/ 10:37:18,061 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB StatementExecuteUpdate command 10:37:18,067 DEBUG controller.RequestManager.ITECBAN_DB Scheduling write request (1): insert into people (first_name, second_n... 10:37:18,068 DEBUG controller.RequestManager.ITECBAN_DB Load balancing write request (1,0): insert into people (first_name, second_n... 10:37:18,074 DEBUG controller.RequestManager.ITECBAN_DB Invalidating cache for write request (1): insert into people (first_name, second_n... 10:37:18,080 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB Commit command 10:37:18,081 DEBUG controller.RequestManager.ITECBAN_DB Commit transaction 0 10:37:34,085 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB Login accepted for itecban from /172.22.61.6 10:37:34,086 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB Begin command 10:37:34,086 DEBUG controller.RequestManager.ITECBAN_DB Begin transaction 1 10:37:34,088 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB StatementExecuteQuery command 10:37:34,125 DEBUG controller.RequestManager.ITECBAN_DB Scheduling read Request (2): select people0_.id as id2_, people0_.fir... 10:37:34,125 DEBUG controller.RequestManager.ITECBAN_DB Getting from cache read request (2): select people0_.id as id2_, people0_.fir... 10:37:34,126 DEBUG controller.RequestManager.ITECBAN_DB Load balancing read request (2): select people0_.id as id2_, people0_.fir... 10:37:34,168 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB StatementExecuteUpdate command 10:37:34,174 DEBUG controller.RequestManager.ITECBAN_DB Scheduling write request (3): update people set first_name=?, second_n... 10:37:34,174 DEBUG controller.RequestManager.ITECBAN_DB Load balancing write request (3,1): update people set first_name=?, second_n... 10:37:34,176 DEBUG controller.RequestManager.ITECBAN_DB Invalidating cache for write request (3): update people set first_name=?, second_n... 10:37:34,213 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB Commit command 10:37:34,214 DEBUG controller.RequestManager.ITECBAN_DB Commit transaction 1 10:38:16,743 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB Login accepted for itecban from /172.22.61.6 10:38:16,745 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB StatementExecuteQuery command 10:38:16,754 DEBUG controller.RequestManager.ITECBAN_DB Scheduling read Request (4): select people0_.id as id4_, people0_.fir... 10:38:16,757 DEBUG controller.RequestManager.ITECBAN_DB Getting from cache read request (4): select people0_.id as id4_, people0_.fir... 10:38:16,757 DEBUG controller.RequestManager.ITECBAN_DB Load balancing read request (4): select people0_.id as id4_, people0_.fir... 10:38:23,278 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB Login accepted for itecban from /172.22.61.6 10:38:26,068 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB Login accepted for itecban from /172.22.61.6 10:38:26,213 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB Begin command 10:38:26,214 DEBUG controller.RequestManager.ITECBAN_DB Begin transaction 2 10:38:26,220 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB StatementExecuteQuery command 10:38:26,221 DEBUG controller.RequestManager.ITECBAN_DB Scheduling read Request (5): select people_seq.nextval from dual/ 10:38:26,221 DEBUG controller.RequestManager.ITECBAN_DB Getting from cache read request (5): select people_seq.nextval from dual/ 10:38:26,221 DEBUG controller.RequestManager.ITECBAN_DB Load balancing read request (5): select people_seq.nextval from dual/ 10:38:26,340 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB StatementExecuteUpdate command 10:38:26,340 DEBUG controller.RequestManager.ITECBAN_DB Scheduling write request (6): insert into people (first_name, second_n... 10:38:26,341 DEBUG controller.RequestManager.ITECBAN_DB Load balancing write request (6,2): insert into people (first_name, second_n... 10:38:26,342 DEBUG controller.RequestManager.ITECBAN_DB Invalidating cache for write request (6): insert into people (first_name, second_n... 10:38:26,345 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB Commit command 10:38:26,346 DEBUG controller.RequestManager.ITECBAN_DB Commit transaction 2 ############################ This is working with this hibernate table mapping config file <?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd";> <!-- Generated Nov 6, 2006 5:54:51 PM by Hibernate Tools 3.2.0.beta8 --> <hibernate-mapping> <class name="com.indra.itecban.hibernatesample.People" table="people"><!-- schema="prbgrid" --> <id name="id" type="java.lang.Long"> <column name="id" precision="22" scale="0" /> <generator class="sequence"> <param name="sequence">people_seq</param> </generator> </id> <property name="firstName" type="java.lang.String"> <column name="first_name" length="4000" not-null="true" /> </property> <property name="secondName" type="java.lang.String"> <column name="second_name" length="4000" not-null="true" /> </property> </class> </hibernate-mapping> ################################################ As you can see I have commented the schema name... if I put the schema name in the config file, then the error appears. I executed the java program 2 times. ################################################ 10:49:42,270 DEBUG controller.RequestManager.ITECBAN_DB Begin transaction 10 10:49:42,279 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB StatementExecuteQuery command 10:49:42,282 DEBUG controller.RequestManager.ITECBAN_DB Scheduling read Request (22): select people_seq.nextval from dual/ 10:49:42,282 DEBUG controller.RequestManager.ITECBAN_DB Getting from cache read request (22): select people_seq.nextval from dual/ 10:49:42,283 DEBUG controller.RequestManager.ITECBAN_DB Load balancing read request (22): select people_seq.nextval from dual/ 10:49:42,419 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB StatementExecuteUpdate command 10:49:42,423 DEBUG controller.RequestManager.ITECBAN_DB Aborting transaction 10 10:49:42,425 DEBUG controller.RequestManager.ITECBAN_DB Transaction 10 aborted 10:49:42,425 WARN controller.virtualdatabase.ITECBAN_DB Request insert into prbgrid.people (first_name, ... failed, transaction has been aborted (Unknown table 'prbgrid.people' in this INSERT statement: 'insert into prbgrid.people (first_name, second_name, id) values (?, ?, ?)') 10:49:42,425 WARN virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB Error during command execution (Unknown table 'prbgrid.people' in this INSERT statement: 'insert into prbgrid.people (first_name, second_name, id) values (?, ?, ?)') 10:49:42,495 WARN virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB Client (login:itecban,host:aolias.indra.es closed connection with server) 10:50:42,501 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB VirtualDatabaseWorkerThread associated to login: itecban terminating. 10:50:42,502 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB VirtualDatabaseWorkerThread associated to login: itecban terminating. 10:51:32,015 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB Login accepted for itecban from /172.22.61.6 10:51:34,993 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB Login accepted for itecban from /172.22.61.6 10:51:35,168 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB Begin command 10:51:35,169 DEBUG controller.RequestManager.ITECBAN_DB Begin transaction 11 10:51:35,176 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB StatementExecuteQuery command 10:51:35,177 DEBUG controller.RequestManager.ITECBAN_DB Scheduling read Request (24): select people_seq.nextval from dual/ 10:51:35,177 DEBUG controller.RequestManager.ITECBAN_DB Getting from cache read request (23): select people_seq.nextval from dual/ 10:51:35,178 DEBUG controller.RequestManager.ITECBAN_DB Load balancing read request (23): select people_seq.nextval from dual/ 10:51:35,181 DEBUG controller.RequestManager.ITECBAN_DB Aborting transaction 11 10:51:35,182 DEBUG controller.RequestManager.ITECBAN_DB Transaction 11 aborted 10:51:35,183 WARN controller.virtualdatabase.ITECBAN_DB Request select people_seq.nextval from dual/ failed, transaction has been aborted (Query 23 is not in the list of currently scheduled queries) 10:51:35,183 WARN virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB Error during command execution (Query 23 is not in the list of currently scheduled queries) 10:51:35,311 WARN virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB Client (login:itecban,host:aolias.indra.es closed connection with server) ############################################### That's ok, now I remove the schema property from the hibernate file and it should work? but it doesn't. the only way is to restart the controller. ################################################ 10:53:32,574 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB Login accepted for itecban from /172.22.61.6 10:53:36,121 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB Login accepted for itecban from /172.22.61.6 10:53:36,263 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB Begin command 10:53:36,266 DEBUG controller.RequestManager.ITECBAN_DB Begin transaction 12 10:53:36,272 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB StatementExecuteQuery command 10:53:36,272 DEBUG controller.RequestManager.ITECBAN_DB Scheduling read Request (25): select people_seq.nextval from dual/ 10:53:36,273 DEBUG controller.RequestManager.ITECBAN_DB Getting from cache read request (24): select people_seq.nextval from dual/ 10:53:36,273 DEBUG controller.RequestManager.ITECBAN_DB Load balancing read request (24): select people_seq.nextval from dual/ 10:53:36,397 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB StatementExecuteUpdate command 10:53:36,397 DEBUG controller.RequestManager.ITECBAN_DB Scheduling write request (26): insert into people (first_name, second_n... 10:53:36,397 DEBUG controller.RequestManager.ITECBAN_DB Load balancing write request (25,12): insert into people (first_name, second_n... 10:53:36,399 DEBUG controller.RequestManager.ITECBAN_DB Invalidating cache for write request (25): insert into people (first_name, second_n... 10:53:36,400 DEBUG controller.RequestManager.ITECBAN_DB Aborting transaction 12 10:53:36,401 INFO sequoia.controller.cache Flushing whole cache due to rollback of transaction : 12 10:53:36,401 DEBUG controller.RequestManager.ITECBAN_DB Transaction 12 aborted 10:53:36,402 WARN controller.virtualdatabase.ITECBAN_DB Request insert into people (first_name, second_n... failed, transaction has been aborted (Query 25 is not in the list of currently scheduled queries) 10:53:36,402 WARN virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB Error during command execution (Query 25 is not in the list of currently scheduled queries) 10:53:36,659 WARN virtualdatabase.VirtualDatabaseWorkerThread.ITECBAN_DB Client (login:itecban,host:aolias.indra.es closed connection with server) ############################################### I hope this helps Regards Alfonso _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
