Connect to Salesforce Data from a Connection Pool in Jetty

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

Getting Started

---

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 Salesforce data source at the level of the Web app, in WEB-INF\jetty-env.xml.

   <Configure id='salesforcedemo' class="org.eclipse.jetty.webapp.WebAppContext">
    <New id="salesforcedemo" class="org.eclipse.jetty.plus.jndi.Resource">
    <Arg><Ref refid="salesforcedemo"/></Arg>
    <Arg>jdbc/salesforcedb</Arg>
    <Arg>
    <New class="cdata.jdbc.salesforce.SalesforceDriver">
    <Set name="url">jdbc:salesforce:</Set>
    <Set name="InitiateOAuth">GETANDREFRESH</Set>
    <Set name="MFACode">YourMFACode</Set>
    </New>
    </Arg>
    </New>
   </Configure>
   

   There are several authentication methods available for connecting to Salesforce: OAuth, Login (or basic), and SSO. The Login method requires you to have the username, password, and security token of the user.

   OAuth Authentication (default)

   The default authentication mechanism (and the one preferred by Salesforce) is OAuth. To use OAuth with CData's embedded OAuth application, leave the connection properties blank. If you have configured your own custom OAuth application with Salesforce (see the Help documentation for more information), set OAuthClientId, OAuthClientSecret, and CallbackURL to the properties for you application. Set InitiateOAuth to the desired OAuth flow ("GETANDREFRESH" will have the connector manage the entire OAuth flow).

   Login (or Basic) Authentication

   If you do not wish do not wish to use OAuth authentication, you can use Login (or basic) authentication. Set AuthScheme to Basic, and set the User, Password, and SecurityToken properties. You can configure your security token in Salesforce.

   SSO (single sign-on) Authentication

   SSO (single sign-on) can be used by setting the SSOProperties, SSOLoginUrl, and SSOExchangeURL connection properties, which allow you to authenticate to an identity provider. See the "Getting Started" chapter in the Help documentation for more information.

   Multi-Factor Authentication (MFA)

   If your Salesforce org has MFA enforcement enabled, set MFACode to the time-based one-time passcode (TOTP) generated by your authenticator app (such as Salesforce Authenticator or Google Authenticator). MFACode applies to both OAuth and Login authentication flows.

4. Configure the resource in the Web.xml:

    jdbc/salesforcedb
    javax.sql.DataSource
    Container
   
   

5. You can then access Salesforce with a lookup to java:comp/env/jdbc/salesforcedb:

   InitialContext ctx = new InitialContext();
   DataSource mysalesforce = (DataSource)ctx.lookup("java:comp/env/jdbc/salesforcedb");
   

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.