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

Cannot insert values into access 97 using Ucanaccess 3.0.6. It shows access is read only

Cannot insert values into access 97 using Ucanaccess 3.0.6. It shows access is read only. Error: UCAExc:::3.0.6 Access 97 is supported in read-only. Is there any solution for inserting values to access 97 db in java.
Brahma Dutt Sudhakaran
  • 11
  • 1
  • 6
-1
votes
2 answers

UCAExc 3.0.7 unexpected token Errors

I'm working on a project that wants me to integrate a Microsoft Access database into a Java program. I have successfully connected to the database however my SQL statements are not updating the DB. I have defined variables that read user input and…
ace7
  • 71
  • 1
  • 2
  • 6
-1
votes
1 answer

UCanAccess - Mirror Folder files are not being recreated when Access database is changed by another program

Mirror Folder files are not being recreated when Access database is changed by another program. The below is my connection string: jdbc:ucanaccess://E:\db\CostData.accdb;memory=false;keepMirror=C:\Users\Nader…
Youssef
  • 1
-1
votes
2 answers

when we create table directly from java in ms access,"Null" occurs

when i create table directly from java in ms access,"Null" occurs.What is meant by this
Mcolo
  • 149
  • 2
  • 10
-1
votes
2 answers

parameter marker not allowed (updating Access database)

Statement st = connect.createStatement(); String sql = "update StudentDatabaseS set RollNo = ?, FullName = ?, FatherName = ?, FatherCNIC = ?, DateOfBirth = ?, Class = ?, Address = ?, City = ?, Province = ? where RollNo = '"+Srollno+"'"; ResultSet rs…
Abdul Wahab
  • 99
  • 1
  • 2
  • 11
-1
votes
1 answer

Database query not working in JAVA

I'm editing a library management system in JAVA and I'm having problems with the search functions. Each book has a BookID, Subject, Title, Author, etc and each member has a MemberID, Name, etc. If I select the search to be by Subject, or Title or…
El Dj
  • 385
  • 1
  • 7
  • 22
-1
votes
1 answer

Connecting to an Access database on Tomcat

Trying to put a .mdb file on tomcat and access it. It worked locally, but after trying to deploy it to a local tomcat server it throws an exception. This is the line that is raising an error : Connection dbConnection =…
UserED
  • 33
  • 10
-1
votes
1 answer

UCanAccess UPDATE statement exception: "Unexpected page type 1"

Using Java with MS Access database, adding and selecting data is working just fine, but for some reason I can't update, it keeps throwing an exception net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::3.0.2 Unexpected page type 1 I've never…
Abdullah Asendar
  • 574
  • 1
  • 5
  • 31
-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
  • 302
  • 1
  • 18
-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
  • 873
  • 9
  • 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
  • 53
  • 1
  • 4
-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
1 2 3
…
31
32