<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Kristo Prifti on Medium]]></title>
        <description><![CDATA[Stories by Kristo Prifti on Medium]]></description>
        <link>https://medium.com/@kristoprifti93?source=rss-d2b024e1f7f5------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*9q9uKUex7qNbRDlx0a3chQ.jpeg</url>
            <title>Stories by Kristo Prifti on Medium</title>
            <link>https://medium.com/@kristoprifti93?source=rss-d2b024e1f7f5------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Wed, 18 Nov 2026 09:58:52 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@kristoprifti93/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[How to use CData JDBC Driver for Salesforce (Android Edition)]]></title>
            <link>https://medium.com/@kristoprifti93/how-to-use-cdata-jdbc-driver-for-salesforce-android-edition-6e54a26eb536?source=rss-d2b024e1f7f5------2</link>
            <guid isPermaLink="false">https://medium.com/p/6e54a26eb536</guid>
            <category><![CDATA[salesforce]]></category>
            <category><![CDATA[android]]></category>
            <category><![CDATA[jdbc]]></category>
            <category><![CDATA[cdata]]></category>
            <category><![CDATA[android-app-development]]></category>
            <dc:creator><![CDATA[Kristo Prifti]]></dc:creator>
            <pubDate>Mon, 10 Apr 2017 13:17:25 GMT</pubDate>
            <atom:updated>2017-04-12T10:23:19.924Z</atom:updated>
            <content:encoded><![CDATA[<p>The reason of this article is to demonstrate the implementation of the CData JDBC Driver for Salesforce in an Android App and to make it easier for them to adapt the functionality of the driver according to their needs!</p><p>The Android edition of JDBC Driver for Salesforce allows you to access Salesforce data from an Android app and perform CRUD operations on them.</p><ol><li><strong>Including the driver in your Android project.</strong></li></ol><p>After creating a new Android Studio project, the driver must be added as a dependency on the project module. In order to do that, you need to add the jar file to the libs folder first. Go to the project folder and then inside the “app” folder you must find or create a “libs” folder in which you must paste the jar file. After that you must follow the steps below:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/600/1*nC20hFYHZonOJfwpEbqD1w.gif" /></figure><p>File -&gt; Project Structure -&gt; app Module. Once you are in the module of your app you need to go to “Dependencies” tab. On the upper left corner you need to click the (+) button and choose “Jar dependency” option. You must select the jar file of the driver on the file browser window and click OK.</p><p><strong>2. Setting up a connection string to the Salesforce</strong></p><p>In order to set up a connection to the salesforce, you must create a connection string which contains a set of properties required for the connection. For this purpose you need to use the Property object in order to include all these properties in it as in the code snippet below :</p><pre>Properties connProps = new Properties();<br>// set your connection properties<br>connProps.setProperty(&quot;Password&quot;, &quot;***&quot;);<br>connProps.setProperty(&quot;Security Token&quot;, &quot;***&quot;);<br>connProps.setProperty(&quot;User&quot;, &quot;***&quot;);<br>connProps.setProperty(&quot;UseSandbox&quot;, &quot;false&quot;);<br>connProps.setProperty(&quot;CacheMetadata&quot;, &quot;true&quot;);<br>connProps.setProperty(&quot;AutoCache&quot;, &quot;true&quot;);<br>connProps.setProperty(&quot;CacheLocation&quot;, &quot;Path on your device<em>&quot;</em>);<br>if(isNetworkConnected()){<br>    connProps.setProperty(&quot;Offline&quot;, &quot;true&quot;);<br>}</pre><p>You must check for the availability of the internet connection through the following function :</p><pre>public static boolean isNetworkConnected(Context context) {<br>    ConnectivityManager cm = (ConnectivityManager) context.getSystemService(Context.<em>CONNECTIVITY_SERVICE</em>);<br><br>    return cm.getActiveNetworkInfo() != null;<br>}</pre><p>If there is no internet connection in the device you must add the Offline property to the connection string so you can make the Read request in the cache database saved on the device. Otherwise you can query the real database online. Finally, after creating the connection string properties you must parse all the property values into a String variable:</p><pre>//this method iterates the properties and creates a string variable<br>private static String composeConnectionString(Properties connProps){<br>    String connectionString = &quot;jdbc:salesforce:&quot;;<br>    Enumeration properties = connProps.propertyNames();<br>    while (properties.hasMoreElements()){<br>        String name = (String)properties.nextElement();<br>        String value = connProps.getProperty(name);<br>        connectionString += (name + &quot;=&quot; + value + &quot;;&quot;);<br>    }<br>    return connectionString;<br>}</pre><p>After creating the string, its time to open the connection with it. In order to open a connection you execute the following lines:</p><pre>Class.<em>forName</em>(&quot;cdata.jdbc.salesforce.SalesforceDriver&quot;);<br>Connection conn = DriverManager.<em>getConnection</em>(connectionString);</pre><p>The connection string variable is passed as an argument to the getConnection method that is called in the JDBC Driver and now you finally have a connection set up. In this connection you may execute any of the CRUD operations that you prefer. It is very important for the performance of the app to close the connection once you are done with it. This way you avoid the memory leaks as well. You need to do this by calling the “close” method as below:</p><pre>conn.close();</pre><p><strong>3. Execute CRUD Operations on the open connection</strong></p><p>As an example for the tutorial, I have taken the “Lead” table from Salesforce. You will be performing the CRUD operations on that specific table.</p><p><strong>3.1 Read Operation</strong></p><p>In order to perform an operation in the open connection, you must create an SQL statement in a String variable. Then you should create a statement in the connection that is open in order to pass this string variable as a parameter and get the query result back as a ResultSet.</p><pre>String sql = &quot;SELECT * FROM Lead&quot;;<br>ResultSet cursor = conn.createStatement().executeQuery(sql);<br>ResultSetMetaData metaData = cursor.getMetaData();</pre><p>After you get the result set from the query, you must iterate through the resultset and save the data in a model class which is also serializable so you can move the data through intents and activities. An example of a serializable object class must be as follows:</p><pre>public class RowModel implements Serializable{<br><br>    private String fieldValue;<br>    private String fieldType;<br>    private boolean readOnly;<br>    private int nullable;<br><br>    public RowModel() {<br>    }<br><br>    public String getFieldValue() {<br>        return fieldValue;<br>    }<br><br>    public boolean isReadOnly() {<br>        return readOnly;<br>    }<br><br>    public String getFieldType() {<br>        return fieldType;<br>    }<br><br>    public int getNullable() {<br>        return nullable;<br>    }<br><br>    public void setFieldValue(String fieldValue) {<br>        this.fieldValue = fieldValue;<br>    }<br><br>    public void setFieldType(String fieldType) {<br>        this.fieldType = fieldType;<br>    }<br><br>    public void setReadOnly(boolean readOnly) {<br>        this.readOnly = readOnly;<br>    }<br><br>    public void setNullable(int nullable) {<br>        this.nullable = nullable;<br>    }<br>}</pre><p>The RowModel object contains different properties such as the field value for each row, field type for the specific field, property that shows if the field is read-only or not and if the field can be null or not. After creating the model you must iterate all values from the resultset and save them in an ArrayList of RowModel objects in order to pass them to the user interface and between activities.</p><pre>List&lt;Map&lt;String, RowModel&gt;&gt; rowsList = new ArrayList&lt;&gt;();</pre><pre>int columnCount = metaData.getColumnCount();<br>while (cursor.next()) {<br>    Map&lt;String, RowModel&gt; columns = new HashMap&lt;&gt;();<br>    for (int i = 1; i &lt;= columnCount; i++) {<br>        RowModel rowModel = new RowModel();<br>        rowModel.setFieldType(metaData.getColumnTypeName(i));<br>        rowModel.setFieldValue(String.<em>valueOf</em>(cursor.getObject(i)));<br>        rowModel.setNullable(metaData.isNullable(i));<br>        rowModel.setReadOnly(metaData.isReadOnly(i));<br>        <br>        columns.put(metaData.getColumnLabel(i), rowModel);<br>    }<br>    rowsList.add(columns);<br>}</pre><p>After the population of the ArrayList you are free to chose how to use this ArrayList according to our needs, either populate a recycler view or a table view with these data through a custom adapter. Below, there is an article which shows a step by step guide on how to populate the recycler view with the data that you already have on the ArrayList:</p><p><a href="http://www.survivingwithandroid.com/2016/09/android-recyclerview-tutorial.html">Android RecyclerView tutorial: Custom Adapter, Decoration, Item clicks</a></p><p><strong>3.2 Update Operation</strong></p><p>The Update operation is somehow similar to the Read operation as you must create again an SQL string variable and execute it in the open connection. In the Custom Adapter, I have added just an EditText control and I show the values of each column in a different edit text. Also the editable property of the edit text control is based on the Read-Only property of the column.</p><p>An update statement is created when the user hits the save button on the screen after he has done different modifications in the data. Before the update statement is created, all the values from edit texts are saved in an ArrayList of strings, respectively for column names and column values:</p><pre>ArrayList&lt;String&gt; columnNames = getColumnNames(true);<br>ArrayList&lt;String&gt; columnValues = getColumnValues(true);</pre><pre>public ArrayList&lt;String&gt; getColumnNames() {<br>    ArrayList&lt;String&gt; mColumnNames = new ArrayList&lt;&gt;();<br>    for(int i = 0; i &lt; columnsList.size(); i++){<br>     if(columnsList.get(i).isEnabled()){<br>     mColumnNames.add(String.<em>valueOf</em>(columnsList.get(i).getHint()));<br>     }<br>    }<br>    return mColumnNames;<br>}</pre><pre>public ArrayList&lt;String&gt; getColumnValues() {<br>    ArrayList&lt;String&gt; mColumnValues= new ArrayList&lt;&gt;();<br>    for(int i = 0; i &lt; columnsList.size(); i++){<br>       if(columnsList.get(i).isEnabled()){<br>       mColumnValues.add(columnsList.get(i).getText().toString());<br>       }<br>    }<br>    return mColumnValues;<br>}</pre><p>After you get all the recent values when the user clicks the save button, you have to build an update statement based on the new values dynamically. In order to do this you have to iterate through the two ArrayLists that you have created in order to make sure you include all the columns in the update statement. However you have to check if the read-only property is true or not because you cannot update the read-only values in the query.</p><p>You must use the StringBuilder class in order to parse dynamically all the field values and column names in the update query variable that you have to create. In this update operation, its really important to use the ID of the row since every different record in the table has a unique ID column.</p><pre>StringBuilder sb = new StringBuilder(&quot;UPDATE &quot;).append(&quot;Lead<em>&quot;</em>).append(&quot; SET &quot;);<br>for(int i = 0; i &lt; columnNames.size(); i++){<br>    if(notFirstRecord){<br>            sb.append(&quot; , &quot;);<br>        }<br>        notFirstRecord = true;<br>        sb.append(columnNames.get(i))<br>          .append(&quot;=&quot;).append(&quot;&#39;&quot;)<br>          .append(columnValues.get(i)).append(&quot;&#39;&quot;);<br>}<br>sb.append(&quot; WHERE Id = ?&quot;);<br>PreparedStatement pstmt = conn.prepareStatement(String.<em>valueOf</em>(sb));<br>pstmt.setString(1, params[0]);<br>//params[0] -&gt; the ID of the row</pre><p>The process of the execution of the query is almost the same as in the Read operation. In the prepared statement above, you can call the method executeUpdate in order to execute the prepared statement in a string value and perform the query. You save the result of the query in an integer variable in order to check if any record is updated or not.</p><pre>int countUpdate = pstmt.executeUpdate();</pre><p><strong>3.3 Delete Operation</strong></p><p>In the delete operation it is very important to use again the ID column of the row in the where statement in order to delete the right record. You must create a delete SQL statement and pass the ID of the row in the prepared statement. Then you must execute the query and count the affected rows.</p><pre>String cmd = &quot;DELETE FROM Lead WHERE Id = ?&quot;;<br>PreparedStatement pstmt = conn.prepareStatement(cmd);<br>pstmt.setString(1, params[0]);<br>int countDelete = pstmt.executeUpdate();</pre><p><strong>3.4 Create Operation</strong></p><p>In the activity responsible for the Create operation you need to pass the names of the columns that are not read-only in order to create some EditTexts for every column that the user must fill in.</p><pre>Map&lt;String, RowModel&gt; oneRowMap = (Map&lt;String, RowModel&gt;) getIntent().getSerializableExtra(getString(R.string.<em>table_single_row_key</em>));</pre><p>The next step is to iterate through each column name and create EditTexts. At the same time you must save the EditTexts in an ArrayList of EditTexts in order to keep track of the user values when you create the dynamic SQL query for creating the new record.</p><pre>ArrayList&lt;EditText&gt; columnsList = new ArrayList&lt;&gt;();<br><br>while(it.hasNext()){<br>    final Map.Entry pair = (Map.Entry) it.next();<br><br>    RowModel currentRowModel = (RowModel) pair.getValue();<br><br>    if(!currentRowModel.isReadOnly()){<br>        TextInputLayout textInputLayout = new TextInputLayout(this);<br>        textInputLayout.setId(View.<em>generateViewId</em>());<br>        textInputLayout.setHint(pair.getKey().toString());<br>        textInputLayout.setErrorEnabled(true);<br><br>        TextInputEditText editText = new TextInputEditText(this);<br>        editText.setId(View.<em>generateViewId</em>());<br>        editText.setText(&quot;&quot;);<br>        editText.setHint(pair.getKey().toString());<br>        editText.setTextSize(14);<br>        columnsList.add(editText);<br><br>        textInputLayout.addView(editText);<br>    }<br>}</pre><p>Now you may access the list of edit texts anytime and get the user values and the column names easily in order to build a dynamic SQL statement. When the user clicks the save button, you must create a new record in the table. You need to generate a dynamic SQL query based on user info and the column names.</p><pre>StringBuilder sb = new StringBuilder(&quot;INSERT INTO Lead (&quot;);<br>//Adding column names to the SQL Statement<br>for(int i = 0; i &lt; columnNames.size(); i++){<br>    if(notFirstRecord){<br>        sb.append(&quot; , &quot;);<br>    }<br>    notFirstRecord = true;<br>    sb.append(columnNames.get(i));<br>}<br>sb.append(&quot;) VALUES (&quot;);<br><br>notFirstRecord = false;<br>//Adding column values to the SQL Statement<br>for(int i = 0; i &lt; columnNames.size(); i++){<br>    if(notFirstRecord){<br>        sb.append(&quot; , &quot;);<br>    }<br>    notFirstRecord = true;<br>    sb.append(&quot;&#39;&quot;).append(columnValues.get(i)).append(&quot;&#39;&quot;);<br>}<br>sb.append(&quot;)&quot;);<br><br>PreparedStatement pstmt = conn.prepareStatement(String.<em>valueOf</em>(sb));</pre><p>The next step is to execute this statement as in the other operations. In the Create statement we have the chance to get the auto generated keys from the prepared statement, such as ID, created date and time etc. You need these keys to display them to the user interface.</p><pre>Map&lt;String, RowModel&gt; generatedKeys = new HashMap&lt;&gt;();<br>pstmt.executeUpdate();<br>ResultSet rs = pstmt.getGeneratedKeys();</pre><p>You need to iterate through the result set and get each generated key and save it in the RowModel object that you have created for the other fields. Consider the newly created fields as normal fields except that they are read-only.</p><pre>while(rs.next()){<br>    for (int i = 1; i &lt;= rs.getMetaData().getColumnCount(); i++) {<br>        RowModel rowModel = new RowModel();<br>        rowModel.setFieldValue(String.<em>valueOf</em>(rs.getObject(i)));<br>       rowModel.setFieldType(rs.getMetaData().getColumnTypeName(i));<br>        rowModel.setNullable(rs.getMetaData().isNullable(i));<br>        rowModel.setReadOnly(true);<br>        generatedKeys.put(rs.getMetaData().getColumnLabel(i), rowModel);<br>    }<br>}</pre><p><strong>4. Searching through the table</strong></p><p>Another important functionality that the driver makes easier for us, is the searching in the tables. I have implemented such functionality in the demo app by developing a new activity in the user interface. I have included a spinner which is populated with the table columns in order to allow the user to choose a specific column and an edit text control for the search text.</p><pre>ArrayList&lt;String&gt; tableColumns = getIntent().getStringArrayListExtra(getString(R.string.<em>column_name_key</em>));<br><br>// Creating adapter for spinner<br>ArrayAdapter&lt;String&gt; spinnerAdapter = new ArrayAdapter&lt;&gt;(this, android.R.layout.<em>simple_spinner_item</em>, tableColumns);</pre><pre>// Drop down layout style - list view with radio button<br>spinnerAdapter.setDropDownViewResource(android.R.layout.<em>simple_spinner_dropdown_item</em>);</pre><pre>// attaching data adapter to spinner<br>columnNamesSpinner.setAdapter(spinnerAdapter);</pre><p>Based on the spinner value and the search value, you must create the dynamic SQL query to search for such combination when the user presses the search button. Then you must call executeQuery method passing the sql string variable to the method as below:</p><pre>String sql = &quot;SELECT * FROM Lead WHERE &quot; + columnNamesSpinner.getSelectedItem().toString() + &quot; LIKE &#39;%&quot; + textSearch.getText().toString() + &quot;%&#39;;&quot;;<br>//textSearch is the EditText control from which we extract the text<br>ResultSet cursor = conn.createStatement().executeQuery(sql);<br>ResultSetMetaData metaData = cursor.getMetaData();</pre><p>The result set returns a list of values that match the criteria and you need to repeat the same steps as in the Read operation by saving the data in your RowModel object and passing them to the user interface through the custom adapter.</p><p><strong>5. Offline CRUD operations</strong></p><p>The JDBC driver resolves a lot of issues for us and makes the process of communication with Salesforce much easier. You may query and modify data when you are connected to the internet. However, in offline mode you just have access to reading the data from cache database. Driver does not take care of the offline operations for you. I have implemented a workaround about the offline operations.</p><p>Every time that the user tries to execute an Update, Create or Delete statement while in offline mode, the SQL query needs to be cached in your device. There are different external database APIs for this purpose. Personally, I have chosen Realm as it is very efficient and easy to be implemented.</p><p><a href="https://realm.io/news/realm-for-android/">https://realm.io/news/realm-for-android/</a></p><p>You must create a specific model for the queries to be saved in the Realm Database. The Query model will store the SQL string variable and the type of operation that will be executed. Below is an example of the Model.</p><pre>public class CachedQueryModel extends RealmObject {<br><br>    @PrimaryKey<br>    private String queryObject;<br>    private String operation;<br><br>    public CachedQueryModel(){<br>    }<br><br>    public String getQueryObject() {<br>        return queryObject;<br>    }<br><br>    public void setQueryObject(String queryObject) {<br>        this.queryObject = queryObject;<br>    }<br><br>    public String getOperation() {<br>        return operation;<br>    }<br><br>    public void setOperation(String operation) {<br>        this.operation = operation;<br>    }<br>}</pre><p>Realm will create a table for you and store every operation that the user does if there is no internet access on the device. Just like the connection with the driver, there must be an internal connection with the realm database. Once the connection is open, database can be modified and you must close the connection when you finish the operations in order to avoid the memory leaks. The code snippet below illustrates how to open the connection to realm and perform an insert of the query if there is no internet on the device:</p><pre>Realm realm = Realm.<em>getDefaultInstance</em>();</pre><pre>CachedQueryModel currentQuery = new CachedQueryModel();<br>currentQuery.setQueryObject(yourQueryString);<br>currentQuery.setOperation(&quot;CREATE&quot;);<br><br>realm.beginTransaction();<br>realm.copyToRealm(currentQuery);<br>realm.commitTransaction();</pre><pre>realm.close();</pre><p>But saving the operations in the Realm database is not enough. These operations will need to be executed automatically when the connectivity status is changed in the device and specifically when the internet is available. For this purpose you must develop a Broadcast Receiver service which is always running on the background even when your app is not running. This has an effective cost on the battery life but will get the job done! To get started with this receiver you must declare it in the AndroidManifest.xml file inside the application tag as below:</p><pre>&lt;application...<br>&lt;receiver android:name=&quot;.ConnectivityChangeReceiver&quot;<br>    android:enabled=&quot;true&quot;&gt;<br>    &lt;intent-filter&gt;<br>        &lt;action android:name=&quot;android.net.conn.CONNECTIVITY_CHANGE&quot;<br>            tools:ignore=&quot;BatteryLife&quot; /&gt;<br>    &lt;/intent-filter&gt;<br>&lt;/receiver&gt;<br>&lt;/application&gt;</pre><p>After declaring it in the Manifest you must create the java file with the same name. This class will extend the BroadcastReceiver class and automatically will inherit its abstract method OnReceive which will be triggered every time the app will change the connectivity status. Since you must execute the offline queries only when internet is available, you need to check inside this method if there is internet connection or not. If yes, then you should trigger your activity. In my case, I have created an intent service class called ExecuteCachedQueriesService as below:</p><pre>//Whenever the state of internet connection changes this method is //triggered<br>@Override<br>public void onReceive(Context context, Intent intent) {<br>    //If the internet connection state is CONNECTED then the <br>    //background service is triggered<br>    boolean isConnected = <em>isNetworkConnected</em>(context);<br>    if(isConnected){<br>        ComponentName comp = new ComponentName(context.getPackageName(),<br>                ExecuteCachedQueriesService.class.getName());<br>        context.startService(intent.setComponent(comp));<br>    }<br>}</pre><p>In the ExecuteCachedQueriesService class you must extend the IntentService class and automatically inherit the OnHandleIntent method from this class in order to run every operation on the background thread without delaying the user interface performance. You must also declare this class as a service in the AndroidManifest.xml within the application tag as below:</p><pre>&lt;application...<br>&lt;service android:enabled=&quot;true&quot;    <br>         android:name=&quot;.sync.ExecuteCachedQueriesService&quot; /&gt;<br>&lt;/application&gt;</pre><p>Every operation is done in the background in different threads and then the user interface is refreshed with latest data. In this method you must query the cache database for pending operations and execute inside a loop each and every pending record as below:</p><pre>Realm realm = Realm.<em>getDefaultInstance</em>();<br><br>RealmResults&lt;CachedQueryModel&gt; cachedModel = realm.where(CachedQueryModel.class)<br>        .findAll();<br><br>for(int i = 0; i &lt; cachedModel.size(); i++){<br>    int countAffectedRecords = conn.prepareStatement(    <br>                               cachedModel.get(i).getQueryObject()   <br>                               ).executeUpdate();<br>    RealmResults&lt;CachedQueryModel&gt; cachedModel = <br>        realm.where(CachedQueryModel.class)<br>        .equalTo(&quot;queryObject&quot;, cachedModel.get(i).getQueryObject())<br>        .findAll();<br>    realm.beginTransaction();<br>    for (int i = 0; i &lt; cachedModel.size(); i++) {<br>         cachedModel.get(i).deleteFromRealm();<br>    }<br>    realm.commitTransaction();<br>}<br><br>realm.close();</pre><p>Also for every finished pending operation you must remove this record from the Realm database as it is already executed and updated in the real database.</p><p><strong>6. Screenshots to illustrate the idea of the app</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/461/1*5FBi14SBQRGJS6xBe5zqCA.png" /><figcaption>Main Activity showing the list of rows in the Lead Table</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/461/1*XglJSAYKs0cwZRb9ebfVgw.png" /><figcaption>Search Activity showing the search options within the Lead Table</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/461/1*6z1GP0QyF-DYwAH3IUCdMg.png" /><figcaption>Result of Search Activity for First name equal to “Jack”</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/461/1*oEXWaaY3mitGZT1eM3B-QQ.png" /><figcaption>Detail Activity showing the contents of one specific row. User can edit or delete this record with the menu items on upper right corner of the screen.</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/461/1*6ahWXCu0GFFPJxCzLsoezw.png" /><figcaption>Activity that allows the user to add a new record to the table</figcaption></figure><p><strong>References:</strong></p><ol><li><a href="http://cdn.cdata.com/help/RFB/jdbc/">CData documentation for JDBC Driver</a></li><li><a href="http://www.survivingwithandroid.com/2016/09/android-recyclerview-tutorial.html">Android Recyclerview Custom Adapter</a></li><li><a href="https://realm.io/news/realm-for-android/">REALM Documentation</a></li><li><a href="http://www.vogella.com/tutorials/AndroidBroadcastReceiver/article.html">Android Broadcast Receivers</a></li><li><a href="http://www.vogella.com/tutorials/AndroidServices/article.html">Android Intent Service</a></li></ol><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=6e54a26eb536" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>