Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Cobol v5.0
  HXTT DBF v7.1
  HXTT Excel v6.1
  HXTT Json v1.0
  HXTT Paradox v7.1
  HXTT PDF v2.0
  HXTT Text(CSV) v7.1
  HXTT Word v1.1
  HXTT XML v4.0
Offshore Outsourcing
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
   
   
   
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

HXTT ACCESS
Multiple other extensions
Magnus Meurer
2008-06-24 05:47:43
Hi,

is there a way to access multiple files all having different file endings?
We have to access 3 access files (placed in the same directory), ending with .MDB, .DB and .ADR.

Using otherExtension=adr gives us access to the *.ADR file and the *.MDB file, but not to the *.DB file.

Using otherExtension=db gives us access to the *.DB file and the *.MDB file but not to the *.ADR file.

Is there a way to set the otherExtension property to a value so that all file endings are supported?

Best regards,
Magnus Meurer
Re:Multiple other extensions
HXTT Support
2008-06-24 07:24:40
According to your request, v3.0.035 supports to assign more than one extension for otherExtension connection property. You can use comma to assign more than one extension, for instance, otherExtension=DB,ACR . It will be availabe after about 48 hours.
Re:Re:Multiple other extensions
Magnus Meurer
2008-07-03 07:18:25
Works fine when accessing files that are placed in the same directory.

I receive strange effects with the following combination

JDBC-URL is something like this:
jdbc:access:///c:temp/?otherExtension=db,adr

and DB-Files are placed here
c:/temp/System/System.db
and here
c:/temp/Daten/dbfile.adr

To access the files I use SQL-Statements like

SELECT * FROM "System"."System"."tablename"
and
SELECT * FROM "Daten"."dbfile"."tablename"


This works sometimes, but sometimes I receive the following exception:

java.sql.SQLException: Failed to load database System! For more information, please use SQLException.getNextException().
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.access.l.int(Unknown Source)
at com.hxtt.sql.access.l.for(Unknown Source)
at com.hxtt.sql.access.l.(Unknown Source)
at com.hxtt.sql.access.a0.a(Unknown Source)
at com.hxtt.concurrent.x.a(Unknown Source)
at com.hxtt.sql.access.l.a(Unknown Source)
at com.hxtt.sql.access.r.a(Unknown Source)
at com.hxtt.sql.access.r.byte(Unknown Source)
at com.hxtt.sql.a.getExportedKeys(Unknown Source)
at com.hxtt.sql.access.a2.do(Unknown Source)
at com.hxtt.sql.access.ai.(Unknown Source)
at com.hxtt.sql.access.r.a(Unknown Source)
at com.hxtt.sql.bm.if(Unknown Source)
at com.hxtt.sql.de.a(Unknown Source)
at com.hxtt.sql.de.a(Unknown Source)
[..]

after calling SQLException.getNextException():


16:11:20,434 ERROR [com.rheinenergie.marktpartner.events.services.MarktpartnerEventService] - java.io.FileNotFoundException: Z:\Programme\AdressPLUS\Daten\System.MDE (Das System kann die angegebene Datei nicht finden)
java.sql.SQLException: java.io.FileNotFoundException: c:/temp/System/System.MDE (Das System kann die angegebene Datei nicht finden)
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.concurrent.o.a(Unknown Source)
at com.hxtt.concurrent.v.(Unknown Source)
at com.hxtt.concurrent.t.do(Unknown Source)
at com.hxtt.concurrent.t.if(Unknown Source)
at com.hxtt.sql.access.l.int(Unknown Source)
at com.hxtt.sql.access.l.for(Unknown Source)
at com.hxtt.sql.access.l.(Unknown Source)
at com.hxtt.sql.access.a0.a(Unknown Source)
at com.hxtt.concurrent.x.a(Unknown Source)
at com.hxtt.sql.access.l.a(Unknown Source)
at com.hxtt.sql.access.r.a(Unknown Source)
at com.hxtt.sql.access.r.byte(Unknown Source)
at com.hxtt.sql.a.getExportedKeys(Unknown Source)
at com.hxtt.sql.access.a2.do(Unknown Source)
at com.hxtt.sql.access.ai.(Unknown Source)
at com.hxtt.sql.access.r.a(Unknown Source)
[...]


This is a sporadic behaviour ... any ideas?
Re:Re:Re:Multiple other extensions
HXTT Support
2008-07-03 08:16:13
>JDBC-URL is something like this:
>jdbc:access:///c:temp/?otherExtension=db,adr
>and DB-Files are placed here
>c:/temp/System/System.db
>and here
c:/temp/Daten/dbfile.adr
>Z:\Programme\AdressPLUS\Daten\System.MDE
It seems that your database is at a shared map driver, and your network isn't stable and sometimes HXTT Access failed to find any one of System.MDB, System.MDE, System.db , or System.adr .
Re:Re:Re:Re:Multiple other extensions
Magnus Meurer
2008-07-04 01:57:00
I moved every db-file to my local hard disk and tried it again.

I still get the same error:

