Getting 5 instead of 4 Results back (eg) (MySQL)

[Thomas Beiganz]

Hello all,

I hope this is the right place for my question.

I use a MySQL Database 5.5.22 for a WebApp.

try {
			Class.forName("com.mysql.jdbc.Driver");
			connect = DriverManager.getConnection("jdbc:mysql://mysqlhost/Table", "login", "oachkatzl");

			PreparedStatement preparedStatement2 = connect.prepareStatement(SQL_GET_SUB_MENU +  resultSet.getString("table") + ";");

			ResultSet rs = preparedStatement2.executeQuery();		

			while (rs.next()) {
				System.out.println(rs.getString("data"));
			}
			
			return result;

		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}

That is my Query and this is my Query String

"SELECT `T_TABLE`.`id`, `T_TABLE`.`data`, `T_TABLE`.`table` FROM `Table`.`T_TABLE`";

And the statement works, but I do get a weird output
Item1
Item2
Item3
Item4
[] <---- This is what i meant.

And I don't know from where it comes.



This is the output from MySQL Workbench.

Thanks in advance for you help.

[Wendy Gibbons]

is id a mandatory column on your database? as it looks like row5 actually exists in the database.

If it isn't add mandatory/ not null to id and see if it will let you.

[Martin Vajsar]

I would assume the fifth row displayed in MySQL Workbench is simply a placeholder where you can enter values that will become a new row, after you're done editing them.

[Wendy Gibbons]

Martin Vajsar wrote:I would assume the fifth row displayed in MySQL Workbench is simply a placeholder where you can enter values that will become a new row, after you're done editing them.

I would also assume that, but his result set loop looks correct to me, so just double checking really.