Below is a simple example of java method which will return true if given database contains any table by name DB_VERSION. Else it returns false.
/*
* isRegistryDBConfigured() method returns true if provided Database
* contains table DB_VERSION. Returns false if it doesn't contain
* that table.
*/
public boolean isRegistryDBConfigured(String dbName, String portNumber,String userName, String password) {
try {
String hostName = InetAddress.getLocalHost().getCanonicalHostName();
Class.forName("com.ibm.db2.jcc.DB2Driver");
StringBuffer dbConnectionURL = new StringBuffer("jdbc:db2://");
dbConnectionURL.append(hostName + ":" + portNumber + "/" + dbName);
Connection db2Conn = DriverManager.getConnection(
dbConnectionURL.toString(), userName, password);
//Connection db2Conn = DriverManager.getConnection("jdbc:db2j:net://localhost:50000/frsdb","db2admin","db2admin");
// Connection db2Conn = DriverManager.getConnection("jdbc:db2://localhost:50000/test","db2admin","db2admin");
Statement st = db2Conn.createStatement();
String myQuery = "SELECT TABNAME FROM SYSCAT.TABLES WHERE TABNAME ='DB_VERSION'";
ResultSet resultSet = st.executeQuery(myQuery);
while (resultSet.next()) {
String name = resultSet.getString("TABNAME");
if (name.equals("DB_VERSION")) {
System.out.println("Tablename:" + name);
return true;
}
}
resultSet.close();
st.close();
db2Conn.close();
} catch (Exception e) {
System.out.println("EXCEPTION::" + e);
}
return false;
}
/*
* isRegistryDBConfigured() method returns true if provided Database
* contains table DB_VERSION. Returns false if it doesn't contain
* that table.
*/
public boolean isRegistryDBConfigured(String dbName, String portNumber,String userName, String password) {
try {
String hostName = InetAddress.getLocalHost().getCanonicalHostName();
Class.forName("com.ibm.db2.jcc.DB2Driver");
StringBuffer dbConnectionURL = new StringBuffer("jdbc:db2://");
dbConnectionURL.append(hostName + ":" + portNumber + "/" + dbName);
Connection db2Conn = DriverManager.getConnection(
dbConnectionURL.toString(), userName, password);
//Connection db2Conn = DriverManager.getConnection("jdbc:db2j:net://localhost:50000/frsdb","db2admin","db2admin");
// Connection db2Conn = DriverManager.getConnection("jdbc:db2://localhost:50000/test","db2admin","db2admin");
Statement st = db2Conn.createStatement();
String myQuery = "SELECT TABNAME FROM SYSCAT.TABLES WHERE TABNAME ='DB_VERSION'";
ResultSet resultSet = st.executeQuery(myQuery);
while (resultSet.next()) {
String name = resultSet.getString("TABNAME");
if (name.equals("DB_VERSION")) {
System.out.println("Tablename:" + name);
return true;
}
}
resultSet.close();
st.close();
db2Conn.close();
} catch (Exception e) {
System.out.println("EXCEPTION::" + e);
}
return false;
}
Reactions: |
0 comments to "DB2 10 JDBC Strings to use in JAVA code"
Tags
Powered by WidgetsForFree
My Blog List
Popular posts
- Airtel and vodafone GPRS settings for pocket PC phones
- Andhra 2 America
- Ayyappa Deeksha required things
- Blogs I watch !
- Captions for your bike
- DB2 FAQs
- Deepavali Vs The Goddes of sleep
- ETV - Dhee D2 D3
- Evolution of smoking in India Women
- How to make credit card payments?
- Java-J2EE interview preparation
- My SQL FAQs
- My Travelogues
- Old is blod - New is italic
- Online pay methids for credit cards
- Oracle FAQs
- Pilgrimages
- Smoking in Indian Women
- Technology Vs Humans
- Twitter feeds for all Telugu stars on single page.
- Unix FAQs
- Unix best practices
- init 0, init 1, init 2 ..
- mCheck Application jar or jad download

Post a Comment
Who ever writes Inappropriate/Vulgar comments to context, generally want to be anonymous …So I hope U r not the one like that?
For lazy logs u can at least use Name/URL option which don’t even require any sign-in, good thing is that it can accept your lovely nick name also and URL is not mandatory too.
Thanks for your patience
~Krishna(I love "Transparency")
వీలయితే నాల్గు పోస్టులు ...కుదురితే ఒక కామెంటూ ...