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).

447 questions
115
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
  • 98,607
  • 26
  • 164
  • 342
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
  • 809
  • 3
  • 12
  • 37
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
  • 504
  • 4
  • 19
6
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
  • 387
  • 4
  • 14
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
  • 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
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
  • 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
  • 628
  • 4
  • 17
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

UcanaccessSQLException: unexpected token: ORDER

I'm making a little app in Java and MySQL with PHPMyAdmin and all runs fine, but my professor says that we have to work with a database in Access, so I just changed my class connection and imported my database. The INSERT, SELECT and other UPDATE…
Frozt360
  • 41
  • 4
4
votes
1 answer

net.ucanaccess.jdbc.UcanaccessSQLException: invalid authorization specification - not found:

i am trying to fill a table from a database using ucanacces but it gives me the following error and i don't understand why, upon googling this error most people mention something about a username and password but i don't see how that is relevant as…
Bart
  • 41
  • 3
4
votes
1 answer

Reading .mdb files with UCanAccess returns column names in all UPPERCASE

I'm in the middle from migrating from the JDBC-ODBC bridge driver to the UCanAccess driver. In doing this, I'm facing the following problem: The UCanAccess driver returns all columnames in UPPERCASE, but I need them to be CamelCase. Any…
Fabian
  • 1,862
  • 3
  • 23
  • 34
1
2 3
…
29 30