UCanAccess Activity
A pure Java JDBC driver for Microsoft Access database files
Brought to you by:
jamadei
Activity for UCanAccess
-
Lon Parisi posted a comment on discussion Help
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...
-
Brian Samuelson posted a comment on discussion Help
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...
-
Phil frankel modified a comment on discussion Help
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...
-
Marco Amadei posted a comment on discussion General Discussion
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/...
-
Sproketboy posted a comment on discussion General Discussion
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.
-
Nothing changed on the Attachment class, I'll try soon but a compile time error should be due to something wrong in your environment set-up. Il Dom 18 Apr 2021, 12:48 Sproketboy sproketboy@users.sourceforge.net ha scritto: No answer? No upgrade path to Java 16 yet? Attachment not found in import statement https://sourceforge.net/p/ucanaccess/discussion/general/thread/8fee018493/?limit=25#cb9c Sent from sourceforge.net because amadei.mar@gmail.com is subscribed to https://sourceforge.net/p/ucanaccess/discussion/general/...
-
No answer? No upgrade path to Java 16 yet?
-
I upgraded to 5.0.1 and now under Java 16 I see import net.ucanaccess.complex.Attachment; fails. It seems to use com.healthmarketscience.jackcess.complex.Attachment now instead?
-
Rexxcoder posted a comment on discussion Help
Hello Marco and UCanAccess Team Members, Recently I started writing application using Java, NetRexx and BSF4ooRexx using the UCanAccess v5.0.1 Jar Archive. I discovered an issue that pertains specifically to ARM architecture based Linux Distros using the OpenJDK 8 Java Environmet and UCanAccess v 5.0.1. I wrote a java program to list the Registered JDBC Drivers in my Open JDK8 $JAVA_HOME/jre/lib/ext directory. Java program is attached for your reference. The result of that run yields the following...
-
Matthew posted a comment on discussion Help
So far it does, but I've not submitted it to regular unit testing (edge cases, etc.). I only need it to support an existing workflow with limited functional use (basically I use Access as a UI to make manual DML changes to other underlying databases, the structures of which are not too complicated).
-
so, do you confirm? Does it work this way? Il Mar 23 Mar 2021, 22:33 Matthew lastfreedom@users.sourceforge.net ha scritto: Hopefully the following will be of use for future visitors, it turns out I was using the Number data type, sub-specifying the 'Long Integer' form for the field size (when defining a field in MS Access). Turns out the correct data type to use is 'Large Number' instead of Number. Access Long Number support? https://sourceforge.net/p/ucanaccess/discussion/help/thread/e724c7235e/?limit=25#18a3/1d40...
-
Hopefully the following will be of use for future visitors, it turns out I was using the Number data type, sub-specifying the 'Long Integer' form for the field size (when defining a field in MS Access). Turns out the correct data type to use is 'Large Number' instead of Number.
-
Am making some headway having updated the attached. However, somewhere an int is getting into the mix as when storing Integer.MAX_VALUE + 1, am getting a negative value in the Access field (2's compliment or something).
-
No dear, access(jackcess) integer correspond to java long, access(jackess) int correspond to java short. It's misleading I know, but it's hsqldb (that throws the exception) over constrained not access.
-
Line 90 may be the issue (in addition to or instead of the above)... JACKCESS_TO_HSQLDB_TYPES_MAP.put(DataType.LONG, "INTEGER");
-
The issue appears to be here; net.ucanaccess.converters.TypesMap, specifically this... ACCESS_TO_HSQL_TYPES_MAP.put(AccessType.LONG.name(), "INTEGER"); ...on line 54 (version 5.0.1). Why is a long being mapped to an integer?
-
I cannot insert 'long number' (as defined by Access 2016) values into similarly defined fields (for UCanAccess version 5.0.1). Please see my post here; https://sourceforge.net/p/ucanaccess/discussion/help/thread/e724c7235e/
-
UCanAccess version is 5.0.1
-
P.S. Access version is 2016
-
Hello, I have a previously created table (created in Access, not using UCanAccess DDL) with a long field (long integer) declared. When, in Java, I attempt something like this... "insert into atable (thelongfield) values(" + System.currentTimeMillis() + ")" (also get the same problem when I try this... "insert into atable (thelongfield) values(" + Long.valueOf(Integer.MAX_VALUE + 1L).longValue() + ")" ...) ...I get the following stack trace (am using all default settings to get the connection, table...
-
Tom posted a comment on discussion Help
Ah, yes! Very true. I just updated the code to use a PreparedStatement, which added security and also worked around the "hang" problem. Thanks for your help!
-
Hi Tom, The regex java library hangs but the regex expression is correct whereas concatenating the email body to a sql is an antipattern even for security reasons. You should use a PreparedStatement placeholder instead (? and PreparedStatement.setString()). Anyway a workaround will be developed for the 6.0.0. to improve general performance.
-
Hi Tom, The regex java library hangs but the regex expression is correct whereas concatenating the email body to a sql is an antipattern even for security reason. You should use a PreparedStatement placeholder instead (? and PreparedStatement.setString()). Anyway a workaround will be developed for the 6.0.0. to improve general performance.
-
MACHINET Vincent posted a comment on discussion Help
Hi everybody, I have just tested the ucanaccess JDBC Driver from LibreOffice using its JDBC connector capability and the right syntax to access an MS Access database file is : jdbc: ucanaccess:///your_database_folder/your_database_file.accdb (or .mdb) Be careful: There are really three slashes because the prefix URLs is "ucanaccess://" and the beginning of the path on an Unix-like OS is "/", so in my case, "/home/vincent/Bases/test.accdb" where the "Bases" folder is a network share with Read/Write/eXecution...
-
Hello Marco! It should be attached to my initial message. It's called "breaking query.txt". (I see it on the SF discussion post, anyway =))
-
Hi tom, nice to hear from you. May you post along the query string? Il Ven 5 Mar 2021, 14:26 Tom ghaldemar@users.sourceforge.net ha scritto: Hello to all you hard workers on UCanAccess! The MIST project https://github.com/gideon-software/mist continues to gratefully utilize UCanAccess. MIST's job is to import emails into an Access database. However, some of my users have reported that MIST hangs in certain circumstances, notably while trying to import long emails generated via MailChimp. I've traced...
-
Hello to all you hard workers on UCanAccess! The MIST project https://github.com/gideon-software/mist continues to gratefully utilize UCanAccess. MIST's job is to import emails into an Access database. However, some of my users have reported that MIST hangs in certain circumstances, notably while trying to import long emails generated via MailChimp. I've traced the problem to a UCanAccess call. In particular: I [try to] create a PreparedStatement using a UCanAccessConnection: PreparedStatement stmt...
-
Yes but you have to configure jdk 10 in your eclipse project. Il Mer 17 Feb 2021, 16:36 Bob Glover rgg@users.sourceforge.net ha scritto: Follow-up question: When I enter in the Windows cmd line "Java -version" I see 10.0.2 (see attachment). But Eclipse says it's running JRE 1.6. So I am confused. Can I use Ucanaccess or not? Thanks much! Attachments: JAVA VERSION IN CMD LINE.docx https://sourceforge.net/p/ucanaccess/discussion/help/thread/e8f40995c5/bf1d/attachment/JAVA%20VERSION%20IN%20CMD%20LINE.docx...
-
Bob Glover posted a comment on discussion Help
Follow-up question: When I enter in the Windows cmd line "Java -version" I see 10.0.2 (see attachment). But Eclipse says it's running JRE 1.6. So I am confused. Can I use Ucanaccess or not? Thanks much!
-
OK, many thanks!
-
OK, many thanks!
-
Yes, JavaSE 1.6 means java 6. Il Mar 16 Feb 2021, 20:18 Bob Glover rgg@users.sourceforge.net ha scritto: I am using Eclipse 8.0, it says JavaSE 1.6, JRE 1.1. Does this mean Java 6? Unsure if any of these means the version. The dreaded "Error in connection: java.sql.SQLException: No suitable driver" https://sourceforge.net/p/ucanaccess/discussion/help/thread/e8f40995c5/?limit=25#9709 Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/ucanaccess/discussion/help/ To...
-
I am using Eclipse 8.0, it says JavaSE 1.6, JRE 1.1. Does this mean Java 6? Unsure if any of these means the version.
-
Since 5.0.0 UCanAccess requires Java 8 or later to run
-
Simple Java DB connect class (see attachment) has issue with finding driver. Previous to trying Ucanaccess I went the old Windows jdbc route with the same fate. As far as I can tell I see no issues on how I set up both environments so I am puzzled. Using JAVA SE 1.6. Thank you for any help! Bob
-
Yes, that's the commit. Thanks for reporting. Il Mer 10 Feb 2021, 14:33 WFR wfriedl@users.sourceforge.net ha scritto: For anybody else stumbling on this: Issue has been resolved in Version 5.0.1, probably in commit https://sourceforge.net/u/jamadei/ucanaccess/ci/d1bff64c3c8e7dec7d30ef11878fc75faf5ab057/ Reduced INSERT performance in 5.0.0 https://sourceforge.net/p/ucanaccess/discussion/general/thread/e8e18922f3/?limit=25#e5aa Sent from sourceforge.net because amadei.mar@gmail.com is subscribed to...
-
WFR posted a comment on discussion General Discussion
For anybody else stumbling on this: Issue has been resolved in Version 5.0.1, probably in commit https://sourceforge.net/u/jamadei/ucanaccess/ci/d1bff64c3c8e7dec7d30ef11878fc75faf5ab057/
-
Nein dear, I needed something else: the form working. You said it works if you link it to an hsqldb so I needed an Odb that doesn't point to access but to an hsqldb and with the form working as expected.
-
Randy posted a comment on discussion Help
These are the changed odb linked correctly.
-
There are no calls with error on UCanAccess, all work fine there. Please send along another odb linked to HSQLDB and the form working as expected. The error seems to be outside our scope.
-
Thank you I have fixed the jar file loading error. But I'm still left with the problem of the frm subfrm.
-
I'll change it and try again.
-
It's totally wrong and could cause harm!
-
This is closer. It lists the depend http://tahsinabrar.com/open-a-microsoft-access-accdb-file-in-ubuntu/
-
Firstly your LO configuration is wrong : even if it won't solve your problem, please follow the suggestions in this article https://askubuntu.com/questions/187389/is-it-possible-to-open-an-access-2010-database-file-without-using-wine-or-virtua/519571
-
ok, now I can take a look, I'll let you know my findings
-
Really, I have tried everything, I can think of, to get this to work. I have used ucanaccess to open large db with tables in a one-to-many. I have also tried for smaller db with no relationships. I used both Libreoffice and Openoffice. Both in Win10 and Ubuntu. None work with sub-forms. The sub-form is never filtered on the link for master and slave. The access db is the backend (tables only). Ucanaccess will import the relationships if there is any but they still will not work with form/subform....
-
Ingrid posted a comment on discussion Help
Hi, will this get fixed? I still receive this error - also with 5.0.1. Or is there any workaround? Regards - Ingrid
-
Thanks Marco. I'll give it a go for a week or so to see if I can find the problem first. Helps to know it should work. I used the deugger a little in access VB so I'll look into setting one up for LO also.
-
Try to give us something simple to reproduce the problem. If I have an instant I'll give a look into. Il Sab 9 Gen 2021, 20:51 Randy ranc505@users.sourceforge.net ha scritto: Really don't know how to do that and wouldn't know what I was looking for. But! what you are saying is, it should work. I'll keep working on it. Thanks for the quick answer and if I find the problem I'll make a donation to the cause. Form with Subform filter problem https://sourceforge.net/p/ucanaccess/discussion/help/thread/a15f13f49c/?limit=25#2e46...
-
Really don't know how to do that and wouldn't know what I was looking for. But! what you are saying is, it should work. I'll keep working on it. Thanks for the quick answer and if I find the problem I'll make a donation to the cause.
-
You should download UCanAccess code and enable remote debuging from LO so that you could figure out what doesn't work.
-
I used access since 97. Trying to switch to Unbuntu Liebreoffice and I made a simple testdb. I set up Ucanaccess to open it’s table only backend 2007(accdb). I mostly use the gui with some sql and VB. They usually consist of forms with a subform linked with a master and slave field. The subform never filters based on the main form. As I switch records in the main form the subform just shows all the records in the table control. FrmMain “tblWOD” “ID” Int Autovalue with Primary key “date” Date/Time...
-
UCanAccess released /archive/v5_archive/UCanAccess-5.0.0-src.zip
-
-
-
-
-
Marco Amadei committed [8ad682]
Merge /u/jamadei/ucanaccess/ branch master into master
-
Prepare for release 5.0.1
-
Prepare for release 5.0.1
-
Prepare for release
-
Prepare for release
-
Prepare for release
-
Prepare for release
-
Marco Amadei committed [0f5784]
Merge /u/jamadei/ucanaccess/ branch master into master
-
Blob bug in update
-
Blob bug in update
-
Marco Amadei committed [990029]
Merge /u/jamadei/ucanaccess/ branch master into master
-
Blob bug in update
-
Blob bug in update
-
Marco Amadei committed [023ab9]
Merge /u/jamadei/ucanaccess/ branch master into master
-
Blob bug in update
-
Blob bug in update
-
Jefferson Poe posted a comment on discussion Help
thanks for confirming that Marco!
-
Adrian posted a comment on discussion Help
I'm asking this because i saw this post in StackOverFlow (2nd answer) https://stackoverflow.com/questions/1749464/how-can-i-use-hibernate-with-ms-access But I didn't get it to work, i also tried to use the HXTT dialect (trial version), it kind of works but it doesn't generates any EJB3 annotation.
-
Yes, there are regressions. I'll fix them in the next weeks (during the holiday) Il giorno sab 12 dic 2020 alle ore 10:41 Adrian ruman1999@users.sourceforge.net ha scritto: Nope, i was using the 5.0.0 version as a maven dependency, i'll send you the table unedited that i was trying to update. I speak Spanish and on the database everything will be in Spanish. Attachments: Test.accdb https://sourceforge.net/p/ucanaccess/discussion/help/thread/c88294c770/a9e7/4b6f/de4c/attachment/Test.accdb (3.4 MB;...
-
Nope, i was using the 5.0.0 version as a maven dependency, i'll send you the table unedited that i was trying to update. I speak Spanish and on the database everything will be in Spanish.
-
You used a very old UCanAccess version, isn't it? If not, please help us by sending along a database with an unupdatable record. Il Ven 11 Dic 2020, 19:01 Adrian ruman1999@users.sourceforge.net ha scritto: Ok, i'm going to answer myself, i discover why is not working, in my MS Access table, i have a image row (Ole object) where i have images (bitmap images), i deleted the bitmap images and now it works. Unable to make an update https://sourceforge.net/p/ucanaccess/discussion/help/thread/c88294c770/?limit=25#a9e7...
-
Ok, i'm going to answer myself, i discover why is not working, in my MS Access table, i have a image row (Ole object) where i have images (bitmap images), i deleted the bitmap images and now it works.
-
I'm trying to do an update on a table to a specific row by filtering by id and no long as i try running the query from Java is not saved in the database document. If I run the query, there's no exceptions and it runs as if it had run successfully, if I do a SELECT to collect the information from Java and see if it has been updated I find that it has been updated correctly, but then if I open the database with MS Access it has not been changed and if I rerun the Java program the changes are not made....
-
I'm trying to do an update on a table to a specific row by filtering by id and no long as i try running the query from Java is not saved in the database document. If I run the query, there's no exceptions and it runs as if it had run successfully, if I do a SELECT to collect the information from Java and see if it has been updated I find that it has been updated correctly, but then if I open the database with MS Access it has not been changed and if I rerun the Java program the changes are not made....
-
I'm trying to do an update on a table to a specific row by filtering by id and no long as i try running the query from Java is not saved in the database document. If I run the query, there's no exceptions and it runs as if it had run successfully, if I do a SELECT to collect the information from Java and see if it has been updated I find that it has been updated correctly, but then if I open the database with MS Access it has not been changed and if I rerun the Java program the changes are not made....
-
I'm trying to do an update on a table to a specific row by filtering by id and no long as i try running the query from Java is not saved in the database document. If I run the query, I there's no exceptions and it runs as if it had run successfully, if I do a SELECT to collect the information from Java and see if it has been updated I find that it has been updated correctly, but then if I open the database with MS Access it has not been changed and if I rerun the Java program the changes are not...
-
It's unplanned because unsupported by jackcess, we can't alter the underlying metadata structure if jackcess doesn't allow us for this Il Mar 8 Dic 2020, 23:35 Jefferson Poe jeffersonatsafe@users.sourceforge.net ha scritto: hello, from reading a couple threads around the "NOT NULL" constraint for UCanAccess, I come to the conclusion that there is a fundamental difference between HSQLDB and MS Access, in which HSQLDB forces users to deal with nulls before a NOT NULL constraint can be applied to a...
-
hello, from reading a couple threads around the "NOT NULL" constraint for UCanAccess, I come to the conclusion that there is a fundamental difference between HSQLDB and MS Access, in which HSQLDB forces users to deal with nulls before a NOT NULL constraint can be applied to a column. Is the team currently considering to implement ALTER COLUMN NOT NULL ? or is this feature unplanned for the reasonable future?
-
Marco Amadei committed [65c58d]
Merge /u/jamadei/ucanaccess/ branch master into master
-
Performance in a very specific case
-
Performance in a very specific case
-
Steven Cooke posted a comment on discussion Help
I have ucanaccess 4.0.4, jackcess 2.1.11 and hsqldb.jar . I was under the impression that these versions supported creation of indexes but I get an error saying its unsupported. Maybe its my syntax although it looks correct to me. I'm using MS Access 2010 This is part of the code st.execute("CREATE TABLE tblTemp (reqno TEXT, technique TEXT)"); System.out.println("tblTemp table created"); When I check the table is there with the columns I expected. I then run this immediatley after st.execute("CREATE...
-
Charles Elliott posted a comment on discussion Help
I am trying to use ucanaccess 5.0.0 after a long hiatus. I want to store file CRS32s in an Access db (FileCRCs.accdb) which has two tables: FolderTable with two columns FolderNumber (long int) and Folder Name (String) and FileTable with three colums FolderNumber (long int) and FileName (String) and CRC (long int). The Java connection statement is: Class.forName("net.ucanaccess.jdbc.UcanaccessDriver"); // Optional, same error occurs with or w/o it Connection conn; // In data section conn = DriverManager.getConnection("jdbc:ucanaccess://E:/Databases/FileCRCs.accdb;memory=true","","");...
-
media1mogul posted a comment on discussion Help
Gord, Thank you, thank you! THANK YOU! I am brand new to DBEAVER and using UCANACCESS to access an MS Access acount. I had this EXACT issue and it's had me close to tears.
-
Well, have a nice day ;-) Il Mar 25 Ago 2020, 22:37 andrew coulson acoulson@users.sourceforge.net ha scritto: Well, nevermind :-) By digging through code, I discovered that by adding ;showSchema=true to the end of the URL enable the API to return something. getCatalogs API https://sourceforge.net/p/ucanaccess/discussion/general/thread/88441ffaa2/?limit=25#37ed/0ec6 Sent from sourceforge.net because amadei.mar@gmail.com is subscribed to https://sourceforge.net/p/ucanaccess/discussion/general/ To unsubscribe...
-
andrew coulson posted a comment on discussion General Discussion
Well, nevermind :-) By digging through code, I discovered that by adding ;showSchema=true to the end of the URL enable the API to return something.
-
Would it be possible to implement UcanaccessDatabaseMetadata.getCatalogs() sor that it returns <something> (really anything beside unsupported). Since it is unsupported, utilities that extract catalog info (for version control, diffing, export, etc.) break since they often make a call to getCatalogs().</something>
-
reem alfouzan modified a comment on discussion Help
-
hi im trying to do a select statment from 2 tables .. but im having an error can anyone help me please this is my code : import java.sql.*; public class dbconnection2 { public static void main(String[] args){ try{ Connection conn = DriverManager.getConnection("jdbc:ucanaccess://C:\\Users\\reem\\Documents\\Database1.accdb"); Statement st =conn.createStatement(); String sql = "SELECT FACILITIES.Name, FACILITIES.TYPE FROM Branches, FACILITIES WHERE FACILITIES.BranchId = Branches.ID AND Branches.Name...