SELECT returning always one row

A pure Java JDBC driver for Microsoft Access database files

Brought to you by: jamadei

SELECT returning always one row

Forum: Help

Creator: Danilo Catoja

Created: 2016-09-13

Updated: 2016-09-13

Danilo Catoja - 2016-09-13

Hi,

I'm using UCanAccess in one of my projects to connect a MS Access database.

I'm trying to do a simple query SELECT * FROM DATAA03_1, this table have 33912 entries but it only returns one row and always the same row.

I'm using java 7 and Spring JdbcTemplate.

Any help ?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Gord Thompson - 2016-09-13

Have you tried opening the database in Access and doing a Compact and Repair Database operation on it to see if that helps?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marco Amadei - 2016-09-13

And if so it means you're using a old version, the current one can deal with this kind of corruption problem. Also I suggest to use the console to see what are the results with it.

Last edit: Marco Amadei 2016-09-13

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.