Hitachi Vantara Pentaho Community Wiki
Child pages
  • Configuring for PostgreSQL

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: removed dead link, added attachement pg-ds, added some tomcat hints

...

Now your PostgreSQL should be ready. The next step is to configure the datasources required to access the data.

You can these are my samples for jboss

 sorry for the dead link (my homepage habe been token over) now i uploaded to templates to the wiki so they should be there fine!

I will add tomcat context.xml in the near future (???)Make

if you plan to deploy on tomcat then you better use what tomcat offers you:

instead of messing with config files in conf/server.xml  or even worst creating a file under $CATALINA_HOME/conf/Catalina/localhost/yourApplication.xml

you could use what tomcat expects in your Application archive

Code Block

 pentaho
|-- META-INF
|   `-- context.xml  <---(***1***)
`-- WEB-INF
    `-- web.xml


(**1**): this file "context.xml" will be processed by tomcat at deployment time and if you define your datasources there, tomcat
will do the necessary configurations for you. an example of context.xml file will be looking like the following one:

Code Block

<Context     path="/pentaho"
               docBase="path/to/pentaho" <---(***2***)
               debug="5"
               reloadable="true"
               crossContext="true">   
    <Resource   name="jdbc/Quartz"
                auth="Container"
                type="javax.sql.DataSource"
                maxActive="100"
                maxIdle="30"
                maxWait="10000"
                username="username"
                password="password"  
                driverClassName="org.postgresql.Driver"
                url="jdbc:postgresql://localhost:5432/target-database"/>   
<!--
    You can add as many datasources as you need here

-->
</Context>

(**2**) : the docBase in tomcat is mostly something like this

Code Block

      docBase="${catalina.home}/webapps/pentaho

when you finnished creating your context.xml you can then package your war and deploy it to tomcat which will convert the context.xml of your application

assuming pentaho.war to:

Code Block

 $CATALINA_HOME/conf/Catalina/localhost/pentaho.xml

if your database are correctly set and everything went fine pentaho should be able to access the databases using the datasource defined in the context.xmlMake sure your driver is in the right location and startup your application server where Pentaho is deployed into

...