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;
}
0 comments to "DB2 10 JDBC Strings to use in JAVA code"
Popular Posts
-
The best solution to know about these init levels is to understand the " man init " command output on Unix. There are basically 8...
-
How to Unlock BSNL 3G data card to use it with Airtel and Vodafone Model no : LW272 ? How to unlock BSNL 3G data card( Model no : LW272 )us...
-
How to transfer bike registration from one State to other (Karnataka to Andhra)?? Most of us having two wheelers purchased and registered in...
-
ఓం శ్రీ స్వామియే శరణం ఆయ్యప్ప!! Related posts : Trip to Sabarimala - Part 1 Trip to Sabarimala - Part 2 Ayappa Deeksha required things...
-
Following are some of interesting blogs I found till now ...please comment to add your blog here. Blogs in English : http://nitawriter.word...
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?
- init 0, init 1, init 2 ..
- Java-J2EE interview preparation
- mCheck Application jar or jad download
- 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 best practices
- Unix FAQs
Post a Comment
Whoever 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 doesn’t even require any sign-in, The good thing is that it can accept your lovely nick name also and the URL is not mandatory too.
Thanks for your patience
~Krishna(I love "Transparency")