Monday 2nd, March 2009
Using XPages to Integrate Between Notes Applications with Relational Databases - Wiki article03/02/2009 03:15 PM Domino 8.5
Jo Grant and Craig Wolpert from the IBM ISV Development Enablement team, have published a new Wiki article titled
Using XPages to Integrate Between Notes Applications with Relational Databases. These guys are on a roll over there and have produced 10 great Wiki examples over the last 2 weeks. (I believe they have secretively developed an XPage vitamin they are taking that allows them to work around the clock....but I can't prove it...)
In this example they show how you can use connectivity to a MySQL database to:
1 - Create a Repeat based view of our data
2 - Create a form to view a single record
3 - Use that form to update the data
Here's a snippet from the article:
You can easily direct XPage elements to surface data from different Notes applications. It turns out not to be much harder to surface data from different back end data sources with XPages.
The key to integrating different data technologies is by binding them together with Javascript. Almost any XPage control that surfaces data has the option to surface that data from a Javascript source. So any data repository you can get to from Javascript can be used by XPages.
Relational databases (RDB) are a very widely used technology for storing data. Many relational databases are accessible through Java Database Connectivity (JDBC). And this Java interface can be called from Javascript. This is our key to surfacing RDB data in an XPage. For our example here we will show connectivity to the MySQL relational database.
Here's a link to the article: http://www-10.lotus.com/ldd/ddwiki.nsf/dx/xpage_integration_rdb.htm
Great article and nice work guys!
John
Technorati: Domino 8.5 XPages
In this example they show how you can use connectivity to a MySQL database to:
1 - Create a Repeat based view of our data
2 - Create a form to view a single record
3 - Use that form to update the data
Here's a snippet from the article:
You can easily direct XPage elements to surface data from different Notes applications. It turns out not to be much harder to surface data from different back end data sources with XPages.
The key to integrating different data technologies is by binding them together with Javascript. Almost any XPage control that surfaces data has the option to surface that data from a Javascript source. So any data repository you can get to from Javascript can be used by XPages.
Relational databases (RDB) are a very widely used technology for storing data. Many relational databases are accessible through Java Database Connectivity (JDBC). And this Java interface can be called from Javascript. This is our key to surfacing RDB data in an XPage. For our example here we will show connectivity to the MySQL relational database.
Here's a link to the article: http://www-10.lotus.com/ldd/ddwiki.nsf/dx/xpage_integration_rdb.htm
Great article and nice work guys!
John
Technorati: Domino 8.5 XPages
This page has been accessed 1022 times.
?OpenAgent&F7C41DBD0A8C07C08525756D007FBF75)
Comments :
No comments.
