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

How do I connect to the database MS Access?

I have a Maven Project and I am trying to create a connection to my MS Access db. The problem is that it does not open. I do not receive any type of error, but the program remains active without returning the connection. I tried to stay on hold two…
M.Anthony
  • 1
0
votes
0 answers

NullPointerException when attempting to perform INSERT query with UCanAccess

I'm trying to execute a query line on a Access Database, but I can't. I'm using UCanAccess for connection on the DB and the class that runs the connection is doing fine but when I try to use the prepareStatement method it returns a error. Here's…
Victor Baptista
  • 1
  • 1
0
votes
2 answers

Hibernate - org.hibernate.MappingException when using net.ucanaccess.jdbc.UcanaccessDriver

I am trying to query an access db in java 8 and i use maven. I am using net.ucanaccess.jdbc.UcanaccessDriver for my connection and below is my hibernate.cfg.xml:
Iman
  • 769
  • 1
  • 13
  • 51
0
votes
0 answers

UCanAccess driver not in DriverManager.getDrivers() list unless Class.forName() is called

After reading about UCanAccess in this question I've started building it into my app. It seems to be working, but I've noticed an oddity. I put in the following code at start-up, and found that it doesn't print anything, unless I preface it with a…
DVA
  • 331
  • 2
  • 13
0
votes
1 answer

ucanaccess 3.0.2 still returning column names in uppercase

my access .accdb databases have column names in mixed case. I put ucanaccess 3.0.2 in my class library (with the dependent libraries that came with ucanaccess) in NetBeans. I'm getting the error that says object not found with the column name in…
PiBurner
  • 75
  • 11
0
votes
0 answers

Error in connecting java with MS Access using UCanAccess. Arising ClassNotFoundException

I want to connect Java 1.8 with Access but the error occurs and I don't know how to fix it. I have written this code: import java.sql.*; class db1 { public static void main(String args[]) { //Load a driver try { …
anushka bajpai
  • 1
  • 5
0
votes
1 answer

MS Access Named Query with parameters

How do I call a named query with parameters? I have the following query in MS Access called "getColor": SELECT * FROM WHERE Colors ID_COLOR = [PAR_ID] I have tried unsuccessfully with CallableStatement and…
Luis
  • 51
  • 1
0
votes
1 answer

Query output is incorrect in ucanaccess

I have an accdb file. I am using the ucanaccess api to connect to it from my Java project and process the data. (I do not have MS Access, I use ucanaccess as a referenced library in my Java Project). However, I am facing a strange issue, when I…
mridula
  • 3,203
  • 3
  • 32
  • 55
0
votes
0 answers

Using the UCANACCESS_HOME system property with LibreOffice Base and UCanAccess

I am trying to use LibreOfffice Base to access an MS Acccess database using UCanAccessv3.0.1 on Lubuntu. Everything is fine until I get an error message about the UNCANACCESS_HOME system variable. In spite of correctly entering the path, I get a…
Mike Sullivan
  • 1
  • 1
0
votes
0 answers

Connecting UCanAccess to a database on a network share

I have to make a LAN-based app, but I'm having trouble with connecting my database to my Java project. When I tried this public static void databaseCon(String connection) { try{ Class.forName("net.ucanaccess.jdbc.UcanaccessDriver"); …
bloomindindin
  • 85
  • 1
  • 6
0
votes
1 answer

UCanAccess can not find my DB

I'm trying to connect my Java code to a table in access using UCanAccess here is my code: import java.sql.*; public class HH { public static void main(String[] args) throws SQLException { // opens a connection to the database …
AvivLevi815
  • 37
  • 11
0
votes
1 answer

ucanaccess : unexpected token with spaces

Today I facing issue with Access DB, Ucanaccess 3.0 and table names with spaces. To explain : I have a huge query and ucanaccess throw this exception : SQLException: UCAExc:::3.0.0 unexpected token: AIRCRAFT So I investigate and try to isolate this…
Kromen
  • 178
  • 15
0
votes
2 answers

Date filtering using JDBC

What is the correct format for date filtering - JDBC to SQL I have been trying to use the following with an MS-Access DB SELECT doctorbusiness.dateofreport, doctorbusiness.patientname, doctorbusiness.labcomm, …
mustangDC
  • 945
  • 1
  • 12
  • 33
0
votes
0 answers

JavaFX : tableview won't populate from database (ucanaccess)

My application contains a tabpane, each tab is a nested fxml with controller included. Each fxml file have a tableview that retrieve data from a microsoft access database. Some of the tables that only have string columns work and get populated but…
whites
  • 175
  • 1
  • 10
0
votes
1 answer

ucanaccess connected to a hosted database

I am having an issue getting ucanaccess to connect to my database. While building the application I have maintained the database locally have been able to connect to it by passing the local file path in the URL. I am now trying to move this online…
boredkid182
  • 23
  • 4
1 2 3
…
31 32