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.
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 in the following format:
<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&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.
This recommendation DOES NOT expose a JNDI resource to Clover components. It only makes it available to the Server, which is not what the author is asking for.