Hello,
I have a directory with 4 DBF files. I make some requests on one of them without any problems.
With another one of them, I have an exception thrown "IOException" No such File or directory.
With another one of them, I have the same Exception thrown with lot of results. No exception with less results.
I don't understand how to solve this problem, names and rights of files seems to be OK.
Can you help me?
Thanks for your answer,
Carlos
|
What's your jdbc url and OS? If 4 DBF files is at the same directory, please list those files' names. Maybe it's a case sensitive issue, which HXTT DBF failed to guess some file names.
|
My OS is a Linux debian.
My JDBC url is : jdbc:dbf:///
|
Then you're using a free JDBC url, which allow you to visit any host or directory if you get the access right. You need to check your sql to make sure that HXTT DBF can find the right unc path or absolute path for your dbf file. What's your sql?
|
My sql is: select * from 'table'
'table' is the table name, and is the same name of DBF file.
About rights, I think that is OK, because I can execute a query on a small table of this directory without any problem.
Thanks,
Regards,
Carlos
|
>My sql is: select * from 'table'
You should use select * from "table". ' is using for string value, and " is using for variable. Maybe you should list your sql sample and list those file name.
|