Configure Clover ETL server conn to oracle database failed

roy2090

• December 06, 2012 00:00

• Answered

Follow

Hi Experts

I installed clover ETL server on Linux64, and try to configure it connect to oracle database according to Doc description

Change the config.properties under ../WEB-INF as following:

jdbc.driverClassName=oracle.jdbc.OracleDriver
jdbc.url=jdbc:oracle:thin:@host:1521:db
jdbc.username=user
jdbc.password=pass
jdbc.dialect=org.hibernate.dialect.Oracle9Dialect

I also add jdbc jar into CLASSPATH. but http://host:8000/clover can not work as below error

HTTP Status 404 -

type Status report

message

description The requested resource is not available.

Apache Tomcat/6.0.36

Can you please give me some direction for fixing this issue. thanks

• 

  slechtaj

  • December 06, 2012 16:44

  0

  Comment actions Permalink

  Hi Roy,
  
  I can see two potential causes:
  
  

  
  
  • It is highly recommended to set context parameters in context configuration file instead of writing it into config.properties under /WEB-INF directory. For more information about parameters configuration, please refer to http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/index.html.
    
  
  
  • I am not sure where you put the jar file with JDBC driver, since this should be placed in /WEB-INF/lib.

  
  
  Could you please follow aforementioned steps to set the properties, and check where you loaded the jar file?
  
  In case you still cannot connect to your database, it would be helpful if you send us your Clover log files ([tomcat_home]/temp/cloverlogs/).
  
  Regards,
  Jan
• 

  admin

  • December 07, 2012 08:07

  0

  Comment actions Permalink

  Hi Roy,
  
  just small correction - put your JDBC driver into [tomcat_home]/lib and NOT into [tomcat_home]/webapps/cover/WEB-INF/lib as Jan suggested.
  
  General rule is that user should not change anything in [tomcat_home]/webapps because any further deploy will rewrite any changes.

Please sign in to leave a comment.