Create new jndi connection

Support questions related to CloverETL Server

tarun.sundan
Posts: 1
Joined: Tue Jun 09, 2015 9:50 pm

Create new jndi connection

Postby tarun.sundan » Tue Jun 09, 2015 9:57 pm

How can I create a jndi connection in Clover ETL server. I need to use this jndi connection in my components for reading and writing to the database.

simaj
Posts: 27
Joined: Fri Apr 03, 2015 12:27 pm

Re: Create new jndi connection

Postby simaj » Wed Jun 10, 2015 3:32 pm

Hi,

This is how JNDI connection can be configured on Apache Tomcat. For any other application server please refer to the corresponding manual.

First, declare resources. To do that, find and edit server.xml file by adding a new element under <GlobalNamingResources> in the following format:

Code: Select all

<Resource name="jdbc/clover_server" auth="Container"
type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://192.168.1.100:3306/clover?useUnicode=true&amp;characterEncoding=utf8"
username="root" password="" maxActive="20" maxIdle="10" maxWait="-1"/>


Then open connection wizard and put the resource name ( java:comp/env/jdbc/clover_server in this case) into JNDI box.

Restart the Apache Tomcat.

For more information please refer to the manual.

CloverETL
ApacheTomcat
Jakub Sima
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com