Define JNDI For Pentaho BA Server 5.0

Hello Guys,

In this post i would like to explain How to Define JNDI For Pentaho BA Server 5.0

Add Driver :

Place appropriate driver for Sql Server 8 and 12  which is jtds-1.3.0.jar to this directory for the BA Server: /pentaho/server/biserver-ee/tomcat/lib/.

1)  Stop server  & BA server.

2) Edit the /tomcat/webapps/pentaho/WEB-INF/web.xml file.

<!-- insert additional listeners -->

<resource-ref>

    <description>Database_name</description>

    <res-ref-name>jdbc/Connection_name</res-ref-name>

    <res-type>javax.sql.DataSource</res-type>

    <res-auth>Container</res-auth>

</resource-ref>

3) Open & Modify this file biserver-ce/pentaho-solutions/system/simple-jndi/jdbc.properties.

Add this line at bottom and change sqltest to database name.

Connection_name/type=javax.sql.DataSource

Connection_name/driver=net.sourceforge.jtds.jdbc.Driver

Connection_name/url=jdbc:jtds:sqlserver://sqltest:1433/Database_name

Connection_name/user=root

Connection_name/password=password

4)Open & modify this file /tomcat/webapps/pentaho/META-INF/context.xml.

<!-- The contents of this file will be loaded for each web application -->

<Resource name="jdbc/Connection_name"

    auth="Container" type="javax.sql.DataSource"

    factory="org.apache.commons.dbcp.BasicDataSourceFactory"

    maxActive="20"

    maxIdle="5"

    maxWait="10000"

    username="root"

    password="password"

    driverClassName="net.sourceforge.jtds.jdbc.Driver"

    url="jdbc:jtds:sqlserver://sqltest:1433/Database_name"

/>

5) Delete the pentaho.xml filed located in the /tomcat/conf/catalina/directory.

6) Start tomcat and BA Server

 

Hope this post helps someone and feel free to give comments and suggestion

Sumit Bansal
BI Developer

"The beautiful thing about learning is nobody can take it away from you."