This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes Everytime getting an empty ResultSet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Everytime getting an empty ResultSet" Watch "Everytime getting an empty ResultSet" New topic
Author

Everytime getting an empty ResultSet

Souvik Das
Greenhorn

Joined: Oct 11, 2007
Posts: 15
Hi,
I want to access DB2 which is connected to AS400. So i am using com.ibm.as400.access.AS400JDBCDriver driver which i have got ftom jt400.jar. As i am using JDK 1.4, i have used jtopen 4.8 version for getting this jar.

My problem is: I have established a connection. But when my query run,it does returns a resultset which is empty but not null. It has all the metadatas but it does not have any value.Everytime rs.next() giving "false" value.

Please help me.

My Code is:
private Connection getP400Connection() throws Exception{
Connection conn= null;

try
{
P400Config = loadPropertyFile(P400PropertyFile);
String driverName = P400Config.getProperty("drivername"); // Getting driver from properties file
System.out.println("Driver Name : "+driverName);
Class.forName(driverName); // Loadding the Driver
//DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
// Create a connection to the database
String serverName = P400Config.getProperty("servername"); // Getting servername,portnumber
String portNumber = P400Config.getProperty("portname"); // sid,url from properties file
String sid = P400Config.getProperty("sid");
String url = P400Config.getProperty("url")+serverName+":"+portNumber +":"+sid;
System.out.println("URL :"+url);
conn = DriverManager.getConnection(url,P400Config.getProperty("username"),P400Config.getProperty("pwd"));// Creating the Connection Object
}
catch(Throwable th)
{
th.printStackTrace();

}
return conn;
}


private void getDataFromP400() throws Exception{
String query = null;
Statement stmt = null;
ResultSet rs = null;
try{
query = "select ZLOTNUM from itgdta.zlot where VALIDFLAG ='F'";
//query = "select * from itgdta.zpld,itgdta.zlot where itgdta.zpld.zplpfx = 'PL' and itgdta.zpld.zsbucode > 'a'";
Connection conn = getP400Connection();
stmt = conn.createStatement();
rs = stmt.executeQuery(query);
//System.out.println("Boolean value : "+stmt.execute(query));
if(rs != null){
System.out.println("Some data is Here");
ResultSetMetaData rsMeta = rs.getMetaData();
System.out.println("Total MetaData "+ rsMeta.getColumnCount());
for(int i=1;i<=rsMeta.getColumnCount();i++){
System.out.println("i = "+i+" Meta "+rsMeta.getColumnName(i) +" "+rsMeta.getColumnLabel(i));
}
System.out.println(" Why?? "+rs.next());
while(rs.next()){
strClientName = rs.getString("ZLOTNUM");
System.out.println("Client Name : "+strClientName);
}

}else{
System.out.println("Query Failed ........");
}

}catch(Exception e){
e.printStackTrace();
}finally{
rs.close();
stmt.close();
}
}
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41017
    
  43
Have you run the query directly against the DB? Does it return any data then?


Ping & DNS - my free Android networking tools app
Souvik Das
Greenhorn

Joined: Oct 11, 2007
Posts: 15
Originally posted by Ulf Dittmer:
Have you run the query directly against the DB? Does it return any data then?


Thanks for support. Actually user id what I was using was wrong.
Thanks
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Everytime getting an empty ResultSet
 
Similar Threads
Java to Display Data from Database
Databse Problem
Need help in Connecting my MySQL Database to JTable in Eclipse.
Null Pointer Exception
Problem in returning the username