java.sql.SQLException: Failed to load database System! For more information, please use SQLException.getNextException().
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.access.l.int(Unknown Source)
at com.hxtt.sql.access.l.for(Unknown Source)
at com.hxtt.sql.access.l.(Unknown Source)
at com.hxtt.sql.access.a0.a(Unknown Source)
at com.hxtt.concurrent.x.a(Unknown Source)
at com.hxtt.sql.access.l.a(Unknown Source)
at com.hxtt.sql.access.r.a(Unknown Source)
at com.hxtt.sql.access.r.byte(Unknown Source)
at com.hxtt.sql.a.getExportedKeys(Unknown Source)
at com.hxtt.sql.access.a2.do(Unknown Source)
at com.hxtt.sql.access.ai.(Unknown Source)
at com.hxtt.sql.access.r.a(Unknown Source)
at com.hxtt.sql.bm.if(Unknown Source)
at com.hxtt.sql.de.a(Unknown Source)
at com.hxtt.sql.de.a(Unknown Source)
at com.hxtt.sql.bm.a(Unknown Source)
at com.hxtt.sql.bm.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.dg.executeQuery(Unknown Source)
...
java.sql.SQLException: java.io.FileNotFoundException: D:\temp\System.MDE (Das System kann die angegebene Datei nicht finden)
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.concurrent.o.a(Unknown Source)
at com.hxtt.concurrent.v.(Unknown Source)
at com.hxtt.concurrent.t.do(Unknown Source)
at com.hxtt.concurrent.t.if(Unknown Source)
at com.hxtt.sql.access.l.int(Unknown Source)
at com.hxtt.sql.access.l.for(Unknown Source)
at com.hxtt.sql.access.l.(Unknown Source)
at com.hxtt.sql.access.a0.a(Unknown Source)
at com.hxtt.concurrent.x.a(Unknown Source)
at com.hxtt.sql.access.l.a(Unknown Source)
at com.hxtt.sql.access.r.a(Unknown Source)
at com.hxtt.sql.access.r.byte(Unknown Source)
at com.hxtt.sql.a.getExportedKeys(Unknown Source)
at com.hxtt.sql.access.a2.do(Unknown Source)
at com.hxtt.sql.access.ai.(Unknown Source)
at com.hxtt.sql.access.r.a(Unknown Source)
at com.hxtt.sql.bm.if(Unknown Source)
at com.hxtt.sql.de.a(Unknown Source)
at com.hxtt.sql.de.a(Unknown Source)
at com.hxtt.sql.bm.a(Unknown Source)
at com.hxtt.sql.bm.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.dg.executeQuery(Unknown Source)
...

I can reproduce the error with different db-files (*.mdb, *.db, ... whatever) placed in sudirectories relative to the path defined in my JDBC-URL (jdbc:access:///d:/temp/) and accessing a file back-to-back, using a new connection from my data source in each case.
Re:Re:Re:Re:Re:Multiple other extensions
HXTT Support
2008-07-04 03:31:44
>jdbc:access:///d:/temp/
>java.sql.SQLException: java.io.FileNotFoundException: D:\temp\System.MDE
Check your jdbc url and sql. It seems that you missed ?otherExtension=db,adr or System.db is at a subdirectory, but you sql is "select * from System.atable".
Re:Re:Re:Re:Re:Re:Multiple other extensions
Magnus Meurer
2008-07-04 03:51:26
As mentioned in my first post, I do use the otherExtension property.

Okay, here is my complete configuration:

JDBC-URL:
jdbc:access:///d:/temp/?otherExtension=adr,db

Files:
d:/temp/Marktpartner.adr
d:/temp/MP_Veranstaltungen.mdb
d:/temp/System/System.db

SQL Statement Syntax examples:

SELECT ID FROM "Marktpartner"."ADDRESSES" -> works fine

SELECT ID, Name FROM "MP_Veranstaltungen"."MP_KATEGORIEN" -> works fine

SELECT * FROM "System"."System"."Auswahllisten" -> fails sometimes as mentioned above


If I put the file Marktpartner.adr into a subdirectory like
d:/temp/Data/Marktpartner.adr
and therefore change the SELECT statement to
SELECT ID FROM "Data"."Marktpartner"."ADDRESSES"
I do also receive sometimes the above mentioned error / exception.

Seems to me as if there is a problem with the sudirectory structure.
Re:Re:Re:Re:Re:Re:Re:Multiple other extensions
HXTT Support
2008-07-04 06:09:38
>I do also receive sometimes the above mentioned error / exception.
Whether other applications are using those files? I failed to recur your issue. What's your OS and Java VM version?

Re:Re:Re:Re:Re:Re:Re:Re:Multiple other extensions
Magnus Meurer
2008-07-06 23:40:24
I am using
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_09-b03)
with the Oracle Application Server 10g (10.1.3.2.0)
and a configured data source (com.hxtt.sql.HxttConnectionPoolDataSource) to obtain the connections.
on a Win XP system.
Re:Re:Re:Re:Re:Re:Re:Multiple other extensions
Magnus Meurer
2008-07-06 23:42:46
At the time the errors occure, no other applications are accessing the files.
Re:Re:Re:Re:Re:Re:Re:Re:Multiple other extensions
HXTT Support
2008-07-09 07:51:13
Please download the latest package, which optimized speed. We will test to HxttConnectionPoolDataSource to see whether we can recur your issue. What's your configure for that datasource?

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Refund | Sitemap