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

GENERATED ALWAYS AS IDENTITY produces incorrect table schema with UCanAccess

I'm writing a program using JDBC/UCanAccess and I'm finding when I create one of the tables, instead of creating four columns with the DateTime format, it also applies the same format to the next column, displacing the other formats: CREATE TABLE…
user9380548
  • 23
  • 1
  • 4
2
votes
1 answer

Error during starting Jboss 4.3 while binding default hsql datasource

I get below error during JBoss start up. [ServiceController] Problem starting service jboss:service=Hypersonic,database=localDB java.lang.NoSuchMethodError: org.hsqldb.DatabaseURL.parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties; …
Manish Bansal
  • 2,400
  • 2
  • 21
  • 37
2
votes
1 answer

Squirrel SQL - UCANACCESS_HOME system variable isn't defined

Setup Windows 10 1709, 16299.64 Squirrel SQL squirrel-sql-3.8.0 installed at "C:\Program Files\squirrel-sql-3.8.0" UCanAccess UCanAccess-4.0.2-bin installed at "C:\Java\UCanAccess-4.0.2-bin" Java 8 Update 151 I'm new to Squirrel SQL. I'm…
user2970483
  • 323
  • 5
  • 14
2
votes
1 answer

UcanAccess retrieve stored query sql

I'm trying to retrieve the SQL that makes up a stored query inside an Access database. I'm using a combination of UcanAccess 4.0.2, and jaydebeapi and the ucanaccess console. The ultimate goal is to be able to do the following from a python script…
Mashume
  • 33
  • 7
2
votes
1 answer

"UCAExc:::4.0.2 unknown token:" for INSERT with date and time literals

I have an application I am trying to update since it was using a jdbc driver (sun.jdbc.odbc.jdbcodbcdriver), and am now using Ucanaccess. Currently the application correctly accesses the database, but is failing on making changes to the Access…
Jonathan Valdivieso
  • 33
  • 7
2
votes
0 answers

invalid cursor state: cursor position is unknown

I am using uCanAccess library to insert a row into an existing MS Access table through a swing GUI. The code works fine till rs.insertRow(), after which the cursor cannot be set to anywhere. Here is my code: private void…
Ali Iqbal
  • 87
  • 1
  • 9
2
votes
2 answers

Low performance of subsequent query with the same table using UCanAccess

I am trying to update approx. 3800 rows in a table in two steps: set all values to 0 set some of them in a loop to a calculated value The first step is fast (< 1 s). However the second step takes around 3 s. Maybe there is some problem in the…
Sophia
  • 1,821
  • 2
  • 17
  • 19
2
votes
1 answer

Having an access database file in one location so that it can be used in development and when distributed

Although I have done much research I am still struggling to find the correct place to put my access database file so that it can be used with my java project and my final jar file (without having to change the code for each case). I can place it…
Nyla of Arda
  • 106
  • 3
  • 9
2
votes
1 answer

UCanAccess 4.0.2 uppercase column names cannot be found

In my java program, I want to query some columns in * .mdb using UCanAccess. However, some characters seem wrong because it converts all column names to upper case. For example, on one platform, column name egitim becomes ÈGITIM in capital letters,…
user2972185
  • 231
  • 3
  • 12
2
votes
1 answer

JDBC PreparedStatement default values on Insert (UCanAccess)

I was wondering how I can fetch the default values of newly inserted rows of MS Access via UCanAccess. Table: my_tbl Column Type -------+----------------------- ID | PrimaryKey, AutoNumber Label | Text DT | Date/Time, Default:…
Markus
  • 763
  • 7
  • 24
2
votes
1 answer

Using UCanAccess instead of the JDBC-ODBC Bridge for working with DBF files

I'm using NetBeans IDE 8.2 and would like to make a connection with UCanAccess to access my database files. Initially I was using jdbc:odbc but I found that Java 8 onward no longer supports this method Here is my initial coding…
Question asker
  • 45
  • 8
2
votes
1 answer

Access DB autoincrement doesn't let me open the table

I just managed to connect with a local .accdb Access Database and am now trying to create my tables. I run these two lines with Java and there are no errors during running these SQL-Commands: Statement st =…
Nicola Uetz
  • 848
  • 1
  • 7
  • 25
2
votes
1 answer

Flyway support for ucanaccess?

I am working on a spring boot project that uses ucanaccess 4.0.1 to connect to a Microsoft Access 2010 database, and I'm trying to setup flyway 4.1.2 to work with it. I know that ucanaccess uses HSQLDB and that flyway supports HSQLDB, but I can't…
Zack W
  • 146
  • 6
2
votes
1 answer

UCAExc 3.0.7 invalid transaction state: read-only SQL-transaction Sometimes when saving to .accdb

I am working on a spring boot application that uses ucanaccess 3.0.7 to connect to an Microsoft Access 2010 database. I am having no problems reading from the db, but I am seeing this 'invalid transaction state: read-only SQL-transaction' error pop…
Zack W
  • 146
  • 6
2
votes
0 answers

Unable to get JDBC to permanently update my database file in Eclipse

I have created a database file "accounts.accdb" and I'm using the UCanAccess JDBC driver in Eclipse to access it. I can access it fine and update it using my server application but when I close my server application the contents of the database file…
c.garry
  • 61
  • 1
  • 2
1 2 3
…
31 32