Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT ACCESS
Linked table
Patrick
2013-11-12 06:06:37.0
Hello,
I'm using a *.mdb file with many tables. Some of them are in fact links to tables in other *.mdb files.
Everything works fine when using HXTT on Windows, but on Linux the linked tables cannot be found, because the link is an absolute path like "C:\data\other.mdb".

I couldn't find a way on Access to use relative paths for linked tables.

Do you know how to solve this problem?

Thanks,
Patrick
Re:Linked table
HXTT Support
2013-11-12 06:20:01.0
>because the link is an absolute path like "C:\data\other.mdb".
>I couldn't find a way on Access to use relative paths for linked tables.
Yeah. Whether you have copied the other.mdb into the same directory of your .mdb file?
Re:Re:Linked table
Patrick
2013-11-12 06:24:50.0
Yes I did.I still get the error:

java.sql.SQLException: Failed to load database M:\bpl2000data\ticketData:java.io.FileNotFoundException: M:\bpl2000data\ticketData.mdb (No such file or directory)
at com.hxtt.global.SQLState.setNextException(Unknown Source) ~[accessjdbc4-5.1.178.jar
Re:Re:Re:Linked table
HXTT Support
2013-11-12 06:51:33.0
>Yes I did.I still get the error:
It's normal since Linked table used absolute path. We will provide a guess path solution so that it's possible to access linked table with absolute Windows path information on Linux.
Re:Re:Re:Re:Linked table
HXTT Support
2013-11-14 00:08:36.0
Supported. Please download the latest package.
Re:Re:Re:Re:Re:Linked table
Patrick
2013-11-14 00:17:00.0
Great! How must it be configured?
Re:Re:Re:Re:Re:Re:Linked table
HXTT Support
2013-11-14 00:25:51.0
Needn't set. It will guess path. For instance, "C:\data\other.mdb", and you are using jdbc:access////home/user/, it will searh it as /home/user/other.mdb or /home/user/data/other.mdb .
Re:Re:Re:Re:Re:Re:Re:Linked table
Patrick
2013-11-18 08:45:47.0
Thanks for your message.
I can't seem to be able to make it work. Here's my config:

datasource url = jdbc:access:////Users/pat/Documents/workspace-spring/data/bpl2000data.mdb

second file is in the same folder: /Users/pat/Documents/workspace-spring/data/ticketData.mdb

Table link inside first file to second file is: M:\bpl2000data\ticketData.mdb
Re:Re:Re:Re:Re:Re:Re:Re:Linked table
HXTT Support
2013-11-18 19:31:48.0
Fixed. Please download the latest package.
Re:Re:Re:Re:Re:Re:Re:Re:Linked table
Patrick
2013-11-20 00:12:43.0
Ok it works with version 5.1.184.
Thanks!
CACHE problem
Patrick
2013-12-04 06:47:43.0
Hi,
There's a bug when the linked table gets updated by another process: changes are not reflected when following link.
It looks like the cache is hit, instead of the file.
Thanks for your help,
Patrick
Re:Re:Re:Re:Re:Re:Re:Re:Linked table
HXTT Support
2013-12-05 05:58:26.0
>There's a bug when the linked table gets updated by another process: changes are not reflected when following link.
>It looks like the cache is hit, instead of the file.
Try connection property:
lockType=ACCESS
refreshInterval=0 at here
Re:Re:Re:Re:Re:Re:Re:Re:Linked table
Patrick
2013-12-05 08:21:06.0
With lockType=ACCESS, it's impossible to retrieve data from linked table as soon as another Access client modifies it.
Data is completely strange, it's as if the pointer in the db file is at the wrong place.
Re:Re:Re:Re:Re:Re:Re:Re:Linked table
HXTT Support
2013-12-05 16:34:34.0
>With lockType=ACCESS, it's impossible to retrieve data from linked table as soon as another Access client modifies it.
MS Access client should be opening exclusively that table.
Then remove lockType conneciton property, and try J2ME=true and delayedClose=0.
Re:Re:Re:Re:Re:Re:Re:Re:Linked table
Patrick
2013-12-06 00:19:13.0
Thanks for your message.
With J2ME=true, it's incredibly slow (a simple SELECT takes 200 sec, the same SELECT takes 1.5 sec without this parameter).
Re:Re:Re:Re:Re:Re:Re:Re:Linked table
HXTT Support
2013-12-06 01:29:25.0
Because it need a way to know whether that data has been modified:(
Usually lockType=ACCESS and refreshInterval=n can work perfectly with concurrent data modification according to MS Access lock mechanism. But your Access client seems to use database exclusively.
J2ME=true can see data modification ASAP, but can't do concurrent data change. If it can work for you, we can try to find a better solution to use partly cache.
Re:Re:Re:Re:Re:Re:Re:Re:Linked table
Patrick
2013-12-06 01:33:47.0
Ok thanks for your answer. All our clients are MS ACCESS 2013, and of course our java server.

We absolutely need concurrent data change.

Let me do more tests with lockType=ACCESS and get back to you.
Thanks,
Patrick
Re:Re:Re:Re:Re:Re:Re:Re:Linked table
Patrick
2013-12-09 08:45:57.0
OK it looks like this problem has nothing to do with linked tables.
This is what I found:
Test consists in opening a db with MS ACCESS 2003 and with HXTT jdbc driver (with lockType=ACCESS).
a) Modify with HXTT and see if modification appears in MSAccess
b) Modify with MSAccess and see if modification appears in HXTT

