Hi,
I'm not sure, if you just forgot to mention it, but did you enable the
backends?
You have to initialize the first one, then transfer a dump to the second
one and after that enable both of them.
For further information on this procedure, just take a look into the
documentation.
Best regards,
Malte
Noushin Bashir schrieb:
Hello, I am trying to evaluate sequoia for clustering our oracle
databases. I am running into basic problems that I am hoping you can
help me solve.
Our application runs under tomcat 5.5.23 and uses Oracle 10g as the
backend database. I have downloaded sequoia 2.8.10.
My controller.xml:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE SEQUOIA-CONTROLLER PUBLIC "-//Continuent//DTD
SEQUOIA-CONTROLLER 2.10.8//EN"
"http://sequoia.continuent.org/dtds/sequoia-controller-2.10.8.dtd";>
<SEQUOIA-CONTROLLER>
<Controller port="25322">
<Report hideSensitiveData="true" generateOnShutdown="true"
generateOnFatal="true" enableFileLogging="true" />
<JmxSettings>
<RmiJmxAdaptor/>
</JmxSettings>
</Controller>
</SEQUOIA-CONTROLLER>
My myDB.xml:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.8//EN"
"http://sequoia.continuent.org/dtds/sequoia-2.10.8.dtd";>
<SEQUOIA>
<VirtualDatabase name="myDB">
<AuthenticationManager>
<Admin>
<User username="admin" password="c-jdbc"/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="vuser" vPassword="vpass"/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="localhost"
driver="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@my_host:1521:my_db_sid"
connectionTestStatement="select * from dual">
<ConnectionManager vLogin="vuser" rLogin="my_user"
rPassword="my_pass">
<VariablePoolConnectionManager initPoolSize="40"/>
</ConnectionManager>
</DatabaseBackend>
<RequestManager>
<RequestScheduler>
<SingleDBScheduler level="passThrough"/>
</RequestScheduler>
<RequestCache>
<MetadataCache/>
<ParsingCache/>
<ResultCache granularity="table"/>
</RequestCache>
<LoadBalancer>
<SingleDB/>
</LoadBalancer>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
Here are the steps I take:
1. copy sequoia-drivers.jar to $TOMCAT_HOME/common/lib
2. start controller
3. start console
4. load config file
1. load virtualdatabase configuration
../config/virtualdatabase/myDB.xml
5. start tomcat
Here is my java code and the exception I receive when trying to
execute my SQL query:
Connection conn = *null*;
*try* {
Class./forName/("org.continuent.sequoia.driver.Driver");
conn =
DriverManager./getConnection/("jdbc:sequoia://my_host/myDB;user=vuser;password=vpass");
pstmt = conn.prepareStatement(/MY_SQL_STATEMENT/);
rs = pstmt.executeQuery(); <<<<<<<<<<<<<<<<<<<<<<<<<<<
}
*catch* (Exception ex) {
ex.printStackTrace();
}
I receive a DriverSQLException when it tries to execute
"pstmt.executeQuery()";
org.continuent.sequoia.common.exceptions.driver.DriverSQLException:
Message of cause: No available backend to execute request 1
Why is that? I cannot proceed passed this exception.
What do you think I am missing? I have copied classes12_g.jar to
C:\Program Files\sequoia-2.10.8-bin\lib. Do I need to copy it to
another directory?
Please advise.
Noushin
------------------------------------------------------------------------
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
