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

"feature not supported" error when executing a PreparedStatement in UCanAccess

I am trying to populate my combobox in a GUI using ResultSet (supported on UCanAccess) package Vegan; import java.sql.Connection; import java.sql.DriverManager; public class connectionString { static Connection connection = null; public static…
Jeremy Crouch
  • 67
  • 1
  • 6
3
votes
1 answer

invalid datetime format: insert date/time into Access from Java

I want to insert a datetime value to Access, but I get this error: net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::3.0.4 data exception: invalid datetime format Here is the code : private void…
janotama
  • 197
  • 7
  • 18
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
  • 20,150
  • 8
  • 49
  • 91
3
votes
1 answer

UCanAccess, IKVM and C#

I'm trying to make UCanAccess work in C#. I'm working on MonoDevelop using Mono on Linux. I already converted the needed .jar files into .dll .NET files using IKVM, this way: ikvmc -target:library file.jar Then I referenced the converted .dll files…
wind39
  • 441
  • 4
  • 14
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
  • 350
  • 5
  • 15
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
  • 522
  • 5
  • 21
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
  • 2
  • 9
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

Extract OLE Object (Word document) from MS Access

I have a Microsoft Access database with an OLE Object field holding a Microsoft Word document. I have tried to find code to retrieve the file saved in the OLE Object, so that the user can download it from a button in my JavaFx application, but I had…
whites
  • 175
  • 1
  • 10
3
votes
2 answers

Slow initial connection to MS access database

I'm using UCanAccess to connect my JavaFX app with the database on the shared drive. The first time I open the app and run some query the initial connection to the database takes around 25 seconds. I put some timestamps and found that the root cause…
Wizard
  • 292
  • 4
  • 11
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
  • 380
  • 6
  • 21
3
votes
2 answers

can't make updatable resultset with ucanaccess

I've tried most of the examples found here and the web, but I can't open a MS access database(2002 or 2013) and get an updatable result set using UCanAccess. The same code using the JDBC:ODBC driver/connection/works. I've written short test code to…
PiBurner
  • 75
  • 11
3
votes
1 answer

Ucanaccess connection of my Android app with a huge MS Access database is taking too much heap space on Android device. Any alternatives?

I am developing an Android app that needs to fetch data from a huge MS Access database of 120MB size. I have written code to establish connectivity and execute a simple query on the database. I run the same java code on my laptop and my Android…
sga4
  • 350
  • 4
  • 15
3
votes
1 answer

java sql exception parameter not set

I am trying to get data from a database in a table with 2 where parameters, When i try to execute this code it gives the error: Parameter not set. I think it is a small mistake but I can't find it. The problem could be with the 2 where parameters, i…
gilles coene
  • 33
  • 1
  • 1
  • 6
3
votes
1 answer

UCanAccess error - net.ucanaccess.jdbc.UcanaccessSQLException: incompatible data type in operation: ; in LIMIT, OFFSET or FETCH

I am new to UCanAccess and am using it in the place of reinstalling Microsoft Office from 32-bit to 64-bit or Netbeans 8.0.2 from 64-bit to 32-bit. I am running a simple program to connect to a small database and display results from it; however I…
Greatmar2
  • 89
  • 1
  • 11
1 2
3
…
31 32