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

Java JTable Exported to Existing MS Access Table

I scoured the web and found nothing for this. I have a group of records in a JTable and I need to export these records to an existing table in an MS Access database. I need to be able to append records to this table as there may already be data…
Pete Hahn
  • 21
  • 6
0
votes
2 answers

INSERT INTO giving error in Ucanaccess

I am trying to insert a row into a table (userGames), using Ucanaccess, and, when executing the statement, am recieving the following error: Feb 10, 2015 8:29:02 PM db.Connect update SEVERE: null net.ucanaccess.jdbc.UcanaccessSQLException: unknown…
Riccorbypro
  • 143
  • 2
  • 8
0
votes
1 answer

How to fix table in Access DB connect throught Java 8?

I have this code to connect to Access Database with UCanAcess library. public Visualizzazioni_Access() { try { log=new MyLog4J(); File dbFile = new File("CassaGestionale.accdb"); String path =…
bircastri
  • 2,169
  • 13
  • 50
  • 119
0
votes
4 answers

sql query to get data by date and time

I want to get the rows where date and time are greater then given date. Here is my table: EvDate EvTime ClBdg Name Event 18.01.2015 10:55:01 001 Jane enter 18.01.2015 19:31:21 003 Brad exit 19.01.2015 13:31:21 …
LeXuS
  • 19
  • 2
  • 8
0
votes
1 answer

Unexpected Token: AS (Using UCanAcces.jar)

I can't find the mistake, I get this error: Error: net.ucanaccess.jdbc.UcanaccessSQLException: unexpected token: = required: AS This is my code. Can you help me find it? Thanks in advance. package database; // Imports import java.sql.*; public…
Benjamin Naesen
  • 174
  • 1
  • 10
0
votes
1 answer

Testing UCanAccess with Oracle SQL Developer -> ODBC error

Quite exciting to find this jdbc driver for ms access. However, when I try to test it with Oracle SQL Developer, I got: Status : Failure -Test failed: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver…
wez
  • 337
  • 3
  • 16
0
votes
0 answers

ClassNotFound Exception for jdbc "uncanaccess" path setting for MS Access

I am writing a very simple code to connect MS Access database to my java program using netBeans. The driver ucanaccess and MS access file is placed in the very same folder. Kindly guide me through it. public static void main(String[] args) { …
Saim Mehmood
  • 783
  • 8
  • 14
0
votes
2 answers

Same SQl query runs in access but failed in sql script in access using java

when i run the query in database the following query works INSERT INTO `M_DT_SaveAndClose` (`StoryName`, `Assignee`, `Createddate`, `CreatedBy`) VALUES (' DT_0019_BGL_2014_11_01_AM_01_MN_01_11_2014_12_07_06_281_000772.xml ', ' T0003SathyabamaT…
Dhinakar
  • 4,061
  • 6
  • 36
  • 68
0
votes
3 answers

"Reserved Error (-5001) and there is no reason for this error" during table creation in access database using java

i need to create a table in access database and for that i used the following code. It is creating table but it throws error like "Reserved Error (-5001) and there is no reason for this error" when the table is clicked. My code: public class…
Dhinakar
  • 4,061
  • 6
  • 36
  • 68
0
votes
1 answer

Solr dataimport and SQL with xml escape

I tried the following SQL in entity tag of dataimport config file:
SaidbakR
  • 13,303
  • 20
  • 101
  • 195
0
votes
0 answers

Solr some mdb files are not process as documents in dataimport

I have to import some mdb files to solr. some of mdb files are indexed well as document but there are others don't. I use Solr 4.10.0 and ucanaccess ver. 2.0.9 The follwoing is a screen shot from the log: For some missing fields values (in the…
SaidbakR
  • 13,303
  • 20
  • 101
  • 195
0
votes
1 answer

Solr dataimport change dataSource dynamically

I have done the following settings for dataimport from about 20 mdb files using ucanaccess:
SaidbakR
  • 13,303
  • 20
  • 101
  • 195
0
votes
1 answer

How disable check constraint on connection

java.sql.DriverManager.getConnection("jdbc:ucanaccess:///user/dev/project/project.mdb") I have this error Java::NetUcanaccessJdbc::UcanaccessSQLException: integrity constraint violation: NOT NULL check constraint; SYS_CT_10991 table: EMPLOYE column:…
Phane
  • 201
  • 3
  • 11
0
votes
1 answer

Ucanaccess with java servlet program

Hello i'm trying to connect access database with ucanaccess driver but in the end i get following error Aug 13, 2014 12:41:00 PM org.apache.catalina.core.AprLifecycleListener init INFO: The APR based Apache Tomcat Native library which allows…
user3808015
  • 37
  • 2
  • 8
0
votes
0 answers

UCanAccess error: user lacks privilege or object not found

I am trying to manipulate a MS Access database with java without ODBC and I've tried following the instructions over at Manipulating an Access database from Java without ODBC but I keep on getting the error: Error connecting…
guevarak12
  • 75
  • 1
  • 5
  • 16
1 2 3
…
31 32