Hi All, I am working on a solution that requires me to extract the Macros specific VBA code from the MS access source file and copy the same into excel files. Does Ucanaccess and jackcess library support the same? Is there any getMacros method supported by the database object created with jackcess ? Thanks, SB
I am having difficulty creating a table in ms access via UcanAccessDriver 5.0.1. I keep getting the error: SqlSyntaxErrorException: user lacks privilege or object not found: IF. Pls, help
UCanAccess Release v5.1.1 has been released and will be available via Maven Central
I have moved to Java 11 as the minimum required Java version to take advantage of new features, optimizations, and security enhancements introduced in Java 11 LTS, which will ultimately contribute to a more robust and maintainable codebase. Maintaining support for multiple target run-time Java versions in parallel is unfortunately out of scope for me.
I will be switching SchemaCrawler to your new distribution.
Markus, thanks for taking over the project. Please could you keep it at a Java 8 level to be compatible with other software? Surprisingly, Java 8 is still being used in production by many companies, since the extended support date is until 2030.
Dear all, UCanAccess was originally developed by Marco Amadei, Gord Thompson and others and hosted at Sourceforge until version 5.0.1 when development ceased in 2020 and activity on the project sadly died down. UCanAccess is a very useful piece of software. It would be a shame to see it disappear. As for myself, I have contributed to UCanAccess in the past and continue to use it to the present day. I have reached out to my fellow developers but could not reestablish contact. Therefore, I have forked...
Exception while expanding UCA connection on a NETBIOS access network folder UCAExc:::5.0.1 newPosition < 0: (-3776 < 0) newPosition < 0: (-3776 < 0) newPosition < 0: (-3776 < 0)I used to work on that file without a problem via Eclipse IDE (2023-09) Java Developers for several days, almost a week DBeaver Release: 23.2.4.202311051706 Operating System: Windows 10 Pro Version: 2023-09 (4.29.0) Build id: 20230907-1323 Do you think this is a crash related to DBeaver or the Driver
I'm glad it fixed your problem partially 😊 But regarding your NullPointerException I am not able to reproduce that error (everything works fine). When I walk with the debugger into the HSQLDB TransactionManager class, I get the following stack trace: at java.base/java.lang.Thread.dumpStack(Thread.java:2209) at java.base/java.util.concurrent.atomic.AtomicLong.get(AtomicLong.java:104) at org.hsqldb.TransactionManager2PL.getSystemChangeNumber(Unknown Source) at org.hsqldb.Session.executeCompiledStatement(Unknown...
Thanks @Alexander. This does fix the user privilege issue. We've encountered what seems like a more underlying issue when sending UPDATE or DELETE statements to net.ucanaccess.jdbc.UcanaccessStatement.executeBatch(): java.lang.NullPointerException: Cannot invoke "jdbc.ucanaccess.shaded.org.hsqldb.Statement.getTableNamesForRead()" because "<parameter1>.sessionContext.currentStatement" is null at jdbc.ucanaccess.shaded.org.hsqldb.TransactionManagerCommon.endActionTPL(Unknown Source) at jdbc.ucanaccess.shaded.org.hsqldb.TransactionManager2PL.completeActions(Unknown...
I also updated my HSQLDB library to v2.7.1 due to CVE-2022-41853. However, when the HsqlException occurs, you can solve that issue by setting the following system property (before establishing the database connection): System.setProperty("hsqldb.method_class_names", "net.ucanaccess.converters.*"); // see http://hsqldb.org/doc/2.0/guide/sqlroutines-chapt.html#src_jrt_access_control Hope, this helps :-)
thanks,i get it.
The boolean returned has a completely different meaning, it's true if it is a ResultSet, false if it isn't, see jdbc javadoc
ucanaccess:5.0.1 hsqldb:2.5.0 jackcess:3.0.1 system:ubuntu 16.04 the code belows: conn = DriverManager.getConnection(url); stmt = conn.createStatement(); String sql = "CREATE TABLE PICINDEX(" + "IDX AUTOINCREMENT PRIMARY KEY," + "POLEID Text," + "SETLOC Text," + "KM integer," + "ST Text," + "TUNNEL Text," + "DETECTDATE Text," + "MDirection Text," + "SPEED float," + "CAMERNO Text," + "PATH Text," + "POLENUM Text," + "FRONT integer," + "BACK integer," + "FILEPRE Text," + "AllReadState Text," + "CorrectState...
Hello guys, I'll explain the situation to you. I have a table in an access database that contains a field of type attachments, and I cannot update that field, specifically I am trying to add a new text file to an already saved record. This is the code I am using: public void AddFile(int id, File file) { try { Attachment newFile = ConvertToAttachment(file); try { Conexion conect1 = new Conexion(dbName); Connection con1 = conect1.getConnection(); String sql = "UPDATE Alineador SET [Campo2] = ? WHERE...
Hi Gord, Is the mentioned formats are implemented in the latest version? Please let me know the status on the different unique date formatting implementation.
We have run into this as well; is it likely that a new UCanAccess release will be issued to address this?
This is occurring for me when I change my HSQLDB dependency from 2.5.1 to 2.7.1 - I need to do this becuase of CVEs on the older version. Here's the error I get when I make a connection: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: net.ucanaccess.converters.Functions at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown...
When I try to open an mdb file, I get the error unexpected token: DOUBLE required: FOR The forum says this is a known HSQLDB bug and has been fixed in HSQLDB 2.5.1. https://stackoverflow.com/questions/65074428/cant-connect-to-ms-access-mdb-file-using-dbeaver-and-the-default-ucanaccess-5-0/66121983#66121983 Could you rebuild the ucanaccess library with the latest version of the HSQLDB library or at least 2.5.1 and put it on https://mvnrepository.com
This was originally asked at stackoverflow according to the instructions on https://ucanaccess.sourceforge.net/site.html#about but never got answered. I am trying here. The standard behaviour of SQL is to require all non-aggregated columns appearing in the SELECT clause (or HAVING or ORDER BY) to appear in the GROUP BY clause. For example the following would fail (because of b not being aggregated and not appearing in the GROUP BY clause): SELECT a, b, COUNT(*) FROM t GROUP BY a Access will give...
This was originally asked at stackoverflow according to the instructions on https://ucanaccess.sourceforge.net/site.html#about but never got answered. I am trying here. It appears that UCanAccess does not complain when a column name appearing in the SELECT clause, WHERE clause, etc. is ambiguous. Instead, it seems that the first table in the FROM clause that has a column with that name is used. This is a very dangerous behaviour that most other database engines reject. For example Access will respond...
This was originally asked at stackoverflow according to the instructions on https://ucanaccess.sourceforge.net/site.html#about but never got answered. I am trying here. There seems to be a bug or at least an unexpected behaviour when using the UCanAccess JDBC-driver. Is there an explanation or is it just a bug that should be fixed? Here is a simple example: ResultSet rs = statement.executeQuery("SELECT name, name n, name as n2 FROM Person"); ResultSetMetaData metaData = rs.getMetaData(); System.out.println(metaData.getColumnLabel(1));...
OK, Never Mind. This turned out to be either a problem with a mixture of different versions of a few other jars in my project as (possibly and) a probably corrupted (missing spaces, or something) Class-Path in the manifest
java.lang.ClassNotFoundException: com.healthmarketscience.jackcess.util.ErrorHandler at java.net.URLClassLoader.findClass(URLClassLoader.java:387) at java.lang.ClassLoader.loadClass(ClassLoader.java:419) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:365) at java.lang.ClassLoader.loadClass(ClassLoader.java:352) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:264) at desktop.server.db.ConnectionManager.startConnectionKOMP(ConnectionManager.java:300) ......
Hi, I try to use UCanAccess in my Tomcat software. I use: Eclips IDE Version: 2022-12 (4.26.0) jre-8u361-windows-x64 apache-tomcat-10.1.6 an Access2000 DB ucanaccess-5.0.1.jar jackcess-3.0.1.jar hsqldb-2.5.0.jar commons-lang3-3.8.1.jar jackcess-encrypt3.0.1.jar I run this code: Connection con_test; try { Class.forName("net.ucanaccess.jdbc.UcanaccessDriver"); String DATABASE_URL = "jdbc:ucanaccess://C:/Users/Myself/eclipse-workspace/Testit/DB/TestDB.mdb"; System.out.println(DATABASE_URL); con_test...
Hi, I try to use UCanAccess in my Tomcat software. I use: Eclips IDE Version: 2022-12 (4.26.0) jre-8u361-windows-x64 apache-tomcat-10.1.6 an Access2000 DB ucanaccess-5.0.1.jar jackcess-3.0.1.jar hsqldb-2.5.0.jar commons-lang3-3.8.1.jar jackcess-encrypt3.0.1.jar I run this code: Connection con_test; try { Class.forName("net.ucanaccess.jdbc.UcanaccessDriver"); String DATABASE_URL = "jdbc:ucanaccess://C:/Users/Myself/eclipse-workspace/Testit/DB/TestDB.mdb"; System.out.println(DATABASE_URL); con_test...
I go ta customer database today which contained a table without columns. That's bad enough as it is and should be fixed of course. The problem I faced with UCanAccess was, that I could not even open a SQL connection to this DB, it would abort even if I didn't access this table. When opening a SQL connection, I got this error: "UCAExc:::5.0.1 needs column or cannot drop sole column of table" The table in question is called "dbo_ST_SACHBEARBEITER", I removed most of the rest. The error should only...
Too bad :( We do not have software developers for the coding of that Uhm, excuse me if I'm being rude, but you don't need a dev to do this. LoL
Too bad :( We do not have software developers for the coding of that.
When using SQuirrel to connect to an encrypted access database, you have to follow the following steps: 1) Neccessary Libraries: Download the following Libraries: ucanaccess-5.0.1.jar jackcess-4.0.2.jar hsqldb-2.7.0.jar commons-lang3-3.12.0.jar ... and to use the encryption feature also these libs: bcprov-jdk15on-1.70.jar jackcess-encrypt-4.0.1.jar Place them in your drivers folder, e.g. C:\Program Files\Squirrel\drivers 2) Compile your Crypt Codec Opener: Create a file CryptCodecOpener.java (e.g....
It is a password-protected DB. We connect through UcanAccess from Squirrel SQL. It is not clear how to connect. Are you able to point us in the right direction, i.e. a link to documentation that shows how to write a connection string? Or is it something that Squirrel SQL developer has to implement?
It's likely a encrypted database, isn't it? If so, see how to use the jackcessOpener parameter on the ucanaccess web site. Il Mer 21 Set 2022, 22:22 amwfc amwfc@users.sourceforge.net ha scritto: We are kind of dead in the water, due to the above error. Any tips on resolving it? What does this error mean, and how can I fix it? https://sourceforge.net/p/ucanaccess/discussion/help/thread/26a88b070b/?limit=25#7741 Sent from sourceforge.net because amadei.mar@gmail.com is subscribed to https://sourceforge.net/p/ucanaccess/discussion/help/...
We are kind of dead in the water, due to the above error. Any tips on resolving it?
Unexpected Error occurred attempting to open an SQL connection. class com.healthmarketscience.jackcess.impl.UnsupportedCodecException: Decoding not supported. Please choose a CodecProvider which supports reading the current database encoding.
Thank you Fred, I didn't treat PERIOD as keyword, next version will fix it for better compatibility.
One of the tables has a column named PERIOD. This is treated by the particular version of HSQLDB bundled with UCanAccess as an SQL keyword, rather than the name of the column and an error is raised when the next token is not what it expects. You can probably use the latest versions of HSQLDB which avoids this issue, instead of the bundled version (in the /lib directory). Alternatively, change the name of the column in the Access database.
My project is updating to ColdFusion 2018 and uses Hibernate and obviously has Access databases (planning to migrate to SQL in the future). We have installed the UCanAccess driver and configured our data sources in the ColdFusion Administrator to use the driver. Now we need to get the UCanAccess dialect working. No one in the group has Java development experience so we are learning as we go. We have compiled the UCanAccessDialect.java file but where do we go from here? We created a jar file containing...
Not solved the problem, but have moved the Raspberry Pi on to an ethernet connection and not seen this problem since. Looks like it is likely to be an issue with network connectivity.
I am using ucanaccess 5.0.0 I am finding that after a day or so connected, I get this error. The only way I have found to resolve this is to completely reboot my RPi4. Is there a way to reload the snapshot? ucanaccess_jars = [ "/home/auto/UCanAccess-5.0.0-bin/ucanaccess-5.0.0.jar", "/home/auto/UCanAccess-5.0.0-bin/lib/commons-lang3-3.8.1.jar", "/home/auto/UCanAccess-5.0.0-bin/lib/commons-logging-1.2.jar", "/home/auto/UCanAccess-5.0.0-bin/lib/hsqldb-2.5.0.jar", "/home/auto/UCanAccess-5.0.0-bin/lib/jackcess-3.0.1.jar",...
Hello, When trying to open this MS Access file (file too large to share on forum), we're getting the following exception: net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::5.0.0 unexpected token: VARCHAR required: FOR at net.ucanaccess.jdbc.UcanaccessDriver.connect(UcanaccessDriver.java:231) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:208) at Runner.testOpenProblemAccessFile(Runner.java:20) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native...
UCanAccess 5.0.1 Win10 and Xubuntu 20.04 DBeaver 21.3.3 and LibreOffice 7.2.5.2 OpenJDK 11.0.12+7 (DBeaver), Temurin-11.0.13+8 (LibreOffice) ACE (ODBC) 16.00.4999.1000 (x64), 14.00.7248.5000 (x32) ACE12 DB SELECT [Something], StrComp('A','B',0) FROM [Table] Basic comparison works normally for binary an text modes using characters but not if one of the values is changed to NULL. ACE (using ODBC and LibreOffice Base) returns a null as expected. UCanAccess (DBeaver and LibreOffice using JDBC) returns...
I'm seeing something similar with an IIF (… IS NULL) statement of the form: VAL( IIF( VARCHAR IS NULL, '0', VARCHAR) * IIF( DOUBLE IS NULL, 0, DOUBLE) If the double precision value is between 0 and 1 then the result is 0 which is wrong.
I'm seeing something similar with an IFF (… IS NULL) statement of the form: VAL( IFF( VARCHAR IS NULL, '0', VARCHAR) * IFF( DOUBLE IS NULL, 0, DOUBLE) If the double precision value is between 0 and 1 then the result is 0 which is wrong.
UCanAccess 5.0.1 Win10 and Xubuntu 20.04 DBeaver 21.2.5 and LibreOffice 7.2.2.2 OpenJDK 11.0.12+7 (DBeaver), Temurin-11.0.13+8 (LibreOffice) ACE12 DB SELECT (something), NZ (constants), FROM (whatever) NZ(1, 0) = 1 NZ(1) = 1 NZ(0.1, 0) = 0.1 NZ(0.1) = 0 <<< WAT? Encountered this with a query that was checking a double-precision column value. Result was as expected unless the value was less than 1 and the optional null return value wasn't specified.
Hello, I was able to force my 32-bit version of java by copying the script and hard-coding the path. Here is what the console outputted: java version "1.8.0_301" Java(TM) SE Runtime Environment (build 1.8.0_301-b25) Java HotSpot(TM) 64-Bit Server VM (build 25.301-b25, mixed mode) Please, enter the full path to the access file (.mdb or .accdb): H:\Tools\Access Databases\indexhistories.accdb Error occured at the first loading attempt of GetLiquidUnderlyings Converted view was :CREATE VIEW GETLIQUIDUNDERLYINGS...
All tables used in the Access query are local tables.
In a ColdFusion web application, i have a Select query query : "Select * from OpenRequests" OpenRequest is a saved query. I am getting the same error "user lacks privileges or object not found" Does anyone knows how to use saved queries in Access from a ColdFusion app? Any help will be appreciated
I got a similar problem. In the website says that ucanaccess supports running I am trying to run a saved query in Access but got the same error "User lacks privilege or object not found". All tables used in query are local to the database file. Can ucanAccess use saved queries or not? if so how? in the sourceforge page it says "You can execute Select queries defined and saved in Access." Can you show me how to do this?
The console keeps defaultint to the 64-bit version for some reason. I have both on my machine. I think that's what's causing the console.bat to not work properly. java version "1.8.0_301" Java(TM) SE Runtime Environment (build 1.8.0_301-b25) Java HotSpot(TM) 64-Bit Server VM (build 25.301-b25, mixed mode) Please, enter the full path to the access file (.mdb or .accdb): H:\Tools\Access Databases\indexhistories.accdb java.io.IOException: Unrecognized map type: -1 at com.healthmarketscience.jackcess.impl.UsageMap.initHandler(UsageMap.java:150)...
If you try to use the console.bat (in the distribution) to open the file what do you see? Could you send the console output? Il giorno lun 25 ott 2021 alle ore 13:56 Lon Parisi lonparisi@users.sourceforge.net ha scritto: Hello, I have written to this forum before but have not been able to resolve the connection time being SO long. My MS Access database is currently about 54M. It takes well over 4 minutes to create a connection. There is a slow amount of growth to this database and the connection...
Hello, I have written to this forum before but have not been able to resolve the connection time being SO long. My MS Access database is currently about 54M. It takes well over 4 minutes to create a connection. There is a slow amount of growth to this database and the connection time has risen with the size. I have no external links in the database. All the data is contained within the MS Access database. There doesn't seem to be anything wrong with the database itself (but of course it may be hard...
And when i commented Class.forName ("net.ucanaccess.jdbc.UcanaccessDriver"); it gives the error No suitable driver found for jdbc: ucanaccess: //storage/emulated/0/Android/data/accessdb/TestDB.accdb! I really do not know what the problem is!
Hi, when I use version 5.0.1 in Android, it gives NoClassDefFoundError exception, but version 4.0.4 works properly. What is the problem and how can I use version 5.0.1 on Android?
Hello, I am reaching a heap size limit but it's at a very strange part of the code. In general, I compute a number of data points (the amount of data is not the issue). When I go to set the auto commit on the connection to false, it hangs and eventually crashes. Here is the stack trace: Exception in thread "main" java.lang.OutOfMemoryError: Java heap space at java.util.LinkedHashMap.newNode(Unknown Source) at java.util.HashMap.putVal(Unknown Source) at java.util.HashMap.put(Unknown Source) at com.healthmarketscience.jackcess.impl.ColumnImpl.setRowValue(ColumnImpl.java:560)...
Hi, I also have this problem, what is the problem with permissions? Does version 5.0.1 require permissions?
It is not our game, but you should setAutocommit(false) at the start, and then commit just each 1000-2000 records... performance will improve dramatically... or much better, do it all directly with jackcess. Il Gio 23 Set 2021, 20:09 Steven Rubin strubin9@users.sourceforge.net ha scritto: I am trying to build a large table (105 columns and over a million rows). Using Access, I can use Import / External Data and then give it a big text file (tab separated). It takes barely any time at all. Now I want...
I am trying to build a large table (105 columns and over a million rows). Using Access, I can use Import / External Data and then give it a big text file (tab separated). It takes barely any time at all. Now I want to do it from Java, so I looked at UCanAccess. First, I tried calls to execute() with INSERT statements, but that took a minute for every thousand rows, which means it would take 17 hours. Next, I tried using prepareStatement() and that halved the time, but still would need 8 hours. Is...
Cool thanks!
Ok. It will be fixed in the 6.0.0 Il Ven 10 Set 2021, 14:08 Sproketboy sproketboy@users.sourceforge.net ha scritto: Hi I'm using 5.0.1 with hsqldb 2.5.1 Column name incorrect after create table. https://sourceforge.net/p/ucanaccess/discussion/general/thread/52ae8bb570/?limit=25#72b7/2875/cb65 Sent from sourceforge.net because amadei.mar@gmail.com is subscribed to https://sourceforge.net/p/ucanaccess/discussion/general/ To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/ucanaccess/admin/discussion/forums....
Hi I'm using 5.0.1 with hsqldb 2.5.1
Which version are you using? Il Ven 10 Set 2021, 11:49 Sproketboy sproketboy@users.sourceforge.net ha scritto: CREATE TABLE Customers ( [Customer ID] varchar(10) PRIMARY KEY NOT NULL, [Company Name] VARCHAR(30) NULL, [Contact Name] VARCHAR(30) NULL, [Contact Title] VARCHAR(10) NULL, [Address] VARCHAR(40) NULL, [City] VARCHAR(30) NULL, [Region] VARCHAR(10) NULL, [Postal Code] VARCHAR(10) NULL, [Country] VARCHAR(2) DEFAULT 'US', [Phone] VARCHAR(30) NULL, [Fax] VARCHAR(30) NULL, [Status] CHAR(1) NULL,...
CREATE TABLE Customers ( [Customer ID] varchar(10) PRIMARY KEY NOT NULL, [Company Name] VARCHAR(30) NULL, [Contact Name] VARCHAR(30) NULL, [Contact Title] VARCHAR(10) NULL, [Address] VARCHAR(40) NULL, [City] VARCHAR(30) NULL, [Region] VARCHAR(10) NULL, [Postal Code] VARCHAR(10) NULL, [Country] VARCHAR(2) DEFAULT 'US', [Phone] VARCHAR(30) NULL, [Fax] VARCHAR(30) NULL, [Status] CHAR(1) NULL, [Date Registered] Timestamp DEFAULT NOW(), [Date Of Last Order] DATE, [Test Local Date] date, [Test Local DateTime]...
No, they were unknown errors, but I'll verify the bugs ASAP and let you know here when the fixes will be released.
No, they were unknown errors, but I'll verify the bugs and let you know here when the fixes will be released.
Hello. I'm using an internet translation, so sorry if it's hard to understand. When I perform the following operations, the HSQLDB in memory is not deleted and remains. Set memory=true and password=password to the connection URL, and use UcanAccessDriver#connect to connect to the accdb file with no password set. The connection succeeds. With the HSQLDB in memory, connect to the accdb file connected in step 1 again with the password unset. The connection will fail and the following Exception will...
Hello. I wrote the title in Japanese by mistake. The correct title is as follows. DBReference constructor and DBReference#open have different behavior. I'm using an internet translation, so sorry if it's hard to understand. The DBReference constructor that works when UcanaccessDriver#connectis called for the first time and DBReference#open that is called when it has already been loaded are handled differently. 1. set value of Database#setLinkResolver 2. set value of Database#setDateTimeType I believe...
Hello. I wrote the title in Japanese by mistake. The correct title is as follows. DBReference constructor and DBReference#open have different behavior. I'm using an internet translation, so sorry if it's hard to understand. The DBReference constructor that works when UcanaccessDriver#connectis called for the first time and DBReference#open that is called when it has already been loaded are handled differently. 1. set value of Database#setLinkResolver 2. set value of Database#setDateTimeType I believe...
Hello. I'm using an internet translation, so sorry if it's hard to understand. The DBReference constructor that works when UcanaccessDriver#connectis called for the first time and DBReference#open that is called when it has already been loaded are handled differently. 1. set value of Database#setLinkResolver 2. set value of Database#setDateTimeType I believe this causes different behavior when dealing with the link table between the first connection and reloading. Do you have any plans to make this...
Hello. I'm using an internet translation, so sorry if it's hard to understand. When I perform the following operations, the HSQLDB in memory is not deleted and remains. Set memory=true and password=password to the connection URL, and use UcanAccessDriver#connect to connect to the accdb file with no password set. The connection succeeds. With the HSQLDB in memory, connect to the accdb file connected in step 1 again with the password unset. The connection will fail and the following Exception will...
Edit: Sorry, fixed this one... was due to permissions issue... sorry again :)
Edit: Sorry, fixed this one... was due to permissions issue... sorry again :) oh and seems like facing a new issue. The unaccess complains about the file not existing. However, it does exist at the path provided. This is how i am checking if the file exists or not. final String root = the path to the file.... final File file = new File(root); System.out.println(file.exists()) The log says true tho.
oh and seems like facing a new issue. The unaccess complains about the file not existing. However, it does exist at the path provided. This is how i am checking if the file exists or not. final String root = the path to the file.... final File file = new File(root); System.out.println(file.exists()) The log says true tho.
Ah yup, that sort of worked... However, I am a bit confused, cause I tried ucanaccess with JDK 16, 11, as well as 1.8 (Java 8)... but the error remained. However, downgrading it worked.
Try with the previous 4.x.x ucanaccess (downgrading the dependencies too), it may depend on the jdk version supported Il Mar 31 Ago 2021, 10:36 Shehar Yar Khan sheharyar566@users.sourceforge.net ha scritto: Hi there, I was trying to add ucanaccess to an android project (an empty project with no dependencies). For the purpose, I added the ucanaccess jar along with the dependency jars in the libs folder and added them in the dependecies section of app/build.gradle as: dependencies { implementation...
Hi there, I was trying to add ucanaccess to an android project (an empty project with no dependencies). For the purpose, I added the ucanaccess jar along with the dependency jars in the libs folder and added them in the dependecies section of app/build.gradle as: dependencies { implementation files('libs/ucanaccess-5.0.1.jar') implementation files('libs/jackcess-3.0.1.jar') implementation files('libs/hsqldb-2.5.0.jar') implementation files('libs/commons-lang3-3.8.1.jar') implementation files('libs/commons-logging-1.2.jar')...
Hi there, I was trying to add ucanaccess to an android project (an empty project with no dependencies). For the purpose, I added the ucanaccess jar along with the dependency jars in the libs folder and added them in the dependecies section of app/build.gradle as: dependencies { implementation files('libs/ucanaccess-5.0.1.jar') implementation files('libs/jackcess-3.0.1.jar') implementation files('libs/hsqldb-2.5.0.jar') implementation files('libs/commons-lang3-3.8.1.jar') implementation files('libs/commons-logging-1.2.jar')...
Will look into, have you already tried directly with jackcess? Il Gio 26 Ago 2021, 21:04 Jefferson Poe jeffersonatsafe@users.sourceforge.net ha scritto: UCanAccess version: 5.0.0 JDK: 8 and 11 (tested on both) Steps to repro: 1. create a new table that has a "Currency" type column: CREATE TABLE mytable1(IDcounter PRIMARY KEY,currencycurrency) 2. read the schema of the table using ResultSetMetadata of the following statement: SELECT * FROMmytable1WHERE 1=0 3. inspect the precision and display width...
UCanAccess version: 5.0.0 JDK: 8 and 11 (tested on both) Steps to repro: 1. create a new table that has a "Currency" type column: CREATE TABLE mytable1 (myID counter PRIMARY KEY, myCurrency currency) 2. read the schema of the table using ResultSetMetadata of the following statement: SELECT * FROM mytable1 WHERE 1=0 3. inspect the precision and display width of the "Currency" column Result: Sometimes, the created column will have precision = 8, and display size = 10 Other times, the created column...
UCanAccess version: 5.0.0 JDK: 8 and 11 (tested on both) Steps to repro: 1. create a new table that has a "Currency" type column: CREATE TABLE mytable1 (myID counter PRIMARY KEY, myCurrency currency) 2. read the schema of the table using ResultSetMetadata of the following statement: SELECT * FROM mytable1 WHERE 1=0 3. inspect the precision and display width of the "Currency" column Result: Sometimes, the created column will have precision = 8, and display size = 10 Other times, the created column...
UCanAccess version: 5.0.0 JDK: 8 and 11 (tested on both) Steps to repro: 1. create a new table that has a "Currency" type column: CREATE TABLE mytable1 (myID counter PRIMARY KEY, myCurrency currency) 2. read the schema of the table using ResultSetMetadata of the following statement: SELECT * FROM mytable1 WHERE 1=0 3. inspect the precision and display width of the "Currency" column Result: Sometimes, the created column will have precision = 8, and display size = 10 Other times, the created column...
UCanAccess version: 5.0.0 JDK: 8 and 11 (tested on both) Steps to repro: 1. create a new table that has a "Currency" type column: CREATE TABLE mytable1 (ID counter PRIMARY KEY, currency currency) 2. read the schema of the table using ResultSetMetadata of the following statement: SELECT * FROM mytable1 WHERE 1=0 3. inspect the precision and display width of the "Currency" column Result: Sometimes, the created column will have precision = 8, and display size = 10 Other times, the created column will...
UCanAccess version: 5.0.0 JDK: 8 and 11 (tested on both) Steps to repro: 1. create a new table that has a "Currency" type column: CREATE TABLEmytable1(IDcounter PRIMARY KEY,currencycurrency) 2. read the schema of the table using ResultSetMetadata of the following statement: SELECT * FROMmytable1WHERE 1=0 3. inspect the precision and display width of the "Currency" column Result: Sometimes, the created column will have precision = 8, and display size = 10 Other times, the created column will have...
Hey @gordonthompson, was this feature ever added to UCanAccess to read ODBC Linked tables directly via driver? I am trying to connect to a legacy system which only support ODBC via Java. Since there is no longer a direct ODBC support for Java, I was doing a work around to link the ODVC source to MS Access via a live link and read using MS Access. I stumbled upon the issue that UCanAccess is limited to reading linked tables. Also if this is not on roadmap, can you recommend if there is a way to refresh...
I have been experiencing an issue with a connection being closed...or at least that's what I'm being told in the stack trace. It seems very random. In addition, when I check the connection directly if it is null or closed (boolean isclosed = conn.isClosed()) neither one is the case. I don't have any idea how to reproduce this because as discussed its very random. Could it be some sort of networking issue that puts the connection in an unstable state? Any help here would be greatly appreciated. Below...
I'm using UCanAccess 5.0.0 with Lucee 5.3.3.62. Everything seems to be running well, for the most part, however I'm running into an issue in my test environment where if I add a record to a table and then overwrite the MDB file with a clean file, UCanAccess still pulls up the added record. I can fix this by either opening the MDB file in Access or by restarting Lucee. This is somewhat manageable in a dev environment, but Access is not running on the server, and restarting all sites when one site...
I am having the same problem as Enshuo Hsu (2015-07-25) re: no suitable driver for an Access 2007 legacy database. I checked my code - ok. I followed his suggested solution by placing the 5 jar files in each of the following folders and testing the app. - the src folder, the build folder, my project folder, the JDK12 folder, the bin folder and the lib folder. Nothing changes. I am totally lost as to what to do next. I might add that I am new to java, but have taught programming (VB6) many years ago....
I am having the same problem as Enshuo Hsu (2015-07-25) re: no suitable driver for an Access 2007 legacy database. I checked my code - ok. I have tried placing the 5 jar files in each of the library, the src folder, the build folder, my project folder, the JDK12 folder, the bin folder and the lib folder. Nothing changes. I am totally lost as to what to do next. I might add that I am new to java, but have taught programming (VB6) many years ago. I am trying to rewrite a VB6 app that is failing owing...
A zero ceremony ORM for Java Nice statement ;-) Il Ven 23 Apr 2021, 21:44 marco amadei amadei.mar@gmail.com ha scritto: Ok, thanks. No issue. Il Ven 23 Apr 2021, 21:17 Sproketboy sproketboy@users.sourceforge.net ha scritto: Hi Marco. My fault. I also use HSQLDB for my project ( https://sproket.github.io/Persism/) - I just need to use the same version you do for my unit tests - then it worked fine. Attachment not found in import statement https://sourceforge.net/p/ucanaccess/discussion/general/thread/8fee018493/?limit=25#a037...
Ok, thanks. No issue. Il Ven 23 Apr 2021, 21:17 Sproketboy sproketboy@users.sourceforge.net ha scritto: Hi Marco. My fault. I also use HSQLDB for my project ( https://sproket.github.io/Persism/) - I just need to use the same version you do for my unit tests - then it worked fine. Attachment not found in import statement https://sourceforge.net/p/ucanaccess/discussion/general/thread/8fee018493/?limit=25#a037 Sent from sourceforge.net because amadei.mar@gmail.com is subscribed to https://sourceforge.net/p/ucanaccess/discussion/general/...