Stack Overflow
Stack Overflow

Questions tagged [ucanaccess]

UCanAccess is a pure Java JDBC driver that allows us to read from and write to Microsoft Access databases without using ODBC.

UCanAccess is a pure Java JDBC driver that allows us to read from and write to Microsoft Access databases without using ODBC. It provides a cross-platform alternative to using the JDBC-ODBC Bridge (which has been removed from Java SE 8 and is not supported).

470 questions
3
votes
2 answers

How to call method from a database connection class

Recently I am making a small system in which I've 3 packages using Ms Access as database 1)Classes----> Based on OOP concepts 2)GUI------> The Jform + .java files 3)Images---->Just some icons i made I've made a DBConnection class in the Classes…
Zujaj Misbah Khan
  • 655
  • 2
  • 11
  • 31
3
votes
2 answers

SQL query returns no result from Java although it returns a result in Access

When I run this query: select character from tbl_Unknown where format(fw,'.###')='48.143' and code='0001' it returns a result in the Access query interface but when I try to run it from Java it doesn't return a result. My table…
Ayman
  • 81
  • 2
  • 10
3
votes
2 answers

Tables created via DDL in UCanAccess cannot be opened in Access itself

I have been able to successfully create MS Access database tables from Java using the UCanAccess 2.0.6 driver. However, I am subsequently unable to open up the tables from MS Access (Microsoft Office 2007, Windows 7 64-bit), with MS Access throwing…
user3670023
  • 61
  • 1
  • 3
3
votes
2 answers

Conflict between Netbeans IDE 8.0 and UCanAccess?

I have to define a new Driver in the Netbeans "Services" Tab Services->Databases->Drivers->new Driver... because I want use the "Entity Classes from Database"-Wizard in context with UCanAccess. 1st step: "new Driver" does work (only declaration ;-)…
Martin Kehrholff
  • 83
  • 1
  • 6
3
votes
2 answers

How to configure UCanAccess JDBC driver with Spring?

Whenever I tried to use an ODBC driver to access MDB files, it gave me an error: error : "[Microsoft][ODBC Driver Manager] Invalid string or buffer length exception" So I decided to use the UCanAccess JDBC driver instead. Does anyone have…
justgock
  • 29
  • 1
  • 5
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
2
votes
1 answer

Cant connect to MS Access mdb file using DBeaver and the default UCanAccess-5.0.0 driver

Get the following error: UCAExc:::5.0.0-SNAPSHOT unexpected token: DOUBLE required: FOR unexpected token: DOUBLE required: FOR My connection string is: jdbc:ucanaccess:///mnt/toolboss-plt11/sps.mdb everything else contains default values. I believe…
brent groves
  • 71
  • 1
  • 5
2
votes
1 answer

Does UCanAccess accept SELECT table.* INTO ...?

My code looks like this: PreparedStatement ps = null; sql = "SELECT tblRequestsFromDWH.* INTO tblTechnique FROM tblRequestsFromDWH WHERE tblRequestsFromDWH.finalBethesda Is Null AND tblRequestsFromDWH.smearTechnique Is Not Null"; ps =…
Steve
  • 23
  • 4
2
votes
0 answers

UCAExc:::3.0.7 Decoding not supported. Please choose a CodecProvider which supports reading the current database encoding.error

In my project I was using .mdb file but I changed it .accdb file because of some reason. After doing this it gives me this error. UCAExc:::3.0.7 Decoding not supported. Please choose a CodecProvider which supports reading the current database…
mustafa53
  • 113
  • 2
  • 14
2
votes
1 answer

When I try enter date chosen by Jdatechooser it I get the Error "data exception: invalid datetime format"

I want to input into my MS Access table the date that the user inputs using the Jdatechooser. In Access I have set the Date/time column to 'short date', but any format I try won't work. Help! try { Connection…
Hassan Zaidi
  • 41
  • 1
  • 7
2
votes
1 answer

Connect to a MS Access database secured with a Workgroup security file (MDW) using UCanAccess

I am using UCanAccess driver to connect to an MS Access database without security from Knime software. Now, I need to do the same connection but with a MS Access DB (MDB file) secured by a workgroup security file (MDW). Anyone knows how to do this…
Jennifer Larios Mejía
  • 21
  • 2
2
votes
3 answers

HSQLDB "precision or scale out of range" error when UCanAccess loads database

I'm writing tools in java that connects to different access databases. I have a particular scenario that throws the following exception -5592:UCAExc:::4.0.4 precision or scale out of range The exception is listed under HSQLDB exceptions: 5592=42592…
LeedMx
  • 424
  • 4
  • 19
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

Load MS Access table as DataFrame in Spark

I'm trying to load table from MS Access database. I'm doing it like this: val table = sparkSession.read .format("jdbc") .option("url", "jdbc:ucanaccess://D:/User/test.mdf;memory=false") .option("dbtable", "my_table") .load() …
kerrache massipssa
  • 63
  • 1
  • 7
2
votes
1 answer

Ucanaccess 4.0.3 cannot find a specific table in my DB

I'm using jdbc with ucanaccess... When I connect to the database, there is one table that Ucanaccess is not finding... I saw that in debug mode in NetBeans... Therefore when I try a transaction on that table, I get : UCAExc:::4.0.3 user lacks…
tom johnes
  • 387
  • 1
  • 3
  • 12
1 2 3
…
31 32