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

How to use Jaspersoft Studio with UCanAccess?

I'm exhausted searching how I can connect Jaspersoft Studio to my database in Access using the Driver UcanAccess! I dont want to use OBDC anymore. I already insert all jar files inside lib/ folder to my Classpath: I tried setting the JDBC URL Like…
TwoDent
  • 405
  • 7
  • 26
2
votes
1 answer

I am getting some issues regarding retrieving data from ms access database

I am trying to retrieve data from database but i am getting some issues. Here is my code: { try { Connection conn=DriverManager.getConnection("jdbc:ucanaccess://F:\\Realestate\\real estate.accdb"); Statement…
Mr.s
  • 89
  • 6
2
votes
2 answers

Issues with retrieving data from Access database using criteria from JTextField objects

I have created user login window in java and i am getting some issues regarding retrieving saved data from ms access database. Here is my code: package databaseretrievedata; import java.awt.event.ActionEvent; import…
Swager
  • 87
  • 6
2
votes
1 answer

"invalid page number 1" error connecting to database with UCanAccess

I am following this tutorial, just that I changed the connection to UCanAccess. I imported all jars, but I am still getting an error, I have no idea what is the problem The Error net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::3.0.6 invalid…
Marcus Y
  • 111
  • 2
  • 9
2
votes
1 answer

How to set a MS Access DB (.mdb) in JasperSoft Studio (Eclipse)?

I have a .mdb database and I'm trying to design a report using JasperSoft Studio 6.3.0 (Eclipse plug-in). In my Java Application I have used the UCanAccess JDBC Driver to build the connection as JDBC-ODBC Bridge is no longer supported in Java…
Ezequiel Berto
  • 130
  • 1
  • 1
  • 11
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
0 answers

UCanAccess - errors on getMetaData()

I am using UCanAccess to query an Access database (obviously...) and for some reason I am not able to reference getMetaData(), although everything else works. As an example, this code coverts a ResultSet to JSON: public static JSONArray…
Niall
  • 1,551
  • 4
  • 23
  • 40
2
votes
1 answer

UCanAccess calling saved Append, Update, or Delete query

I have an Append query object in my Access database. I can call all Select query objects, with no issues. But if the query inserts into db, I can not call it from Java, the error is "lack of privileges or object not found". How can I call the…
Imad Eddin
  • 181
  • 2
  • 5
2
votes
2 answers

Inserting data with UCanAccess from big text files is very slow

I'm trying to read text files .txt with more than 10.000 lines per file, splitting them and inserting the data in Access database using Java and UCanAccess. The problem is that it becomes slower and slower every time (as the database gets…
Gregor Samsa
  • 115
  • 12
2
votes
2 answers

"given file does not exist" issue with UCanAccess connection

I'm trying to connect to a Microsoft Access database in Eclipse (Mars 4.5.0; Java 1.8) on a Mac (el capitaine). I keep getting the error: net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::3.0.4 given file does not exist:…
Sebastian Zeki
  • 6,690
  • 11
  • 60
  • 125
2
votes
1 answer

Reading from a Database in a remote Server using UCanAccess and Apache Commons Net

I have a java application that needs to read from a database. I was able to do this simply by using the UCanAccess driver to read .accdb files (Microsoft Access). public boolean connect() { System.out.println("\n\nconnecting to…
chris
  • 2,490
  • 4
  • 32
  • 56
2
votes
1 answer

UPDATE with LEFT JOIN not working with UCanAccess

I am trying to update the table row in MS Access from NetBeans. But I am getting the error - net.ucanaccess.jdbc.UcanaccessSQLException: unexpected token: LEFT required: SET I had tested the query directly in MS-Access, which is working perfectly.…
Sri Kiran
  • 21
  • 1
2
votes
0 answers

Is there any way to enable auto truncate for inserts?

I'm trying to migrate a project from HXTT to UCanAccess and the only thing I'm having trouble at the moment is the auto truncation of data. For example if I try to insert a text that is longer than the field declaration (300 characters in a 255 char…
George Sofianos
  • 440
  • 1
  • 7
  • 17
2
votes
3 answers

UCanAccess relative path to Access database file

I have written a simple program for myself which works with an Access database file. I used the absolute path to connect to the db: String path = "jdbc:ucanaccess://D:/Development/20_Eclipse/Budget/data/Budget.accdb"; …
Mattizin
  • 350
  • 1
  • 6
  • 19
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
1 2 3
…
31 32