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

How can I update a row with a Double value using B4A and Jackcess?

I am creating an MS Access database with B4A (was: basic4android) and Jackcess. Every time I try to save a Double value I get the error JavaLangNumberFormatException invalid double : "null". How can I update the Access field with a Double value…
redSparrow
  • 1
  • 6
0
votes
1 answer

How to convert string values to dates in Java?

I'm trying to convert some date values from access (MDB) database. I'm getting this: 'Tue May 17 08:29:00 BRT 2011'. But I want this: '2011-05-17 08:29:00'. I already tried to use JAVA 8 new DateTime classes but didn't work. Here is what I…
Leo Ribeiro
  • 1,195
  • 1
  • 14
  • 25
0
votes
1 answer

Changing datatype definition for Jackcess

I have a program built that takes my access DB and exports to a CSV. Everything works great but the program that takes in the exported CSV has some hardcoded regex and cannot handle the different format of certain datatypes. Date IS: Fri May 01…
sneakernetsec
  • 3
  • 1
0
votes
1 answer

Is there a way to force read from disk in UcanAccess?

I'm building a Java app that needs to co-exist with a VBasic one. Both consume a single Access database (.mdb) As sometimes the VB app writes the DB I'd need to programmatically re-read from disk the mdb. Is there a way to do this? is this Jackcess…
pepepapa82
  • 167
  • 2
  • 10
0
votes
2 answers

Delete specific rows from an Access table using Jackcess

I am using the Jackcess API with an Access database. I open the database and get a specific table. How can I get the data (rows) from this table which matches a list of ids? For example get all the rows from the table where id is in List. private…
Ragnar
  • 645
  • 8
  • 28
0
votes
2 answers

NoClassDefFoundError in jackcess

I am working on an RCP application which is based on eclipse plugins. In one of my plugin project I add another plugin project as dependency. Let say Project A has Project B as a dependency defined under its manifest. Project B contains…
Ragnar
  • 645
  • 8
  • 28
0
votes
1 answer

Java JTable Exported to Existing MS Access Table

I scoured the web and found nothing for this. I have a group of records in a JTable and I need to export these records to an existing table in an MS Access database. I need to be able to append records to this table as there may already be data…
Pete Hahn
  • 21
  • 6
0
votes
1 answer

create table with foreign key column, AutoNumber primary key column, and default values for dates

I need to create a table using Jackcess library which consists of foreign key reference column and primary key column with auto increment. Also, how can I specify default values for all the columns like Date/Timestamps? In the Jackcess cookbook, I…
Prince
  • 33
  • 1
  • 8
0
votes
1 answer

Jackcess compilation error

i have been searching around for a few days for the answer to this and i just can't seem to get it to work. I have seen exact examples where it is working for them and I try exactly what they do and it is just not working for me. Basically what i am…
Josh Jeffries
  • 3
  • 4
0
votes
1 answer

How disable check constraint on connection

java.sql.DriverManager.getConnection("jdbc:ucanaccess:///user/dev/project/project.mdb") I have this error Java::NetUcanaccessJdbc::UcanaccessSQLException: integrity constraint violation: NOT NULL check constraint; SYS_CT_10991 table: EMPLOYE column:…
Phane
  • 201
  • 3
  • 11
0
votes
1 answer

Accessing a Microsoft Access database from Ubuntu 14.04 server with Jackcess

I have installed Jackcess 2.0.4 API on my Ubuntu 14.04 server (IP: 192.168.0.130). And now i want to access a Microsoft Access 2010 DB on a Windows 2003 R2 server (IP: 192.168.0.125). How do i do this ?
Brian Bruun
  • 3
  • 1
0
votes
1 answer

Jackcess update rows from Map

Here is my question. I have one table like this alias id age ----- -- --- A0 1 23 A0 2 12 A0 3 32 B0 1 45 B0 2 80 B0 3 56 C0 1 __ C0 2 __ C0 3 __ and I want to extract with the help of a…
user3155736
  • 25
  • 5
0
votes
2 answers

how to get a Table object given its name (as String) in Jackcess

im starting with java and jackcess, I have this code public class DataManagement { static Database db; static Database dbopen; static Table Users; static Set tablename; static String[] nametabla; public static void opendatabase(){ try { …
user3155736
  • 25
  • 5
0
votes
1 answer

Jackcess Encrypt gives "key size is outside allowable range" when opening Database with password

I have an ms access database "abc.accdb" which has a password "abcdabcdef". Tried to open it with Jackcess Encrypt via this command: package com.sample; import java.io.File; import java.io.IOException; import…
Ashok Goli
  • 5,043
  • 8
  • 38
  • 68
0
votes
1 answer

Iterate over rows of DB Table: performance when iterating

I'm using JackCess library (http://sourceforge.net/p/jackcess/) to iterate over rows of a Access database under Java. The rows are many and the performance is not that great, currently I iterate over all rows of the table with this code: private…
dendini
  • 3,842
  • 9
  • 37
  • 74
1 2 3
…
8
9