How do I access SQL from XPages

Question

What is the process to access data from a SQL data source and have it fill in a list box control so that the user may select one of the values?

I have been given the name of the database and server, the login ID and password.

Code samples would really be appreciated as I have never done any SQL coding.

Answer 1

The latest Extension Library on OpenNTF ( extlib.openntf.org ) has a whole bunch of Relational Database extensions.

You'll need to get the JDBC drivers for whatever SQL server your going to be accessing and then take a look at the ExtLib demo application on how to create the JDBC connector from your application. Once the connector is in place you can then just the new controls in ExtLib to easily create a view pane etc.

You will also need more then the SQL server, username and password, you'll need to find out the different tables that you'll be accessing so that you can reference them from your Xpages application.

Answer 2

I've created a video showing JDBC access from XPages: http://www.youtube.com/watch?v=p6oRCsTsVqc