Search:

System.out.println(rs); is getting back null but by my opinion it should get back that id or am I wrong?

god am so dumb. Problem was in line PreparedStatement query =...

Connection connection = null;
try {
connection = DriverManager.getConnection("jdbc:derby://localhost:1527/database","root","root");
connection.setAutoCommit(false);...