|
> 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. ******************************************************************
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.