---- TEST 1 OK-----
Access JDBC Driver 4.1 version 5.1.136
Everything looks good

---- TEST 2 KO-----
Access JDBC Driver 4.1 version 5.1.141
a) is ok
b) is KO: HXTT driver unable to read db, as if pointer in data file is at a wrong place.

All versions after 5.1.141 have the same problem.
Re:Re:Re:Re:Re:Re:Re:Re:Linked table
HXTT Support
2013-12-09 21:01:52.0
Thanks for your valuable response. Please redownload it.
Re:Re:Re:Re:Re:Re:Re:Re:Linked table
Patrick
2013-12-10 00:14:24.0
Test b) doesn't work with version 5.1.187. I still got errors where HXTT driver tries to read wrong columns, like this:
"SQLException: Failed to get a short value from java.lang.String: ??0000275004"
That value is from another column.
Re:Re:Re:Re:Re:Re:Re:Re:Linked table
HXTT Support
2013-12-10 01:13:03.0
>I still got errors where HXTT driver tries to read wrong columns, like this:
Please let us see your test sample or test step.
Re:Re:Re:Re:Re:Re:Re:Re:Linked table
Patrick
2013-12-10 01:33:09.0
Ok I have a test db. How can I send it to you?
Re:Re:Re:Re:Re:Re:Re:Re:Linked table
HXTT Support
2013-12-10 03:21:20.0
support at hxtt.com
Re:Re:Re:Re:Re:Re:Re:Re:Linked table
HXTT Support
2013-12-10 07:37:08.0
Recurred and fixed. Please download it.
Re:Re:Re:Re:Re:Re:Re:Re:Linked table
Patrick
2013-12-10 08:51:35.0
Hi,
It's better now, but as I was playing around (making concurrent modifications with HXTT and MSACCESS), one time I got this error:
Caused by: java.sql.SQLException: Inner error on query with index expression
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.r.a(Unknown Source)
And then everything was stuck. I had to restart the java server.
Sadly I'm not sure how I triggered this problem.

P.S. The new download has the same version 5.1.187. Is it the correct one?
Re:Re:Re:Re:Re:Re:Re:Re:Linked table
HXTT Support
2013-12-11 01:34:23.0
>Caused by: java.sql.SQLException: Inner error on query with index expression
Checked. Please download the latest package.
Re:Re:Re:Re:Re:Re:Re:Re:Linked table
Patrick
2013-12-11 03:00:21.0
Still older version (5.1.187 compiled december 10) on server.
Re:Re:Re:Re:Re:Re:Re:Re:Linked table
HXTT Support
2013-12-11 03:49:08.0
It's v5.1.188 in fact. Please download it.
Re:Re:Re:Re:Re:Re:Re:Re:Linked table
Patrick
2013-12-11 05:12:36.0
I'm not able to get this version.
I go to http://www.hxtt.com/download.jsp
Then I download "Access JDBC 4.1 Package for JDK1.7.X "
Then I run java -classpath Access_JDBC41.jar com.hxtt.sql.access.AccessDriver
I still get "HXTT Access JDBC4.1 Driver (Version 5.1.187) Compiled: December 10, 2013"
Re:Re:Re:Re:Re:Re:Re:Re:Linked table
HXTT Support
2013-12-11 05:38:30.0
Checked. Yeah. Now I have reupload it.
Re:Re:Re:Re:Re:Re:Re:Re:Linked table
Patrick
2013-12-11 06:47:31.0
..... still the old version ....
Re:Re:Re:Re:Re:Re:Re:Re:Linked table
HXTT Support
2013-12-11 16:04:05.0
Checked again. Sorry. Now it's right file.
Re:Re:Re:Re:Re:Re:Re:Re:Linked table
Patrick
2013-12-12 01:23:51.0
Ok thanks I got it. I will test for a few days and get back to you

Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap