Establish a connection to DOMINODB (DB2)

See below two Java class files, identical to previous work submitted for SQLite Database, nothing fancy. Copy and paste to your environement, areas of interest have been highlighted for your convenience.

DB2Connector;

package com.dokoll.solutions.inc.Utils;

/**

* Copyright 2012 Dököll Solutions, Inc.

Licensed under the Apache License, Version 2.0 (the "License");

you may not use this file except in compliance with the License.

You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software

distributed under the License is distributed on an "AS IS" BASIS,

WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

See the License for the specific language governing permissions and

limitations under the License.

*

* @AppName: Docu.nsf

* Program: DB2Connector.java

* Created from Copy: 2012.10.31.12.12.AM

*/

/**

*

* @author Dököll Solutions, Inc.

* @version 2012.10.31.12.12.AM

*/

import java.sql.*;

//load program

public class DB2Connector {

//get a connection

public static Connection getConnection() {

System.out.println("DB2Connector Connection Started...");

//declare and initialize

Connection connection = null;

//entering try catch

try {

//load driver class

Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance();

System.out.println("DB2Connector Class obtained...");

//connect to DB2 DOMINODB database

connection = DriverManager.getConnection("jdbc:db2://localhost:50000/DOMINODB","db2admin","yourpassport");

//...

System.out.println("DB2Connector Connection fowarded...");

} catch (Exception e) {

e.printStackTrace();

}

//...

return connection;

}

// public static void main(String[] args) throws Exception {

// //Use this block to test as Java program

// getConnection();

// System.out.println("DB2Connector Program Successful...");

// }

//

}

Submit and retrieve DB2 Data from DOMINODB

You have a connector class and it looks like it will work, Now what? Well, submit static data to DOMINODB and retrieve @ once. Copy and paste to your environement, areas of interest have been highlighted for your convenience.

DB2AddDataBean;

/**

* Created: 2012.10.28.1.40.PM

* DB2AddDataBean

* DB2 Data Loading Bean

*/

package com.dokoll.solutions.inc.db2.test;

/**

* @author Dököll Solutions, Inc.

* @version 2012.10.28.1.40.PM

*

*/

import java.sql.*;

import com.dokoll.solutions.inc.Utils.DB2Connector;

public class DB2AddDataBean {

public DB2AddDataBean(){

//...

}

//button code...

public void doGetDB2Data() throws Exception {

System.out.println("Entering actual connection...");

Connection connection = DB2Connector.getConnection();

System.out.println("Begin statement...");

Statement stat = connection.createStatement();

System.out.println("Entering query...");

PreparedStatement prep = connection.prepareStatement("insert into DB2ADMIN.USER_DETAILS values (?,?,?, ?, ?, ?, ?, ?, ?, ?, ?)");

// //Added Data for report

// //2012.10.28.9.03.PM

prep.setString(1, "XYZ002FBC");

prep.setString(2, "username16");

prep.setString(3, "XYZ002FBCCHI");

prep.setString(4, "Chcago");

prep.setString(5, "XYZ002FBCNAME13");

prep.setString(6, "10/01/2011");

prep.setString(7, "20");

prep.setString(8, "HamBerg, Inc.");

prep.setString(9, "88885555199");

prep.setString(10, "2011.10.11.11.10.AM");

prep.setString(11, "Windy City");

prep.addBatch();

prep.setString(1, "XYZ002FBC");

prep.setString(2, "username15");

prep.setString(3, "XYZ002FBCCHI");

prep.setString(4, "Chicago");

prep.setString(5, "XYZ002FBCNAME14");

prep.setString(6, "01/01/2012");

prep.setString(7, "49");

prep.setString(8, "GreenRoofTops, Inc.");

prep.setString(9, "77778888111");

prep.setString(10, "2011.10.19.1.10.AM");

prep.setString(11, "Windy City");

prep.addBatch();

System.out.println("Values added...");

connection.setAutoCommit(false);

prep.executeBatch();

connection.setAutoCommit(true);

ResultSet rs = stat.executeQuery("select * from DB2ADMIN.USER_DETAILS");

System.out.println("Submitting to console...");

while (rs.next()) {

System.out.println("ID |"+"AllegationCode|"+"Office |"+"Investigator|"+"DateOpen |"+"Age |"+"AllegationNumber|"+"Licensee |"+"Subject |"+"Region |");

System.out.println(rs.getString("ID")+" |"+rs.getString("AllegationCode")+" |"+rs.getString("Office")+" |"+ rs.getString("Investigator")+" |"+ rs.getString("DateOpen")+" |"+ rs.getString("Age")+ " |"+ rs.getString("AllegationNumber")+ " |"+ rs.getString("Licensee")+" |" +rs.getString("Subject")+ " |"+ rs.getString("Region"));

}

rs.close();

connection.close();

}

}

Submit and retrieve DB2 Data with Xpages

You have a connector class and a JavaBean rigged to submit and retrieve data from DB2 database (DOMINODB), but you need to run code and perform tasks... Plug your JavaBean's method into the following Xpages form button, and check log.nsf database for the results; see previous screenshots to get an idea how this might look. Copy and paste to your environement, areas of interest have been highlighted for your convenience.

xprundb2.xsp;

<?xml version="1.0" encoding="UTF-8"?>

<xp:view xmlns:xp="http://www.ibm.com/xsp/core">

<html>

<head>

<title>DB2 Example</title>

</head>

<body>

<xp:form>

<table>

<tr>

<td style="font-weight:bold">Add/Retrieve DB2 Data</td>

<td>

<xp:button value="Submit"

id="button1">

<xp:eventHandler event="onclick"

submit="true" refreshMode="complete" immediate="false"

save="true" id="eventHandler1">

<xp:this.action><![CDATA[#{javascript:DB2AddDataBean.doGetDB2Data()}]]></xp:this.action>

</xp:eventHandler>

</xp:button>

</td>

</tr>

</table>

</xp:form>

</body>

</html>

</xp:view>

Conclusion:

You can now use an Xpages form button to connect to DB2 database to add and retrieve data. Build on this one to retrieve records into a dataTable, perhaps submit values as documents in Lotus Notes, search back-end via Xpages.

Questions, comments, please post a brief message on our Contact form on the main site.

Thank you for coming...