I'm having this difficulty retrieving data from a table. The recovery code I'm doing on my own because I do not find any examples to try to follow, but I've been breaking my head for a long time and I can not seem to get out of the way. Does anyone know what might be causing this error?
public List<ModeloObjeto> buscarFuncionalidades(ModeloObjeto modelo){
try {
List<ModeloObjeto> funcionalidades = new ArrayList<>();
Connection conexao = CriaConexao.getConexao();
PreparedStatement ps;
ps = conexao.prepareCall("SELECT nome_func FROM funcionalidade_celular WHERE nome_cel = ?");
ps.setString(1, modelo.getModelo());
ResultSet rs = ps.executeQuery();
while(rs.next()){
ModeloObjeto fun = new ModeloObjeto();
fun.setFuncionalidades((List<String>) rs.getArray("nome_func"));
funcionalidades.add(fun);
}
return funcionalidades;
} catch (SQLException ex) {
Logger.getLogger(ModeloDAO.class.getName()).log(Level.SEVERE, null, ex);
return null;
}
In the class that creates the Cell Object, features are set to List<String>
because it receives various data from a checkbox. Since it is not possible to store a list in MySQL, I store it in another table that gets the name of the functionality and the name of the template, and that's what I'm trying to recover, but it's not working.
I need these values to return in a DataTable the functionality of the Cell Object, all other attributes are working properly, minus the Features.