My config files look the next:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE SEQUOIA-CONTROLLER PUBLIC "-//Continuent//DTD SEQUOIA-CONTROLLER
@VERSION@//EN" "C:/sequoia/xml/sequoia-controller-3.0-beta2.dtd">
<SEQUOIA-CONTROLLER>
<Controller name="mainPCController" jdbcIpAddress="192.168.0.2"
jdbcPort="25322">
<JmxSettings jmxIpAddress="192.168.0.2" jmxPort="1090"/>
<VirtualDatabaseAutoLoad configFile="Xml/pcDB.xml"
virtualDatabaseName="VirtualDatabase" autoEnableBackends="true"/>
</Controller>
</SEQUOIA-CONTROLLER>
And
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA SYSTEM "C:/sequoia/xml/sequoia-3.0-beta2.dtd">
<SEQUOIA>
<VirtualDatabase name="VirtualDatabase">
<Distribution>
<MessageTimeouts/>
</Distribution>
<Backup>
<Backuper backuperName="MSSQLServer" className="
org.continuent.sequoia.controller.backup.backupers.MSSQLBackuper"/>
</Backup>
<AuthenticationManager>
<AdminUser username="admin" password=""/>
<VirtualUser vLogin="sa" vPassword="1"/>
</AuthenticationManager>
<DatabaseBackend name="mainPCDB"
driver="net.sourceforge.jtds.jdbc.Driver"
url="jdbc:jtds:sqlserver://192.168.0.2/VirtualDatabase"
connectionTestStatement="SELECT 1">
<ConnectionManager vLogin="sa"
rLogin="sa"
rPassword="1">
<VariablePoolConnectionManager
initPoolSize="10"
minPoolSize="5"
maxPoolSize="50"
idleTimeout="30"
waitTimeout="30"/>
</ConnectionManager>
</DatabaseBackend>
<DatabaseSchema/>
<RequestManager>
<RequestScheduler>
<RAIDb-1Scheduler level="passThrough"/>
</RequestScheduler>
<RequestCache>
<MetadataCache/>
<ParsingCache/>
<!-- <ResultCache granularity="table"/> -->
</RequestCache>
<LoadBalancer>
<RAIDb-1>
<WaitForCompletion policy="first"/>
<RAIDb-1-LeastPendingRequestsFirst/>
</RAIDb-1>
</LoadBalancer>
<EmbeddedRecoveryLog/>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
--
Best regards,
Denis Garyachy.
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia