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

Manipulating an Access database from Java without ODBC

I want to manipulate a Microsoft Access database (.accdb or .mdb file) from my Java project. I don't want to use the JDBC-ODBC Bridge and the Access ODBC driver from Microsoft because: the JDBC-ODBC Bridge has been removed from Java SE 8 and is not…
Gord Thompson
  • 116,920
  • 32
  • 215
  • 418
8
votes
3 answers

Can't connect or insert to database using ucanaccess method in applet

While connecting one applet to an Access DB using the jdbc:ucanaccess method, I get the following error: Firstdb.java:44: error: unreported exception SQLException; must be caught or declared to be thrown stmt.executeUpdate(sql); …
Shibin Raju Mathew
  • 920
  • 4
  • 18
  • 41
8
votes
2 answers

How to configure Squirrel SQL client to work with MS Access

I'm struggling to get Squirrel SQL to connect to MS Access database (just a normal one, no password): I create an Alias and use Driver: JBDC ODBC bridge (There is a tick in front of this driver) I don't know what to put in URL -------- I use: Path…
Harry Duong
  • 407
  • 6
  • 14
6
votes
1 answer

Using java for searching for data by using part of the row in microsoft access database

I have this table And I am using the following code to retrieve data from my table that returns all the English words that its Kurdish word contains بةرز targetText="بةرز"; try (PreparedStatement ps = conn.prepareStatement( "SELECT English,Kurdish…
Hamreen Ahmad
  • 522
  • 5
  • 21
5
votes
2 answers

"No suitable driver found" when running from JAR

I have developed a small game in which the text input by the user needs to be posted in a MS Access Database. It all works fine in NetBeans but whenever I access it from the JAR file (which is ultimately what I need to hand to my client), it does…
Paul Formosa
  • 53
  • 1
  • 3
5
votes
1 answer

Memory consumption when using DriverManager.getConnection with UCanAccess

I am using JDBC along with UCanAccess in order to create a connection to a MS Access file via direct filepath to store a specific table into a JSON object. However, my line of code conn = DriverManager.getConnection(s1+inFilePath, user,…
matt
  • 53
  • 3
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
1 answer

"WARNING: Error in the metadata of the table ..." on opening database

I'm getting a warning message like this when connecting to some databases: Error in the metadata of the table tblCourses: table's row count in the metadata is 69 but 37 records have been found and loaded by UCanAccess. All will work fine, but it's…
bloomindindin
  • 85
  • 1
  • 6
5
votes
2 answers

"unsupported collating sort order" error updating Access database from Java

I want to make a small change in an Access table using UCanAccess via NetBeans, but I encountered a problem at line pst.executeUpdate(); Database details: database name : duruBistro.accdb table name : person field names: tc_no (text) …
ysnndr
  • 63
  • 1
  • 1
  • 3
5
votes
1 answer

Formatting Dates while using the UCanAccess JDBC driver

When using the UCanAccess driver in Java, I am finding it very difficult to output dates into specific formats. Currently, I am using the PreparedStatement.setDate() method which requires the date to be in the format [yyyy-MM-dd HH:mm:ss]. The…
ksmark
  • 67
  • 2
  • 6
4
votes
1 answer

Hibernate : invalid ORDER BY expression

I have tried to add some Order to my Criteria like this. crit.addOrder(Order.asc("priority")); // Not the real property though And test on my System using a MsAccess database with HSQLDialect And i get Caused by: org.hsqldb.HsqlException: invalid…
Tuấn Phạm
  • 688
  • 6
  • 20
4
votes
1 answer

Connect to a System DSN via UCanAccess

I'm currently upgrading a project from Java 7 to Java 8, thus I switched from using the JDBC-ODBC Bridge to using UCanAccess. The database I want to connect to is registered as a system DSN so I connected to it like…
SimonH
  • 1,385
  • 15
  • 35
4
votes
1 answer

Using UCanAccess getting ERROR "unexpected token: table-name

Related to earlier questions about "unexpected token" I get the following error UCAExc:::3.0.3.1 unexpected token: $BRANDRAP When I run the code below in the NB IDE try { …
Rawle Ramkeesoon
  • 101
  • 5
4
votes
3 answers

UCANACCESS_HOME system variable not set

I'm trying to use UCanAccess to connect a Java application to an Access database but when I run my Java app I get the error that UCANACCESS_HOME system variable isn't defined... I have added the six jar files to the project library in NetBeans.…
user3692531
  • 51
  • 1
  • 5
4
votes
1 answer

How to avoid "Out Of Memory" error when connecting to Access database?

I have a local MS Access database, and I'm trying to connect to it via Java. I'm using UCanAccess as the JDBC driver, and while the database is linked to a password protected database on a network drive, the one I'm connecting to has already been…
TheDankOG
  • 77
  • 1
  • 6
1
2 3
…
31 32