This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal


Apr 16, 2013, 10:24 AM
4 Posts

newbie questions - how to connect to enterprise data?

  • Category: Domino Designer
  • Platform: Windows
  • Release: 9.0
  • Role: Developer
  • Tags: server,console,data connection,rdbms
  • Replies: 2

I just started experimenting with Designer 9 for pure web development and here comes few newbie qustions.

1- What I understand Domino has a build-in server. Is there a console included in the system to print Java agent output as System.out.println and exceptions? 

2- I tried to connect Domino to external rdbms Oracle by creating database connection DCR but it doesn't work. 

- Is it because I am using local as a server?

- Does it mean I need a Domino server to make it work?

- Is there a free Domino server with docment database for web development for exprementing to download?

- What are the best practices to integrate Domino with rdbms in xpages and views? Is creating data connection DCR right way to go? I followed this but I failed  http://publib.boulder.ibm.com/infocenter/domhelp/v8r0/index.jsp?topic=%2Fcom.ibm.designer.domino.main.doc%2FH_USING_A_DATA_CONNECTION_RESOURCE_STEPS.html

thank you for any clues. //Regards

Apr 19, 2013, 3:40 PM
5 Posts
RE: newbie questions - how to connect to enterprise data?

A DCR only works with the DECS server application. If you want to connect to RDBMS from a Notes client, NotesSQL, the ODBC driver,  will do that.

Unfortunately, IBM's documentation is a jumble due to their attempt to force WebSphere and Composite Applications on the Lotus users a few years back. They started doing that, and we saw Domino Designer get migrated to Eclipse, which caused more confusion.  Along with that, many opportunities. And this year, they removed the "Lotus" name from the product, but that change is also incomplete, and contributes to more confusion.  The newer development model is focused on OSGi plugins, bundles and XPages. The Domino Designer tooling/documentation has bits of the old and new models in it. But for RDBMS data, you will want to learn about JDBC connectors in Domino.

Start from these slideshows for the more recent approach

http://www-10.lotus.com/ldd/ddwiki.nsf/dx/Video__Using_the_Relational_Controls_in_the_Extension_Library

http://www.idonotes.com/IdoNotes/IdoConnect2013.nsf/dx/show104-buried-treasure-finding-the-hidden-gold-in-lotus-notes-data.htm

And yet another new model is that OpenNTF is hosting a lot of the Skunkworks development of new Domino Designer features, and their releases are not 100% in sync with IBM official releases. 

http://www.openntf.org/Internal/home.nsf/blogsAll.xsp

Apr 27, 2013, 10:11 AM
4 Posts
RE: newbie questions - how to connect to enterprise data?

Thank you for a great answer. 


This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal