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
