Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: How do you move platform 3.5 to oracle repository?

  1. #1
    Join Date
    Apr 2007
    Posts
    2,009

    Default How do you move platform 3.5 to oracle repository?

    Hi, i have a CE 3.5 snapshot platform running that i want to move to an oracle soltion repository.

    I found this guide, but it doesnt seem to be relevant:

    http://wiki.pentaho.com/display/Serv...for+Oracle+10g

    Is there another doc? Or can it simply be done entirely by the enterprise console or something?

    Thanks,
    Dan

  2. #2
    Join Date
    Apr 2007
    Posts
    2,009

    Default

    Ok, so it's a simple as running the 2 oracle scripts to create the user/db and then editing these 2 files:

    hibernate-settings.xml
    oracle10g.hibernate.cfg.xml

    in

    biserver-ce\pentaho-solutions\system\hibernate

    Then it works, very easy!

    So basically ignore the 2.0 instructions!

  3. #3
    Join Date
    Apr 2007
    Posts
    2,009

    Default

    wow. oracle repository is a LOT slower than a local hibernate one!

  4. #4

    Default Oracle Repository

    I also had to change the context.xml file in tomcat/webapps/pentaho/meta-inf/context.xml

    Then I moved security as well for the applicationContext-spring-security-jdbc.xml to oracle
    and
    applicationcontext-spring-securit-hibernate.properties.xml to oracle. (dialect= oracle10gDialect)



    I moved quartz and hibernate to Oracle and on a 64bit server (win2003 64bit server) with two quad core processors and 16GB ram (also runs oracle production DB and Crystal reports server xi). The performance seemed to be much better than hibernate for me. I also ran tomcat native 64bit at the same time so it used more ram and may have been the performance difference I saw.

    FYI- I have only just started using Pentaho....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.