Hi,

I have a mysql database running, containing a database "test" (yes every mysql
installation comes with a test ...), and a table named "todo". I can do things
like "show fields from todo" or "show tables". The table has 10 fields, they are
named issue_nr, issue, who, topic, date, ...and so on. When I do a "select * from todo" at the mysql level, I get all the fields on the
screen. However, if I do the same as a java statement, I see only 1 item,
instead of all. I tried to go further by using a statement like "select who, topic, date", but
same behaviour...

The example is basically the one derived from the tutorial... no additional
stuff ... (here the code, without try / catch statements):

String url = "jdbc:mysql://localhost/test"; // String query = "SHOW FIELDS from todo"; String query = "SELECT ISSUE, WHO, TOPIC from todo";

Class.forName("org.gjt.mm.mysql.Driver").newInstance(); Connection Conn = DriverManager.getConnection(url);

Statement Stmt = Conn.createStatement(); ResultSet RS = Stmt.executeQuery(query); while (RS.next()) { System.out.println(RS.getString(1));

} RS.close();

I am using jdk1.1.3 and mm.mysql.jdbc-1.2... (though the readme files says s.th.
like 1.1 - how can I say, what I am running ?)

did I miss s.th. ?

thanx