companion.insertNewMessage.1=INSERT INTO COMPANION_OWNER.app_entry_group (group_franchise_id, group_episode_id, group_device_id) \
  VALUES (?, ?, ?)
companion.insertNewMessage.2=INSERT INTO COMPANION_OWNER.app_entry_value (value_group_id, value_item_id, value_string) \
  VALUES (COMPANION_OWNER.app_entry_group_id_seq.CURRVAL, ?, ?)
companion.insertNewMessage.3=INSERT INTO COMPANION_OWNER.app_entry_value (value_group_id, value_item_id, value_string) \
  VALUES (COMPANION_OWNER.app_entry_group_id_seq.CURRVAL, ?, ?)
companion.insertNewMessage.4=INSERT INTO COMPANION_OWNER.app_entry_value (value_group_id, value_item_id, value_number) \
  VALUES (COMPANION_OWNER.app_entry_group_id_seq.CURRVAL, ?, 0)
companion.insertNewMessage.5=INSERT INTO COMPANION_OWNER.app_entry_value (value_group_id, value_item_id, value_string) \
  VALUES (COMPANION_OWNER.app_entry_group_id_seq.CURRVAL, ?, ?)



                	ps = con.prepareStatement(jcp.getStatement("insertNewMessage.1"));
                	ps.setString(1, gm.getStringProperty("fran_id").replace("\"",""));
                        ps.setString(2, gm.getStringProperty("ep_id").replace("\"",""));
                        ps.setString(3, gm.getStringProperty("device_id").replace("\"",""));
                        ps.executeUpdate();
                        ps = con.prepareStatement(jcp.getStatement("insertNewMessage.2"));
                		ps.setInt(1, 103);
                        ps.setString(2,  gm.getStringProperty("post").replace("\"",""));
                        ps.executeUpdate();
                        ps = con.prepareStatement(jcp.getStatement("insertNewMessage.3"));
                        ps.setInt(1, 104);
                        ps.setString(2, gm.getStringProperty("user_id").replace("\"",""));
                        ps.executeUpdate();
                        ps = con.prepareStatement(jcp.getStatement("insertNewMessage.4"));
                        ps.setInt(1, 118);
                        ps.executeUpdate();
                        ps = con.prepareStatement(jcp.getStatement("insertNewMessage.5"));
                        ps.setInt(1, 124);
                        ps.setString(2, gm.getStringProperty("display_name").replace("\"",""));
                        ps.executeUpdate();