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

Integrating Java and Access/SharePoint using UCanAccess and Hibernate

Is it possible to open an Access 2013 database file stored in MS SharePoint using UCanAccess (JDBC)?
oitathi
  • 153
  • 2
  • 3
  • 17
0
votes
1 answer

uCanAccess error in Boomi Timer already cancelled

We are using Boomi to do an integration between a DB and an MS Access DB. We are using uCanAccess as our JDBC so we can read/write the MS Access DB. However if our initial query returns more than 49 rows, we receive the following error from Boomi…
Fritz
  • 1
  • 4
0
votes
1 answer

UCanAccess Exception: cannot getMetaData from ResultSet (invalid cursor state)

I'm trying to get data from an Access table and show it on a JTable. I'm using UCanAccess as Java 8 does not support JDBC-ODBC. My window class calls the charging methods: ctrlGestionVentas= new…
Ezequiel Berto
  • 130
  • 1
  • 1
  • 11
0
votes
0 answers

ms access database and jar file

guyz i have been working on a small project and its basically a admission system in java i have used ms access as my database in which a student record is inserted, searched and deleted. i have used UCanAccess as my driver for jdbc:odbc and is…
Abdul Wahab
  • 99
  • 1
  • 2
  • 11
0
votes
1 answer

"invalid character value for cast" error on INSERT via UCanAccess

I'm getting the error net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::3.0.6 data exception: invalid character value for cast when I run this code: package aoa; import java.sql.*; public class Aoa { public static void…
Mcolo
  • 149
  • 2
  • 10
0
votes
0 answers

Data displays after actual SQL insert into query and not via my netbeans query

Below is code to my UserArray which connects to my database and has a method to insert a new user based off data taken from a gui i created (when a create button is clicked) [see second bit of code] public class UserArray { private Connection…
Gelos
  • 27
  • 2
0
votes
1 answer

How to show data from Access in the correct order?

String sql="select ID,Hmerominia,Agores,Pliromes,Eksoda,Zhta,Metaforika,Pliromimetafo,Epitages,Xondriki,Noiki,Plirominoiki from Synola"; try{ pst = conn.prepareStatement(sql); rs=pst.executeQuery(); …
asd32
  • 45
  • 3
  • 10
0
votes
1 answer

Netbeans ucanaccess

conn = Connect.ConnectDB(); String sql = "insert into Ianouarios (" +"id," +"Hmerominia," +"Agores," +"Pliromes," +"Eksoda," + "Zhta," +"Metaforika," …
asd32
  • 45
  • 3
  • 10
0
votes
0 answers

Access local .mdb file with java

I have read about million solutions, none seemed to work. I have the following piece of code : //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); //Connection dbConnection =…
UserED
  • 33
  • 10
0
votes
1 answer

Ucanaccess JDBC Driver - outofmemory error with memory=false setting

I am using jackcess-2.1.1. I have set the memory=false parameter, but still face the outOfmemory Error. It happens while processing a MDB file of 1.8GB size. The JVM memory arguments are set to 1GB max size. If I change the Max size to 2GB, it works…
Leela Addagulla
  • 181
  • 1
  • 1
  • 10
0
votes
1 answer

how to get all the columns of a specific table ucanaccess

I want to get all the column names for a specific table called Impedance2, in an Access database I have. I can only seem to get column metadata I think rather than the actual name: This is the code I am using: DatabaseMetaData md =…
Sebastian Zeki
  • 6,690
  • 11
  • 60
  • 125
0
votes
1 answer

Recover data and stored queries in ms-Access using Java Ucanaccess

I have an Access database. This database contains tables and also stored queries. My goal is to use Java Ucanaccess (a JDBC connector) to use the data stored in the Access file and create reports with Jaspersoft. Querying on normal tables…
pathat0r
  • 75
  • 10
0
votes
0 answers

Differences between hxtt and ucanaccess

I know both work. I know ucanaccess is open source. I just wonder if there are any benefits in still using hxtt. I have some corruption issues with hxtt, so I'm trying to understand if it's a good approach to completely switch over to ucanaccess.…
George Sofianos
  • 440
  • 1
  • 7
  • 17
0
votes
2 answers

Intermittent results UPDATE, DELETE, SET, or GET statement: ; ResultSet is empty

I'm doing an assignment for college Using a query in netbeans to a database in ms access that took me two solid days of head scratching to get to so far. Problem is it will give me a lovely result as soon as I open the package and run it. There…
Javaiskillingme
  • 49
  • 5
0
votes
1 answer

Read an Access database embedded in a JAR file

I have a Java program which uses UCanAccess to read an Access database. When I export my program to a JAR file I can't read the database file that is inside the JAR. I tried with getClass().getResource("/Database.accdb").getPath() but it doesn't…
Carlo
  • 36
  • 3
1 2 3
…
31 32