CODEWITHSUNDEEP
javasqlucanaccess
Tomááš Šediivý
Tomááš Šediivý

Reputation: 23

Java UCanAccess doesn't detect all items

I have a problem. I use this query:

SELECT prodeje.datum, 
       prodeje.prodejce, 
       prodeje.pocet, 
       prodeje.cena, 
       produkty.autor_music, 
       produkty.autor_text, 
       produkty.skladba, 
       produkty.isrc, 
       produkty.cd, 
       produkty.ean 
FROM   prodeje 
       INNER JOIN produkty 
           ON prodeje.id_produktu = produkty.id

But it doesn't return all items. There should be 59 results but it skips (randomly) 9 results. When I tried the same query in Microsoft Access it worked...so I'm desperate.

I am using UCanAccess JDBC driver.

Upvotes: 2

Views: 1197

Answers (1)

jamadei
jamadei

Reputation: 1710

Finally, (maybe) ghost caught. This problem has already been reported (but unfortunatly nobody provided me the corrupted mdb): http://sourceforge.net/p/ucanaccess/discussion/help/thread/0b85dea2/ and it's unrelated to the SQL engine. This issue is at a lower level than UcanAccess (IO problem because of format errors in your mdb). It look like Ms Access can work fine despite those errors, while Jackcess (the library used by UCanAccess) doesn't. Your mdb version is 1997 (partially supported in read only by UCanAccess) and if you converted it in a later version, all would work fine with UCanAccess. Also, the use of the MS Access "Repair and Fix" tool, should fix the issue as well.

Upvotes: 1

Related Questions