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
0
votes
0 answers

Can connect from Java to MS Access with jackcess but cannot with ucanaccess

I will have to move from java 6 to java 8, so have to replace jdbc:odbc with something else. I tried ucanaccess, but have exception: net.ucanaccess.jdbc.UcanaccessSQLException: data exception: numeric value out of range readAllSites2 [ucanaccess]…
Ted Stankiewicz
  • 1
0
votes
0 answers

Huge ms access database with javafx, ucanaccess

I have a huge MS Access database file (aprrox. 1gb) and about 5 different GUI (FXML). Each fxml contains data from different tables. I am using ucanaccess to connect with database. Now I am having problem in connecting with database. I never get…
PDM
  • 31
  • 1
  • 5
0
votes
2 answers

Simple Delete Query not working with UCanAccess

I'm using Netbeans IDE 8.02 to manipulate an access database, but with the removal of the driver, I have been struggling with UCanAccess. I have been able to insert datainto the database and I have been able to receive data from the database, but…
Tokolosshh
  • 11
  • 2
0
votes
1 answer

No Suitable driver found unless full path used

When trying to connect to an MS Access database using ucanaccess I keep getting the "No suitable driver found" error when using the relative path to my database: SEVERE: null java.sql.SQLException: No suitable driver found for…
John
  • 165
  • 2
  • 3
  • 15
0
votes
1 answer

Can't connect to Access database file in java

So I'm trying to connect to a database file MSAccess. Here is the code: public class DAOCarLoader implements CarLoader { List < Owner > owners = new ArrayList < Owner > (); Connection con; Statement st; ResultSet rs; public…
Cr1ms0nStraY
  • 81
  • 1
  • 2
  • 11
0
votes
1 answer

Inserting information from Netbeans IDE into Microsoft Access Database

I have a project that has to be handed in that I'm struggling to complete. I need to insert information into a Microsoft Access Database. I have managed to connect to the database with UCanAccess, but my Insert query does not seem to work. Here is…
Tokolosshh
  • 11
  • 2
0
votes
1 answer

UCanAccessSQLException: constraint violation

I'm having problems with my Java program. I'm using MS Access as a database and UCanAccess to connect to the database. When I'm trying to insert a text into the database, I get an Exception: net.ucanaccess.jdbc.UcanaccessSQLException: integrity…
Jákup
  • 74
  • 12
0
votes
1 answer

Is there a way to force read from disk in UcanAccess?

I'm building a Java app that needs to co-exist with a VBasic one. Both consume a single Access database (.mdb) As sometimes the VB app writes the DB I'd need to programmatically re-read from disk the mdb. Is there a way to do this? is this Jackcess…
pepepapa82
  • 167
  • 2
  • 10
0
votes
2 answers

How do add ucanaccess maven dependency in pom.xml

I can't get the maven dependency for ucanaccess to work: net.ucanaccess ucanaccess 2.X.X It doesn't seem to be available?
Miquel
  • 11
  • 2
0
votes
1 answer

"Unexpected end of statement" error in UCanAccess

I use the following code below to update or edit data in my Access database but every time I click the button this error appears: net.ucanaccess.jdbc.UcanaccessSQLException:unexpected end of statement public void actionPerformed(ActionEvent e) { …
Miguel James
  • 21
  • 1
  • 4
0
votes
1 answer

Connecting Java with Microsoft Access using ucanaccess

When I try to access the insert in the existing database using ucanaccess, it's shows a mean error like this: Exception in thread "main" net.ucanaccess.jdbc.UcanaccessSQLException: user lacks privilege or object not found: L at…
Thiyagarajan
  • 1
  • 1
  • 1
0
votes
3 answers

error using ucanaccess in osgi

I have read the question UcanAccess intro but can not get the driver to work in an OSGi / RCP application. I think it is a classloader issue but don't know how to resolve it. Relevant snippet of code, it fails on the second line. The MDB exists and…
Timothy Vogel
  • 1,363
  • 2
  • 21
  • 39
0
votes
2 answers

SQL Query uses a lot of resources with no results

Good day everyone, I recently had to move to the UcanAccess' engine from the Access JET Engine and I am not very familiar with "standard" SQL queries, not using the "INNER JOIN" function. I wrote the following SQL query based on one of my previous…
anitag95
  • 307
  • 2
  • 16
0
votes
2 answers

inserting into access database apostrophe issue

I am trying to get some information of a website into an access database. I am creating a bean out of the information I get of the website and then send that bean into the database. the problem is that I've been blocked getting certain things into…
Bar Hoshen
  • 302
  • 1
  • 18
0
votes
2 answers

netBeans and ucanacces sql exception only calling db from code

Well, this is a little odd, I installed succesfully the driver, and in the services tab, my database tables show correctly, but when I call the driver from code I get: java.sql.SQLException: No suitable driver found for…
Amnor
  • 380
  • 6
  • 21
1 2 3
…
31 32