Lon Parisi

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...

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)...

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...

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)...

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...

It was a number (single precision) From: Marco Amadei [mailto:jamadei@users.sourceforge.net] Sent: Tuesday, June 23, 2020 12:11 PM To: [ucanaccess:discussion] help@discussion.ucanaccess.p.re.sourceforge.net Subject: [ucanaccess:discussion] Re: MS Access unable to delete using date as criteia Ok, what type of data the column was? Il Mar 23 Giu 2020, 13:36 Lon Parisi lonparisi@users.sourceforge.netlonparisi@users.sourceforge.net ha scritto: So I have figured out why this error is happening. Somehow,...

So I have figured out why this error is happening. Somehow, there was a -1#IND value in one of the columns of my MS Access table. Because of that, UCanAccess (or one of the other dependencies products) could not delete the data EVEN THOUGH the column used in the delete criteria did not have the -1#IND value. I removed/corrected that record and everything is now working fine.

Hello, I've been experiencing a strange problem. When I execute the following command: delete from dislocations where market_date < #2020-06-15# in MS Access SQL it works fine. When I do the exact same thing/command in Java, I get a very unexpected error. Here is my java code: private void clearOldDislocations() { try { String sql = "delete from dislocations where market_date < #" + msafmt.format(this.endDate) + "#"; System.out.println(sql); PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.executeUpdate();...