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

ucanaccess weird exception i cannot handle

I started using ucanaccess lately for connection to access database (obviously) and it all worked fine until now. I'm starting to insert about 500,000 rows into the database.... when I reach about 400,000 the program stops.... the problem is I cant…
Bar Hoshen
  • 152
  • 16
-1
votes
1 answer

UCanAccess driver throws Exception when trying to connect with Access database while Jackcess connection works fine

1) This UCanAccess sample code works with database A (Access 2000) Class.forName("net.ucanaccess.jdbc.UcanaccessDriver"); Connection conn = DriverManager.getConnection(DATABASE_URL); System.out.println(conn); 2) The same…
Andreas M. Oberheim
  • 764
  • 8
  • 7
-1
votes
1 answer

Java Error - net.ucanaccess.jdbc.UcanaccessSQLException: malformed string: '

I have an error using uCanaccess to retrieve my database which I have saved in my desktop. My code is below: package Week11Package; import java.util.Scanner; import java.sql.*; public class dbTest1 { static Scanner input = new Scanner…
Vince
  • 73
  • 1
  • 2
  • 4
-1
votes
1 answer

Reading an Access calculated field from Java on any OS (not just Windows)

How can I read calculated fields with UCanAccess or Jackcess (or any Java library that also works on Linux)? I don't care if I can't get the result straightaway, I'll settle for just getting only the function if need be. For simplicity, we'll…
user3037710
  • 11
  • 3
-2
votes
1 answer

jdbc ucanaccesssqlexception ucaexc ::: 4.0 4 unexpected token: DOCTOR

I am using netbeans with java classes to fetch data from access database tables and display it on jtable. When I followed all the steps it gives me the ucanaccess error as net ucanaccess jdbc ucanaccesssqlexception ucaexc ::: 4.0 4 unexpected token:…
Abdul Qayyum
  • 3
  • 2
-2
votes
1 answer

Is it possible to store resultSet into a multidimensional array and use the same array to export the values to an excel sheet

I have exported a resultset to an excel sheet with the exported excel at the end. import java.sql.Statement; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Arrays; import java.util.Calendar; import…
Vinne
  • 1
  • 1
-2
votes
1 answer

What is wrong with my update query, parameter not set error

I am beginner of java and this is the change password coding.I tried to use update query to update the password.But something wrong with my coding.Can someone help me to find it out? After i execute, occur the…
areil
  • 3
  • 3
-2
votes
1 answer

UCAExc:::3.0.7 user lacks privilege or object not found: SLIPSET

I have looked through similar threads on this site and none of the suggested answers seem to work. I am writing a java program that interacts with an Access database using SQL. I have successfully connected to the database and pulled information…
ace7
  • 71
  • 1
  • 2
  • 6
-2
votes
1 answer

Cannot Delete a record with an delete query though Java Eclipse connected to MS Access

Problem with delete record in MS Access. It show this error when print stack trace net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::3.0.1 user lacks privilege or object not found: PHONE at…
Ryan Choong
  • 21
  • 3
-2
votes
1 answer

Using UCanAccess to read excel sheet instead of JDBC-ODBC Bridge

I tried to upgrade my server JVM to java 8 but I was surprised that Oracle has removed JDBC ODBC bridge from Java 8 ! I searched for alternatives and I found people here provide another solution by a library called UCanAccess but it's mainly for…
A. Shaheen
  • 105
  • 12
-2
votes
1 answer

Connect to Access database protected with database password using UCanAccess

I can connect to an Access database with UCanAccess from NetBeans 8, but now I need to specify database password in the connection properties. How can I do that?
ChemaPando
  • 1
  • 1
  • 2
-4
votes
1 answer

UCAExc:::4.0.4 attempt to assign to non-updatable column

This is a link to a sample database I would like this code to connect to my database and encrypt the rows within the table "WellTable" unfortunately I am getting an error listed below. I have followed the guide here: Manipulating an Access database…
Oneil Alec Mahoney
  • 1
  • 7
1 2 3
…
29
30