Hello,
i'm encountering a problem when connecting with direct file url or samba url, I can get valid entries with "connection.getMetaData().getTables()" function, which lists available tables/files on a specific location
however, when using "ftp" in connection url, this function returns blank. Direct query still working however
example :
with this url:
jdbc:Text:smb://user:pw@192.168.48.9/afolder?_CSV_Header=true&dateFormat='dd/MM/yyyy'
connection.getMetaData().getTables() works perfectly
however with this url:
jdbc:Text:ftp://user:pw@192.168.48.9/afolder?_CSV_Header=true&dateFormat='dd/MM/yyyy'
connection.getMetaData().getTables() returns blank.. can you help ?
however "select * from tablexxx" works from above url
thank you
regards
|
|
list command of ftp protocol will fetch differenct content for differ FTP server, and HXTT Text (CSV) hasn't supported it. Only if it's a key feature for your project, we will provide that feathure.
|
Hello,
I'm creating a tools for importing various files using hxtt dbf,access,text and excel, so at this point the user will entry the URL then table selection will emerge, and then when user pick the source table, the destionation table will be created automatically... functions used is :
metadata.getTables
metadata.getColumns
metadata.getPrimaryKey
drivers used:
hxtt dbf
hxtt access
hxtt text
hxtt excel
I will be very thankful if you can implement these using ftp and ftps protocol or other protocols, because it will be hard for me to implement myself an will need total reengineering of my project
how hard to implement it ?
thank you
regards
|
sftp should have supported metadata.getTables .
What's your ftp server version?
|
Hello,
I'm creating a tools for generic uses (accessing wide variety of ftp servers), so it need to support any version of ftp server, if it cannot be generic then i probably better to use another ftp solution which can be generic..
do you think it's possible ?
thank you
regards
|
|
We will provide support soon.
|
Main
webmaster@hxtt.com