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
5
votes
1 answer

UCanAccess/Jackcess exception when calling executeUpdate disables my Logger output

I am using UCanAccess for manipulating an Access database. When calling executeUpdate I get the exception: net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::3.0.2 Unexpected page type 1 (Db=db.accdb;Table=MyTable;Index=PrimaryKey) It only…
EH Sports
  • 63
  • 6
5
votes
3 answers

java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Boolean, using Table.addRow() with Jackcess

I am trying to write some values in a MS Access database using Jackcess. My values are originally represented using String. The code I am using is the following: int nColumns = 0; // get table from internal representation ModelDatabaseTable table =…
gc5
  • 9,468
  • 24
  • 90
  • 151
4
votes
1 answer

How to remove ^M characters from a text file independent of platform using Java?

I am trying to figureout how to delete ^M characters from a text file that is generated from Java code with following code. public StringBuilder toCsv(Table table) { StringBuilder stringBuilder = new StringBuilder(); String csv =…
amjad
  • 2,876
  • 7
  • 26
  • 43
4
votes
1 answer

Updating Rows in Java using Jackcess

I am trying to update rows with a particular value using Jackcess in Java. I am using the below code and there is no changes done to the rows. What I am missing here? I am feeling lost as there is no documentation for these methods. Database db =…
Purus
  • 5,701
  • 9
  • 50
  • 89
4
votes
1 answer

How to retrieve data from a Query instead of from Tables with Jackcess

I have an Access DB, to make the job easier, I did the queries into DB. How I can take data from the query instead of from tables? To take data from tables I used this code: Table table = db.getTable("matchTable"); Cursor cursor =…
Shiroga
  • 145
  • 2
  • 8
  • 20
4
votes
1 answer

Jackcess equivalents for simple SQL SELECT statements

Can someone please explain how I might use Jackcess to implement the equivalent of the following SQL queries? SELECT name FROM table WHERE id = '1' SELECT name FROM table INNER JOIN table ON table.id = table2.id
Shiroga
  • 145
  • 2
  • 8
  • 20
4
votes
2 answers

Jackcess "NoClassDefFoundError" exception

I am using jackcess for the conncetivity to my access database. But I am following exception Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/commons/lang/builder/CompareToBuilder at…
Sarah
  • 370
  • 1
  • 7
  • 25
4
votes
2 answers

Java Jackcess Library Documentation?

I need to read and write some data on .mdb Access file and over the web I found the Jackcess library that that does exactly that. Unfortunately I could't find any documentation to use that. On the library website there are a couple of examples, but…
Luca
  • 1,704
  • 3
  • 29
  • 42
3
votes
2 answers

How do a I resolve a java jackcess dependence error?

I'm tring to dispaly data from an MS Access db, I'm useing Jackcess library but I get a dependence error that I do not how to resolve. Here is my code and error: import com.healthmarketscience.jackcess.*; import java.io.*; import java.util.*; import…
haltman
  • 553
  • 1
  • 12
  • 24
3
votes
1 answer

List all tables in an mdb file

Is there any way to list the names of all of the tables in an MDB file? I am attempting to create a program that tests the user on Quizbowl questions. I would like to organize the questions and answers so that each question set is located within its…
Constantino Flouras
  • 39
  • 4
3
votes
1 answer

Reading from an encrypted Access .mdb using Java / Jackcess

I need to read Data from an encrypted Access 97 Database and tried out Jackcess and UCanAccess. I'm using jackcess-2.1.2.jar, jackcess-encrypt-2.1.0 and bcprov-jdk15on-152.jar from bouncycastle.org As UCanAccess uses Jackcess internally I'm getting…
A. Rohmann
  • 91
  • 2
  • 9
3
votes
2 answers

Convert byte[] with binary data to String

I have data in binary format (hex: 80 3b c8 87 0a 89) and I need to convert that into String in order to save binary data in MS Access db via Jackcess. I know, that I'm not suppose to use String in Java for binary data, however Access db is third…
Dzidas
  • 305
  • 4
  • 13
3
votes
1 answer

"unsupported collating sort order" when trying to read from Access using Jackcess (Java)

I'm currently working on a Java application with the purpuose of reading a Microsoft Access file using Jackcess open source library. The Java application will later present the tables contained in the Access file. Here is my code so far: public…
Marcus
  • 6,697
  • 11
  • 46
  • 89
3
votes
1 answer

How can I create an ODBC linked table in an Access .mdb using Jackcess?

I'm trying to create ODBC linked table in an Access .mdb using Jackcess. Final String connStr = "ODBC;DRIVER={Sybase ASE ODBC Driver};NA=dbhostname,port;DB=myDbName;UID=myID;PWD=myPass;FILEDSN=path//myDSN.dsn"; Database mdb =Database.create(new…
user1731576
  • 31
  • 2
2
votes
2 answers

Export accessdb tables to csv

Been working on a snippet of java code to export a few tables from an accessdb to CSVs. I want to deploy this code as a Lambda function. I've tried using Jackcess, but the following try { String dateOfExtraction =…
Ravmcgav
  • 183
  • 1
  • 1
  • 11
1
2 3
…
8 9