Re: Empty resultset

Best regards,

Vengoal



Mertens, Michiel ??:

Hello,

I'm trying to get data out of an existing database. The database is
created with SDA/ SUE. After the connection is and the query is
excecuted, the resultset stays empty. When I try the same with a

database I created with SQL it does return the values I requested. The questions I have are: * Is there a difference if a database is created with SUE/ SDA or

with SQL.
*       And why does the resultset stay empty.

The code I used is the following:

package javaBenchmark;
import java.sql.*;
import java.util.Properties;

public class DatabaseQuery
{
        private Connection connection = null;
        
        public static void main(String[] args)
        {
                long startConnectieTijd = System.currentTimeMillis();
                
                DatabaseQuery db = new DatabaseQuery();
                
                long startTijd = System.currentTimeMillis();
                
                db.runQuery();
                                
                long stopTijd = System.currentTimeMillis();
                                                
                System.out.println("Querytijd:  " + (stopTijd -
startTijd));
                System.out.println("Totaaltijd: " + (stopTijd -
startConnectieTijd));
                
                db.cleanup();
        }
        

public DatabaseQuery() {

                        
                        Properties properties = new Properties ();
                        properties.put("user", "...");
                        properties.put("password", "...");

                        

try {

        
Class.forName("com.ibm.db2.jdbc.app.DB2Driver");
                                connection =
DriverManager.getConnection("jdbc:db2:*local", properties);

                        } catch (Exception e) {                         
                                System.out.println("Caught exception: "
+ e.getMessage());
                        }
                }
                

public void runQuery() { try {

                                Statement s =
connection.createStatement();
                                // ResultSet rs = s.executeQuery("select
* from aaa.basicjdbc");
                                ResultSet rs = s.executeQuery("select *
from aaa.Yrtpf");
        
System.out.println("--------------------");
                                int i = 0;
                                while (rs.next()) {
                                        System.out.println("| " +
rs.getInt(1) + "|" + rs.getString(2) + "|" );
                                        i++;
                                }
        
System.out.println("--------------------");
                                System.out.println("There were " + i + "
rows returned.");
                                System.out.println("Output is
complete.");

} catch (SQLException e) {

                                System.out.println("SQLException
exception: ");
                                System.out.println("Message:....." +
e.getMessage());
                                System.out.println("SQLState:...." +
e.getSQLState());
                                System.out.println("Vendor Code:." +
e.getErrorCode());
                                e.printStackTrace();
                        }
                
                }
                

public void cleanup() { try {

                        if (connection != null) connection.close();

} catch (Exception e) {

                           System.out.println("Caught exception: ");
                           e.printStackTrace();
                   }
         }
}

I reckon the problem lies in the method runQuery. But I can't figure
out what it is.
ResultSet rs = s.executeQuery("select * from aaa.basicjdbc");
This statement returns the values I requested. It collects the data
from the database created with SQL.

ResultSet rs = s.executeQuery("select * from aaa.Yrtpf");
This statement returns no values. It collects the data from the
existing database created with SUE/ SDA.

Thanks,
Michiel

******************************************************************
Deze e-mail is gecontroleerd op virussen.
Aan de inhoud van dit bericht kunnen geen rechten ontleend worden.
******************************************************************