XQuery comes to the Java platform with the launch of the DataDirect XQuery™ beta program starting tomorrow on May 17th. With this important technology boundary crossed, I thought it was well overdue for some code snippets in my blogs. I think this is a habit I should develop a little more.
Enabling your Java applications with XQuery is as easy as establishing a context to an XQuery data source with the following code.
1. First, import the appropriate packages
2. Next, establish a context to the XQuery data source.Fairly simple so far, as I'm sure you will agree. Remember, XQuery does not discriminate what data source it queries as long as it can viewed as XML. With DataDirect XQuery we provide support for connecting to an XML data source using URIs including
file://
or
http://
but we also enable XQuery expressions to be written against relational data stores. To describe the data sources to connect to, we provide a simple configuration file to allow you to describe the data source to connect to.
3. Next you apply the configuration file to the DDXQDataSource:
import com.ddtek.xquery.* import com.ddtek.xquery.xqj.DDXQDataSource; |
XQDataSource dataSource = null; DDXQDataSource dataSource = (DDXQDataSource)new DDXQDataSource(); |
<?xml version="1.0"?> <XQJConnection xmlns="http://www.datadirect.com/xquery"> <JDBCConnections> <JDBCConnection prefix="my_oracle_config"> <description>My description of this particular configuration</description> <url>jdbc:xquery:oracle://hostname_or_ip:1521;SID=orcl_sid_name</url> <user>example_db_user</user> <password>example_user_pw</password> <sqlxmlMapping> <forest>true</forest> <identifierEscaping>full</identifierEscaping> </sqlxmlMapping> <catalog> <schema name="example_db_user"> </schema> </catalog> </JDBCConnection> </JDBCConnections> </XQJConnection> |
dataSource.setConfigFile( |
View all posts from Jonathan Bruce on the Progress blog. Connect with us about all things application development and deployment, data integration and digital business.
Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.
Learn MoreSubscribe to get all the news, info and tutorials you need to build better business apps and sites
Progress collects the Personal Information set out in our Privacy Policy and the Supplemental Privacy notice for residents of California and other US States and uses it for the purposes stated in that policy.
You can also ask us not to share your Personal Information to third parties here: Do Not Sell or Share My Info
We see that you have already chosen to receive marketing materials from us. If you wish to change this at any time you may do so by clicking here.
Thank you for your continued interest in Progress. Based on either your previous activity on our websites or our ongoing relationship, we will keep you updated on our products, solutions, services, company news and events. If you decide that you want to be removed from our mailing lists at any time, you can change your contact preferences by clicking here.