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

"Missing columns in relationship" when creating table

I have tried to create three tables(CUSTOMERS, VEHICLES and RENTALS), the third table (RENTALS) has foreign keys referring to the two primary keys of the first two tables (CUSTOMERS and RENTALS). When creating this third table I get an error …
Chris Claude
  • 461
  • 6
  • 11
3
votes
1 answer

"UCanAccess: user lacks privilege or object not found" second Connection

Right now I'm creating a dashboard; I need to fill a JTable with info from an MS-Access database, for that purpose I'm using this code. try { con3 = Connectionz3.getConnection();//Connection Object String dashboard2 = "Select * FROM…
Alex Galvis
  • 37
  • 8
3
votes
1 answer

BIG_INT error with UcanAccess and Java

I tried to connect a db only to try UcanAccess like an example that I found here, but it doesn't work, it has a BIG_INT error, I don't know how to fix it; I work on java8, I have added commons-lag 2.6, commons-logging 1.1.1, hsqldb 2.1.4, jackaccess…
pazz98
  • 61
  • 9
3
votes
1 answer

Unable to delete database file after closing UCanAccess connection

I used UCanAccess to connect to temporary Access files for reading data, after which I want to delete these temporary files. However, I always get file.delete()=false. Here is my code public class JAccess { static Connection conn; static…
user8036126
3
votes
0 answers

Prefix for autogenerated alias on hibernate5

I'm facing an issue with the aliases generated by Hibernate based on an Entity. @Entity @Table(name="Base de Clientes") public class BaseDeClientes{ @Column(name="1011 Piso") private String _1011Piso; @Column(name="1011 Status") …
jotapdiez
  • 1,426
  • 12
  • 27
3
votes
1 answer

list the tables in a database

Trying to get a list of all the tables in the .accdb database (2007-2016 format). Can't seem to find the MSysObjects table. Using UCanAccess sql = "SELECT Name FROM MSysObjects WHERE Type = 1 AND Flags = 0"; ResultSet rs = queryChem(sql); public…
Matt
  • 33
  • 4
3
votes
1 answer

Java Combo Box inside a Table Over writes data

I tried hard to find a better title for this ticket but that was the best I could come up with. I am having an issue with a JComboBox inside of a JTable. The program is a very scaled down version of the original. It pulls data from a database and…
Goff
  • 173
  • 1
  • 2
  • 12
3
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…
LPrc
  • 1,217
  • 12
  • 29
3
votes
2 answers

Update to float value not being persisted for UCanAccess with SingleConnection=true

I have a project using EclipseLink-2.6.0 and UCanAccess-3.0.4 (as DB driver) to modify an MS Access database. (NB legacy requirement - not my choice). There is a table with a column of single precision (Again, legacy requirement - not my choice).…
William
  • 19,567
  • 8
  • 45
  • 88
3
votes
1 answer

Netbeans SQL editor problems

I'm trying to use the Netbeans SQL editor to make some tests. I've made the connection between Access and Netbeans with the UcanAccess's jars and no problem with it. I can execute a select in the editor and everything ok, but it does not allow me to…
aserrin55
  • 330
  • 2
  • 14
3
votes
1 answer

UcanaccessSQLException: UCAExc:::3.0.1 data type of expression is not boolean

I have a table like the following image I need to get all the English words that its Kurdish Word contains "بةرز", So i cant use select English from Table1 where Kurdish like '%بةرز%'; because it also accepts the words that are sub-string in…
Hamreen Ahmad
  • 504
  • 4
  • 19
3
votes
1 answer

Reading from an encrypted Access .mdb using Java / Jackcess

I need to read Data from an encrypted Access 97 Database and tried out Jackcess and UCanAccess. I'm using jackcess-2.1.2.jar, jackcess-encrypt-2.1.0 and bcprov-jdk15on-152.jar from bouncycastle.org As UCanAccess uses Jackcess internally I'm getting…
A. Rohmann
  • 91
  • 1
  • 8
3
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
  • 65
  • 1
  • 6
3
votes
1 answer

Ucanaccess error - unexpected token

//golfer and CourseName are strings initialised earlier String query = "INSERT INTO Temp (GolferID,CourseID,DatePlayed,1st,2nd,3rd,4th,5th,6th,7th,8th,9th,10th,11th," + "12th,13th,14th,15th,16th,17th,18th)VALUES('" + golfer…
Sirshen Munsamy
  • 33
  • 1
  • 3
3
votes
1 answer

How to change SortOrder to avoid "unsupported collating sort order" error?

I've been working on a program with a .mdb database from a third party client. Everything was fine until I've tried to update elements on the database. The sortOrder field is not correct. I've tried to change it to general with MS Access, and had no…
Amnor
  • 360
  • 6
  • 20
1
2
3
…
29 30