in ur code print query, random example:
try (Connection con = ConnectionPool.getConnection();
PreparedStatement ps = con.prepareStatement(INSERT_MACRO))
{
ps.setInt(1, _owner.getObjectId());
ps.setInt(2, macro.id);
ps.setInt(3, macro.icon);
ps.setString(4, macro.name);
ps.setString(5, macro.descr);
ps.setString(6, macro.acronym);
ps.setString(7, sb.toString());
ps.execute();
System.out.println(ps); // print query to console.
}
copy it from console and then execute in navicat in ur MAIN database. idk how explain
if u not see anything in console then something wrong in ur java code.