Connect to TaxJar Data from a Connection Pool in Jetty

The CData JDBC driver for TaxJar is easy to integrate with Java Web applications. This article shows how to efficiently connect to TaxJar data in Jetty by configuring the driver for connection pooling. You will configure a JNDI resource for TaxJar in Jetty.

Configure the JDBC Driver for Salesforce as a JNDI Data Source

Follow the steps below to connect to Salesforce from Jetty.

1. Enable the JNDI module for your Jetty base. The following command enables JNDI from the command-line:

   java -jar ../start.jar --add-to-startd=jndi
2. Add the CData and license file, located in the lib subfolder of the installation directory, into the lib subfolder of the context path.

3. Declare the resource and its scope. Enter the required connection properties in the resource declaration. This example declares the TaxJar data source at the level of the Web app, in WEB-INF\jetty-env.xml.

   <Configure id='taxjardemo' class="org.eclipse.jetty.webapp.WebAppContext"> <New id="taxjardemo" class="org.eclipse.jetty.plus.jndi.Resource"> <Arg><Ref refid="taxjardemo"/></Arg> <Arg>jdbc/taxjardb</Arg> <Arg> <New class="cdata.jdbc.taxjar.TaxJarDriver"> <Set name="url">jdbc:taxjar:</Set> <Set name="APIKey">3bb04218ef8t80efdf1739abf7257144</Set> </New> </Arg> </New> </Configure>

   To authenticate to the TaxJar API, you will need to first obtain the API Key from the TaxJar UI.

   NOTE: the API is available only for Professional and Premium TaxJar plans.

   If you already have a Professional or Premium plan you can find the API Key by logging in the TaxJar UI and navigating to Account -> TaxJar API. After obtaining the API Key, you can set it in the APIKey connection property.

   Additional Notes

   • By default, the CData connector will retrieve data of the last 3 months in cases where the entity support date range filtering. You can set StartDate to specify the minimum creation date of the data retrieved.
   • If the API Key has been created for a sandbox API account please set UseSandbox to true, but not all endpoints will work as expected. For more information, refer to the TaxJar developer documentation.

4. Configure the resource in the Web.xml:

   jdbc/taxjardb javax.sql.DataSource Container

5. You can then access TaxJar with a lookup to java:comp/env/jdbc/taxjardb: InitialContext ctx = new InitialContext(); DataSource mytaxjar = (DataSource)ctx.lookup("java:comp/env/jdbc/taxjardb");

More Jetty Integration

The steps above show how to configure the driver in a simple connection pooling scenario. For more use cases and information, see the Working with Jetty JNDI chapter in the Jetty documentation.