Just for the records
Sorry for the previous post. There is no apparently any error. The
problem seems to be the Oracle backend.
It seems that it takes lot of time to fetch the db schema....
see the timestamp logs
[EMAIL PROTECTED]:/usr/sequoia-2.10.1$ sudo ./bin/controller.sh -f
./config/controller/controller-itecban-oracle.xml
10:17:35,386 INFO controller.core.Controller Sequoia controller (2.10.2)
10:17:35,527 INFO controller.core.Controller Loading configuration
file: ./config/controller/controller-itecban-oracle.xml
10:17:35,734 INFO controller.core.Controller JMX is enabled
10:17:35,812 INFO controller.core.Controller Starting JMX server on
host: 172.22.61.9
10:17:36,623 INFO amdelcura.indra.es Adding connection manager for
virtual user "itecban"
10:17:36,787 INFO controller.RequestManager.ITECBAN_DB Request
manager will parse requests with the following granularity: TABLE
10:17:36,823 WARN controller.virtualdatabase.ITECBAN_DB No recovery
log has been configured, enabling backend without checkpoint.
10:17:39,220 INFO amdelcura.indra.es Detected backend as: Oracle
10:17:39,274 WARN amdelcura.indra.es Statement.setCursorName not supported.
10:17:39,275 WARN amdelcura.indra.es Statement.getGeneratedKeys not supported.
10:43:55,748 INFO controller.RequestManager.ITECBAN_DB Setting new
virtual database schema.
10:43:55,817 INFO sequoia.controller.cache Setting new database schema.
10:43:55,871 INFO controller.loadbalancer.SingleDB Enabling backend
amdelcura.indra.es
10:43:55,924 INFO controller.RequestManager.ITECBAN_DB Database
backend amdelcura.indra.es is now enabled
10:43:55,981 INFO controller.core.Controller Adding VirtualDatabase ITECBAN_DB
10:43:56,014 INFO controller.core.Controller Waiting for connections
on 0.0.0.0:25322
10:43:56,063 INFO controller.core.Controller Controller started on
2006.11.08 45 at 10:43:56 AM CET
10:43:56,065 INFO controller.core.Controller Controller
172.22.61.9:25322 ready, listening to requests ...
On 11/8/06, Alfonso Olias Sanz <[EMAIL PROTECTED]> wrote:
Hi I have a problem connecting with an Oracle backend.
I get this client exception.
Exception in thread "main" java.sql.SQLException: No controller is
available to accept connections
But I have running a controller and I have succesfully loaded a
virtual database.
I would appreciate any help
Thanks
Alfonso
[EMAIL PROTECTED]:/usr/sequoia-2.10.1$ sudo ./bin/controller.sh -f
./config/controller/controller-itecban-oracle.xml
10:17:35,386 INFO controller.core.Controller Sequoia controller (2.10.2)
10:17:35,527 INFO controller.core.Controller Loading configuration
file: ./config/controller/controller-itecban-oracle.xml
10:17:35,734 INFO controller.core.Controller JMX is enabled
10:17:35,812 INFO controller.core.Controller Starting JMX server on
host: 172.22.61.9
10:17:36,623 INFO amdelcura.indra.es Adding connection manager for
virtual user "itecban"
10:17:36,787 INFO controller.RequestManager.ITECBAN_DB Request
manager will parse requests with the following granularity: TABLE
10:17:36,823 WARN controller.virtualdatabase.ITECBAN_DB No recovery
log has been configured, enabling backend without checkpoint.
10:17:39,220 INFO amdelcura.indra.es Detected backend as: Oracle
10:17:39,274 WARN amdelcura.indra.es Statement.setCursorName not supported.
10:17:39,275 WARN amdelcura.indra.es Statement.getGeneratedKeys not supported.
The conecction java code is the following
String dbUrl = "jdbc:sequoia://aolias.indra.es/ITECBAN_DB";
String user = "itecban";
String password = "itecban";
System.out.println("Load Driver!");
Class.forName("org.continuent.sequoia.driver.Driver");
DriverManager.getConnection(dbUrl, user, password); //Here it fails
#############################################
controller xml config file
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE SEQUOIA-CONTROLLER PUBLIC "-//Continuent//DTD
SEQUOIA-CONTROLLER 2.10.2//EN"
"http://sequoia.continuent.org/dtds/sequoia-controller-2.10.2.dtd";>
<SEQUOIA-CONTROLLER>
<Controller port="25322">
<Report hideSensitiveData="true" generateOnShutdown="true"
generateOnFatal="true" enableFileLogging="true" />
<JmxSettings>
<RmiJmxAdaptor/>
</JmxSettings>
<VirtualDatabase configFile="itecban-oracle.xml"
virtualDatabaseName="ITECBAN_DB"/>
</Controller>
</SEQUOIA-CONTROLLER>
###############################################
virtual database config file
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.2//EN"
"http://sequoia.continuent.org/dtds/sequoia-2.10.2.dtd";>
<SEQUOIA>
<VirtualDatabase name="ITECBAN_DB">
<Monitoring>
<SQLMonitoring defaultMonitoring="off">
<SQLMonitoringRule queryPattern="^select"
caseSensitive="false"
applyToSkeleton ="false"
monitoring="on"/>
</SQLMonitoring>
</Monitoring>
<AuthenticationManager>
<!-- Administrador para la consola de adminsitracion -->
<Admin>
<User username="admin"
password="admin"/>
</Admin>
<!-- Usuario virtual que usa nuestra aplicacion cliente
para
acceder a la bbdd
virtual-->
<VirtualUsers>
<VirtualLogin vLogin="itecban"
vPassword="itecban"/>
</VirtualUsers>
</AuthenticationManager>
<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>
</DatabaseBackend>
<RequestManager caseSensitiveParsing="false">
<RequestScheduler>
<SingleDBScheduler level="passThrough"/>
</RequestScheduler>
<RequestCache>
<MetadataCache/>
<ParsingCache/>
<ResultCache granularity="table">
<DefaultResultCacheRule>
<RelaxedCaching timeout="10"
keepIfNotDirty="false"/>
</DefaultResultCacheRule>
</ResultCache>
</RequestCache>
<LoadBalancer>
<SingleDB/>
</LoadBalancer>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
