2021-01-21 23:37:13 TRACE org.magic.api.dao.impl.HsqlDAO2 594 - sql=select * from stocks where collection=? and mcard like '{"name":"Waveskimmer Aven"%'
2021-01-21 23:37:13 ERROR org.magic.gui.components.DeckStockComparatorPanel 184 - Error SQL
java.sql.SQLException: Invalid argument in JDBC call: parameter index out of range: 2
@Override
public String createListStockSQL(MagicCard mc) {
return "select * from stocks where collection=? and mcard like '{\"name\":\""+mc.getName().replace("'", "\\'")+"\"%'";
}
DAO : Hsql2
2021-01-21 23:37:13 TRACE org.magic.api.dao.impl.HsqlDAO2 594 - sql=select * from stocks where collection=? and mcard like '{"name":"Waveskimmer Aven"%' 2021-01-21 23:37:13 ERROR org.magic.gui.components.DeckStockComparatorPanel 184 - Error SQL java.sql.SQLException: Invalid argument in JDBC call: parameter index out of range: 2
@Override public String createListStockSQL(MagicCard mc) { return "select * from stocks where collection=? and mcard like '{\"name\":\""+mc.getName().replace("'", "\\'")+"\"%'"; }