ObjectWeb Consortium
Search ObjectWeb Mail Archive: 

Advanced Search - Powered by Google


Mail Archive Home | c-jdbc List | May 2005 Index

<--  Date Index  --> <--  Thread Index  -->

Re: [c-jdbc] Error Starting CJDBC Controller with Oracle


Hi Abhishek

Changing your setting for dynamicPrecision to "table" should solve your problem.

See

http://c-jdbc.objectweb.org/doc/faq.html

regards

Marc


abhishek trivedi wrote:

I am using Tomcat 4.1 with C-JDBC 1.2.1 with singleDB on Oracle 9i on
Red Hat Linux Advanced Server 2.1. I have created my own configFilefor
oracle.

The c-jdbc controller startup hangs at the shown console output.

kindly do help

The required info are as below :

Console Log:
__________





ile: /C:/C-JDBC/config/controller/controller.xml
2005-05-28 18:01:43,453 INFO  controller.core.Controller JMX is enabled
2005-05-28 18:01:43,484 INFO  controller.core.Controller Starting JMX server 
on
host: 172.16.1.59
2005-05-28 18:01:44,484 INFO  backend.DatabaseBackend.claims Adding 
connection m
anager for virtual user "user"
2005-05-28 18:01:44,671 INFO  controller.RequestManager.myOrcl Request 
manager w
ill parse requests with the following granularity: TABLE
2005-05-28 18:01:44,671 WARN  controller.virtualdatabase.myOrcl No recovery 
log
has been configured, enabling backend without checkpoint.
2005-05-28 18:01:54,656 INFO  backend.DatabaseBackend.claims Detected backend 
as
: Oracle
2005-05-28 18:01:54,671 WARN  backend.DatabaseBackend.claims 
Statement.setCursor
Name not supported.
2005-05-28 18:01:54,671 WARN  backend.DatabaseBackend.claims 
Statement.getGenera
tedKeys not supported.
2005-05-28 18:01:55,156 INFO  backend.DatabaseBackend.claims Gathering 
database
schema

controller.xml
___________




<?xml version="1.0" encoding="UTF8" ?>

<!DOCTYPE C-JDBC-CONTROLLER PUBLIC "-//ObjectWeb//DTD
C-JDBC-CONTROLLER 1.2.1//EN" "http://c-jdbc.objectweb.org/dtds/c-jdbc-controller-1.2.1.dtd";>

<C-JDBC-CONTROLLER>
 <Controller port="25322" ipAddress="172.16.1.59">
   <Report hideSensitiveData="true" generateOnShutdown="true"
generateOnFatal="true" enableFileLogging="true" />
   <JmxSettings>
     <RmiJmxAdaptor/>
   </JmxSettings>
   <VirtualDatabase configFile="oracle.xml"
virtualDatabaseName="myOrcl" autoEnableBackends="true"/>
 </Controller>
</C-JDBC-CONTROLLER>





Oracle.xml:
__________



<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE C-JDBC PUBLIC "-//ObjectWeb//DTD C-JDBC 1.2.1//EN"
"http://c-jdbc.objectweb.org/dtds/c-jdbc-1.2.1.dtd";>
<C-JDBC>
  <VirtualDatabase name="myOrcl">
     <AuthenticationManager>
        <Admin>
           <User username="admin" password=""/>
        </Admin>
        <VirtualUsers>
           <VirtualLogin vLogin="user" vPassword="user"/>
        </VirtualUsers>
     </AuthenticationManager>
     <DatabaseBackend name="claims"
driver="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@172.16.1.64:1521:claims"
connectionTestStatement="select * from dual">
       <DatabaseSchema dynamicPrecision="all" gatherSystemTables="false"/>
        <ConnectionManager vLogin="user" rLogin="or1" rPassword="or1">
           <RandomWaitPoolConnectionManager poolSize="1"/>
        </ConnectionManager>
     </DatabaseBackend>
     <RequestManager caseSensitiveParsing="false" beginTimeout="60"
commitTimeout="60" rollbackTimeout="60">
        <RequestScheduler>
           <SingleDBScheduler level="passThrough"/>
        </RequestScheduler>
        <RequestCache>
           <MetadataCache maxNbOfMetadata="10000" maxNbOfField="0"/>
           <ParsingCache backgroundParsing="false" maxNbOfEntries="5000"/>
           <ResultCache pendingTimeout="0" maxNbOfEntries="100000"
granularity="table">
              <DefaultResultCacheRule timestampResolution="1">
                 <EagerCaching/>
              </DefaultResultCacheRule>
           </ResultCache>
        </RequestCache>
        <LoadBalancer>
           <SingleDB/>
        </LoadBalancer>
     </RequestManager>
  </VirtualDatabase>
</C-JDBC>




<--  Date Index  --> <--  Thread Index  -->

Reply via email to:

Powered by MHonArc.

Copyright © 1999-2005, ObjectWeb Consortium | contact | webmaster.