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