Stack Overflow
Stack Overflow

Questions tagged [jackcess]

Jackcess is a pure Java library for reading from and writing to MS Access databases

Jackcess is a Java library providing read/write support for Access database versions 2000 through 2010(+), and read-only support for Access 97 files.

It provides interfaces to open an existing database, iterate over contained tables and read information from the rows in the table. It also allows to create new tables and populate data in them.

Additionally it has functionality to import data from and sources. Separately available extensions allow to read encrypted files.

130 questions
2
votes
1 answer

How to import Jackcess and its dependencies into Eclipse?

I am trying to install Jackcess because I am developing a web app that is going to store information in an Access database. I've tried downloading multiple .jar files that all appear to be the ones i need (apache-commons-lang and…
Gpsy
  • 100
  • 11
2
votes
1 answer

Java SELECT @@Identity in Jackcess

I try use Jackcess to get id of the last added row. In java or vba i can use SELECT @@Identity. In Jackess java print mi this information: Column c = table.getPrimaryKeyIndex().getColumns().get(0).getColumn(); System.out.println(c); I get this…
Light
  • 175
  • 1
  • 2
  • 11
2
votes
3 answers

UCanAccess seems unable to read OLE Object column using getBytes()

I have a quite large .mdb access database I want to convert to SQLite3 to use it under Linux. I am unable to transfer any of the BLOBs (mostly containing images) I have. Here is a sample test program: import java.io.FileNotFoundException; import…
ZioByte
  • 2,690
  • 1
  • 32
  • 68
2
votes
1 answer

Column data substring matching with Jackcess

In my Access db table, I have a cmt_data column which contains a string. For example: Check in the packet TM(12,9) MRSS0319 'Monitoring List Report'. I also have a List with items such as MRSS0319, TRPP3006, etc. What I'm looking to do is…
Sameen
  • 729
  • 6
  • 19
2
votes
1 answer

NonWritableChannelException when trying to update an Access database

Using UCanAccess for the first time for a project and I am having a lot of trouble inserting a row into one of my database tables (in Microsoft Access). My code makes sense but once I execute I end up getting the same error every time, even though…
Jeremy Crouch
  • 67
  • 1
  • 6
2
votes
1 answer

"specified network name is no longer available" when working with Jackcess

I am trying to write a simple Java program to extract the tables and columns from Access databases. Using the Jackcess cookbook I've got the following: String sourceDatabase = "C:\\temp\\test1.mdb"; Database accessDB =…
Ralph
  • 279
  • 5
  • 18
2
votes
1 answer

Open ucanaccess/jackcess database in wildfly using iso-8859-1

I have a connection to an MS Access 2000 database defined in wildfly 9.0.2. Works fine. Using the commandline UCanAccess, I run it with -Dfile.encoding=ISO-8859 in order to have national characters (Norwegian) displayed correctly, on Ubuntu. On OS X…
jon martin solaas
  • 459
  • 1
  • 4
  • 14
2
votes
1 answer

Using Jackcess with JCIFS to manipulate an Access database on an SMB share

I need to work with an MS Access file in Java using Jackcess. The file is located on an SMB share so I assume I would have to use JCIFS. I tried this String testdirectory = "smb://" + "file location"; SmbFile testsmbdir = null; try{ …
Brandan B
  • 464
  • 2
  • 6
  • 21
2
votes
1 answer

Exceptions being thrown when trying to use Jackcess and JDBC

After taking the advise from the helpful users here I have made some changes to my code. What am I missing to get this driver to load? I was advised to get Jackcess, and I have included it in my library. and I am using java 8 I am not getting past…
CAPTiNDANCE
  • 87
  • 1
  • 8
2
votes
1 answer

Jackcess decoding not supported warning

I'm using Jackcess to help with database connectivity. I have no issues with my program when it's run on my computer and connecting to a database that runs in Access 2013. I've switched it to another computer now which is using Access 2010 and it's…
AndyReifman
  • 1,459
  • 4
  • 18
  • 34
2
votes
1 answer

Will Jackcess work with MS Access 2013?

I am writing a Java application that creates some data for the user and needs to generate an Access file that the user can then download and open with MS Access. The user has MS Access 2013. The only Java library I found online is Jackcess. …
elanamig
  • 359
  • 3
  • 6
  • 14
2
votes
1 answer

Jackcess equivalent of SQL WHERE clause with > ("strictly greater than") condition

I want search all rows where value of Date columns > '2014/03/01'. How can do this? If there are no rows with Date value = '2014/03/01'`, how can I position the cursor without a full scan table? Table table = db.getTable("Facture"); IndexCursor…
Phane
  • 201
  • 3
  • 11
2
votes
1 answer

Java Jackcess Find Row by More than one column

I'm acessing a MS Access database on Java using the Jackcess Library and I'd like to know how to find a table row by more than one column value. So far I followed this procedure every time I need to find a row by one column value: Row row =…
João Trindade
  • 61
  • 7
2
votes
1 answer

Looping a result set for a condition in Java using Jackcess

Using Jackcess 2.0.4 I am trying to query the table and get all rows matching a particular condition. Map testData = new Hashtable(); Database db = DatabaseBuilder.open(new File("DB.mdb")); Table table =…
Purus
  • 5,701
  • 9
  • 50
  • 89
2
votes
1 answer

Issue with Jackcess ExportFilter

I found a great library called Jackcess, allows you to convert, parse create, etc with Microsoft Access. The aim is to convert, which this code does successfully. There is a Filter functionality upon export, this can be seen on the link to the…
RST
  • 592
  • 1
  • 10
  • 27
1
2
3
…
8 9