Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

UCanaccess Jackcess Calculated Fields Microsoft Access

 
Robert Panivino
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm stuck and I'm posting this question everywhere in case someone with some experience knows anything. I need a pure java jdbc library for Microsoft Access and don't ask why. I chose Ucanaccess with jackcess. Everything was pink and beautiful until I got to calculated fields. The question is summarized below:


For simplicity, we'll assume we have a simple table with two columns: id, and idx2 which returns [id]*2. I want to either query the row (1,2) or anything related to the function (such as (1, [id*2])). I don't care how dirty the solution is.

Those who have used either of these two libraries should know what a simple select returns. How did you fix it?
 
Robert Panivino
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Someone else was faster, I'll quote the answer here.


As you are probably aware, UCanAccess uses Jackcess to read/write the Access database so it is really a question of whether Jackcess can read a Calculated field. Unfortunately, it cannot (or at least it couldn't do so the last time I checked, which was sometime in the last few months).

On Windows you would have the option of using the JDBC-ODBC Bridge (with all its warts) under Java 7. However, I'm not aware of any other options for Java under Linux.

You may want to visit the Jackcess site on SourceForge and ask about this issue in the discussion forums, or possibly submit a feature request.


So, if by googling you end up here, ucanaccess-2.0.6.2.jar and jackcess-2.0.4.jar do NOT support this feature.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic