[Sequoia] need help setting up sequoia for tomcat, oracle 10g

[Noushin Bashir]

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

a.      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
Sequoia@lists.forge.continuent.org
https://forge.continuent.org/mailman/listinfo/sequoia