Questions tagged as 'resultset'

Tagged questions
1
answer

The name of the dt_ultimo_acesso column was not found in this ResultSet

I'm deploying a method by passing an id parameter: @RequestMapping(method = RequestMethod.GET, value = "/entidadesUsuario/{id}", produces = MediaType.APPLICATION_JSON_VALUE) public ResponseEntity<Collection<Usuarios>> buscarEnt...
asked by 20.10.2017 / 17:27
3
answers

How to fill a value object automatically in php?

I need a method that autocompletes my VO by getting a result set from the mysql database and the PDO class from php as a parameter. Example VO class Pessoa{ public $nome; public $idade; } The idea is to incorporate this fill...
asked by 09.05.2014 / 21:05
2
answers

Why is this ResultSet returning null?

If I run a query in the database returns result, however, when I run the code in java, assigning the result to a ResultSet, it appears to be empty. Can you help me? PreparedStatement ps = conectar.con.prepareStatement("select colaborador.codig...
asked by 12.07.2015 / 19:17
1
answer

Error "The resultSet is closed" with PreparedStatement

I'm getting this when I'm traversing a ResultSet and get other ResultSet s: public class BpaDetDao extends DaoAbstract<BpaDetBean> { public static final String // TODO Colocar campos no select SQL_SELECT =...
asked by 29.06.2015 / 22:20
1
answer

Check if the field is null in java and mysql

How do I check if a database field is populated or is null? Do you have a ResultSet method that does this? In case it is a date field. PreparedStatement ps = connection.prepareStatement("SELECT * FROM tarefas"); ResultSet result = p...
asked by 22.09.2017 / 00:40
3
answers

Discovering SQL from a ResultSet

I have a java ResultSet object that does not know the SQL / Parameters that generated it. I would like to know how do I get the SQL used to create it? would have something like: rs.getStm.getSql ?     
asked by 21.07.2015 / 22:11
1
answer

How to convert from Timestamp to Calendar?

I need to convert a resultSet of the database that returns Timestamp to a variable of type Calendar.     
asked by 04.06.2015 / 22:34
0
answers

Show resultset results in same tab (JSF)

Hello, I have the following situation: I have a button (search) that executes a search method and returns the data in the same already open tab in a <p:dataTable . After generating a report in JasperReports (pdf button), which...
asked by 07.10.2016 / 06:14
2
answers

How to format the output of resultSet via System.out.println in Java?

Hello, I am printing on the screen the result of a SELECT that I have stored in an object type resultSet (sql.ResultSet). But it comes out "all crooked". I tried to use the "\ t" between each printed column, but it did not help. Here is the part...
asked by 30.01.2018 / 19:56
1
answer

ResultSet first does not work

I'm creating a Java application in Eclipse. I'm having trouble making the First, Previous, Next, and Last buttons work. I'm stuck on the First button because, I believe, the difference is just the .first() , .next() , .previ...
asked by 23.09.2016 / 15:24