Hi,guys,
I'm testing sequoia with oracle8i,now i have one confusions,
Although gatherSystemTables="false" was set, when i start console to admin
myDB, and "show tables" i can see a lot of system tables,why this happended?how
to hide these system tables?
My virtual database configuration is as follows,any suggestion will be
appreciated!
*****************virtual database configuration*******************
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.9//EN"
"http://sequoia.continuent.org/dtds/sequoia-2.10.9.dtd";>
<SEQUOIA>
<VirtualDatabase name="myDB">
<Monitoring>
<SQLMonitoring defaultMonitoring="off">
<SQLMonitoringRule queryPattern="^select" caseSensitive="false"
applyToSkeleton ="false" monitoring="on"/>
</SQLMonitoring>
</Monitoring>
<Backup>
<Backuper backuperName="Octopus"
className="org.continuent.sequoia.controller.backup.backupers.OctopusBackuper"
options="zip=true"/>
</Backup>
<AuthenticationManager>
<Admin>
<User username="admin" password=""/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="user" vPassword=""/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="oracle8" driver="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@10.129.213.200:1521:lb"
connectionTestStatement="select * from dual">
<DatabaseSchema dynamicPrecision="table" gatherSystemTables="false"/>
<ConnectionManager vLogin="user" rLogin="system" rPassword="manager">
<VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend>
<RequestManager>
<RequestScheduler>
<RAIDb-1Scheduler level="passThrough"/>
</RequestScheduler>
<LoadBalancer>
<RAIDb-1>
<WaitForCompletion policy="first"/>
<RAIDb-1-LeastPendingRequestsFirst/>
</RAIDb-1>
</LoadBalancer>
<RecoveryLog driver="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb:hsql://localhost:9001" login="TEST" password="">
<RecoveryLogTable tableName="RECOVERY" />
<CheckpointTable tableName="CHECKPOINT"/>
<BackendTable tableName="BACKEND"/>
<DumpTable tableName="DUMP"/>
</RecoveryLog>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
---------------------------------
天生购物狂，狂抢购物券，你还等什么！ _______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
