Learn more
 

Create a Data Access Object for RSS Feeds using JDBI


A brief overview of creating a SQL Object API for RSS feeds in JDBI.

JDBI is a SQL convenience library for Java that exposes two different style APIs, a fluent style and a SQL object style. The CData JDBC Driver for RSS integrates connectivity to live RSS feeds in Java applications. By pairing these technologies, you gain simple, programmatic access to RSS feeds. This article walks through building a basic Data Access Object (DAO) and the accompanying code to read RSS feeds.

Create a DAO for the RSS Latest News Entity

The interface below declares the desired behavior for the SQL object to create a single method for each SQL statement to be implemented.

public interface MyLatest NewsDAO { //request specific data from RSS (String type is used for simplicity) @SqlQuery("SELECT Pubdate FROM Latest News WHERE Category = :category") String findPubdateByCategory(@Bind("category") String category); /* * close with no args is used to close the connection */ void close(); }

Open a Connection to RSS

Collect the necessary connection properties and construct the appropriate JDBC URL for connecting to RSS.

You can connect to RSS and Atom feeds, as well as feeds with custom extensions. To connect to a feed, set the URL property. You can also access secure feeds. A variety of authentication mechanisms are supported. See the help documentation for details.

Built-in Connection String Designer

For assistance in constructing the JDBC URL, use the connection string designer built into the RSS JDBC Driver. Either double-click the JAR file or execute the jar file from the command-line.

java -jar cdata.jdbc.rss.jar

Fill in the connection properties and copy the connection string to the clipboard.

A connection string for RSS will typically look like the following:

jdbc:rss:URI=http://broadcastCorp/rss/;

Use the configured JDBC URL to obtain an instance of the DAO interface. The particular method shown below will open a handle bound to the instance, so the instance needs to be closed explicitly to release the handle and the bound JDBC connection.

DBI dbi = new DBI("jdbc:rss:URI=http://broadcastCorp/rss/;"); MyLatest NewsDAO dao = dbi.open(MyLatest NewsDAO.class); //do stuff with the DAO dao.close();

Read RSS Feeds

With the connection open to RSS, simply call the previously defined method to retrieve data from the Latest News entity in RSS.

//disply the result of our 'find' method String pubdate = dao.findPubdateByCategory("US"); System.out.println(pubdate);

Since the JDBI library is able to work with JDBC connections, you can easily produce a SQL Object API for RSS by integrating with the CData JDBC Driver for RSS. Download a free trial and work with live RSS feeds in custom Java applications today.

Ready to get started?

Download a free trial of the RSS Driver to get started:

 Download Now

Learn more:

RSS Feeds Icon RSS JDBC Driver

Easy-to-use RSS client driver enables developers to build Java applications that easily consume RSS feeds.

In this article

Related articles