FAQ Database Discussion Community


INSERT INTO giving error in Ucanaccess

java,sql,ms-access,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 token: at net.ucanaccess.jdbc.UcanaccessStatement.execute(UcanaccessStatement.java:145) at db.Connect.update(Connect.java:42) at db.GameScanner.searchGames(GameScanner.java:99) at db.GameScanner.<init>(GameScanner.java:91) at db.WelcomeGUI.scanButtonActionPerformed(WelcomeGUI.java:143) at...

Ucanaccess connection of my Android app with a huge MS Access database is taking too much heap space on Android device. Any alternatives?

java,android,jdbc,ucanaccess
I am developing an Android app that needs to fetch data from a huge MS Access database of 120MB size. I have written code to establish connectivity and execute a simple query on the database. I run the same java code on my laptop and my Android device.Here's the code:...

DELETE Function in UcanAccess throws strange exception

java,sql,delete,ucanaccess
Since the elimination of the JDBC bridge from Java 1.8 (which we still mourn) and the move to UcanAccess, I've been debugging SQL code that in the past never gave me any issues.. One of the statements are: DELETE TreatmentRecords.DateGiven, TreatmentRecords.TimeGiven, SInformation.Surname, SInformation.FirstNames, TreatmentRecords.Diagnosis, TreatmentRecords.* FROM SInformation INNER JOIN TreatmentRecords...

Image to ByteArray to BLOB and BLOB to ByteArray to Image Conversion Issues in Java

java,image,bytearray,blob,ucanaccess
After a lot of learning on ByteArrays & BLOBS, I managed to write the below Java code to write an image into Access DB (Using ucanaccess) and writing it back to Disk. When I write an image back to disk the image is in incorrect format or something is messed...

Warning: Looking for usage map at page 1774, but page type is 1 in UCanAccess

java,ms-access,ucanaccess
When trying to run a program that interfaces with Access 2010 it throws the error WARNING:Looking for usage map at page 1774, but page type is 1 and then proceeds to throw errors about user lacks privilege to access the table I'm trying to use. This program seems to work...

Java: ucanaccess hsqldb java.lang.NoSuchMethodError:

java,eclipse,hsqldb,ucanaccess
I downloaded and installed the uCanAccess jars by following instructions from here: Manipulating an Access database from Java without ODBC I'm learning how to use the microsoft access db for java and this is the coding I used package Main.Net; import java.sql.*; public class DataBase { Connection con; Statement st;...

java sql exception parameter not set

java,jdbc,parameters,sqlexception,ucanaccess
I am trying to get data from a database in a table with 2 where parameters, When i try to execute this code it gives the error: Parameter not set. I think it is a small mistake but I can't find it. The problem could be with the 2 where...

netBeans and ucanacces sql exception only calling db from code

java,database,sqlexception,netbeans-8,ucanaccess
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 jdbc:ucanaccess://C:\Users\sample.mdb at java.sql.DriverManager.getConnection(DriverManager.java:689) at java.sql.DriverManager.getConnection(DriverManager.java:270) at sampleProject.TestDBConnection.main(TestDBConnection.java:16) Here's my code: package sample; import...

User lacks privilege or Object not found error for saved query

java,jdbc,ucanaccess
With Java 8 not supporting JDBC I'm attempting to modify my program so it can still pull and modify data from a Microsoft Access database. It keeps throwing an SQLException. Currently this is what my code looks like for opening a connection to the database and getting to the query:...