Bug 99032 - FILEOPEN: Fail to open Table from dictionary using Advantage Data Server JDBC and ODBC.
Summary: FILEOPEN: Fail to open Table from dictionary using Advantage Data Server JDBC...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
5.1.1.3 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Connectivity
  Show dependency treegraph
 
Reported: 2016-04-01 15:06 UTC by pbmtech
Modified: 2019-06-26 08:39 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Database Properties in BASE (70.77 KB, image/jpeg)
2016-04-01 15:06 UTC, pbmtech
Details
ODBC settings with a '.' in path (84.75 KB, image/jpeg)
2016-04-05 18:06 UTC, pbmtech
Details
Libre 5.4.7.2(64 bit) Dictionary Bug (110.60 KB, image/jpeg)
2018-06-19 15:40 UTC, pbmtech
Details
table names prefixed with our file type '.add' (70.31 KB, image/jpeg)
2018-12-18 21:42 UTC, pbmtech
Details

Note You need to log in before you can comment on or make changes to this bug.
Description pbmtech 2016-04-01 15:06:34 UTC
Created attachment 124018 [details]
Database Properties in BASE

I am trying to use Libre Base v5.1.1.3 on my Windows 7 64-bit PC to connect to an Advantage Data Server table using Advantage JDBC (ADS is running on a SLES 11 SP4 VM). Using Advantage Arc v.11.10.0.24 on my Windows PC, I created a new Data Dictionary called 'data_test.add' and created a simple table. I installed the ADS JDBC on my PC, added the class path to Java 1.8 and set up the connection via the wizard in Base. I tested the 'Test Class' and 'Test Connections' and those all work. The issue seems to be with my 'JDBC:extendedsystems:advantage://ads-srv:6262;Catalog=//ads-srv/data/data_test.add' Data Source URL and the ADS file extension of my Dictionary name which is .add. That add is being striped from the URL path and added to my Table names for some reason (See attachment). When I click on the table in Base I get the error "The data content cannot be loaded" and file not found because the name of the table is being changed from tblusers to add.tblusers.
Comment 1 pbmtech 2016-04-05 18:06:12 UTC
I tried ODBC today and see the exact same issue in Libre Base 5.1.x.If the ODBC or JDBC Data Source contains a period '.' in it's path it will append anything after that period to the table name. I tried quotation marks and single quotes with no luck. Is this a known issue? I can't find anything about it online and have found that this issue does not exist if I use MS Access 2013 to connect to my Advantage Data Dictionary or if I use RazorSQL.
Comment 2 pbmtech 2016-04-05 18:06:48 UTC
Created attachment 124103 [details]
ODBC settings with a '.' in path
Comment 3 Xisco Faulí 2018-06-12 10:45:17 UTC
Thank you for reporting the bug.
Could you please try to reproduce it with the latest version of LibreOffice
from https://www.libreoffice.org/download/libreoffice-fresh/ ?
I have set the bug's status to 'NEEDINFO'. Please change it back to
'UNCONFIRMED' if the bug is still present in the latest version.
Comment 4 pbmtech 2018-06-19 15:40:07 UTC
Created attachment 142923 [details]
Libre 5.4.7.2(64 bit) Dictionary Bug

This screen capture shows our Dictionary bug is still present in the latest version of Libre.
Comment 5 Xisco Faulí 2018-12-18 15:39:28 UTC
A new major release of LibreOffice is available since this bug was reported.
Could you please try to reproduce it with the latest version of LibreOffice
from https://www.libreoffice.org/download/libreoffice-fresh/ ?
I have set the bug's status to 'NEEDINFO'. Please change it back to
'UNCONFIRMED' if the bug is still present in the latest version.
Comment 6 pbmtech 2018-12-18 21:42:35 UTC
Created attachment 147657 [details]
table names prefixed with our file type '.add'

Attachment shows how our Database "//smopsrv3/DATA/smallops/smohouse.add" is being appended to the table names below using the latest version of Libre.