Connect to Avalara AvaTax Data from a Connection Pool in Jetty

The CData JDBC driver for Avalara AvaTax is easy to integrate with Java Web applications. This article shows how to efficiently connect to Avalara AvaTax data in Jetty by configuring the driver for connection pooling. You will configure a JNDI resource for Avalara AvaTax 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 Avalara AvaTax data source at the level of the Web app, in WEB-INF\jetty-env.xml.

   <Configure id='avalarademo' class="org.eclipse.jetty.webapp.WebAppContext"> <New id="avalarademo" class="org.eclipse.jetty.plus.jndi.Resource"> <Arg><Ref refid="avalarademo"/></Arg> <Arg>jdbc/avalaradb</Arg> <Arg> <New class="cdata.jdbc.avalaraavatax.AvalaraAvataxDriver"> <Set name="url">jdbc:avalaraavatax:</Set> <Set name="User">MyUser</Set> <Set name="Password">MyPassword</Set> </New> </Arg> </New> </Configure>

   The primary method for performing basic authentication is to provide your login credentials, as follows:

   • User: Set this to your username.
   • Password: Set this to your password.

   Optionally, if you are making use of a sandbox environment, set the following:

   • UseSandbox: Set this to true if you are authenticating with a sandbox account.

   Authenticating Using Account Number and License Key

   Alternatively, you can authenticate using your account number and license key. Connect to data using the following:

   • AccountId: Set this to your Account Id. The Account Id is listed in the upper right hand corner of the admin console.
   • LicenseKey: Set this to your Avalara Avatax license key. You can generate a license key by logging into Avalara Avatax as an account administrator and navigating to Settings -> Reset License Key.

4. Configure the resource in the Web.xml:

   jdbc/avalaradb javax.sql.DataSource Container

5. You can then access Avalara AvaTax with a lookup to java:comp/env/jdbc/avalaradb: InitialContext ctx = new InitialContext(); DataSource myavalara = (DataSource)ctx.lookup("java:comp/env/jdbc/avalaradb");

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.