Hi.
I bought the paradox JDBC driver and sometimes it not read all the records from database. I query it with DBD32 and I can show all the records but not all trough the driver. If I reindex the table the driver run correct but a few days later I can't read the new records with jdbc (but I can with dbd32). Are there a way for read the database without use indexs? I ought to rebuild the index each time I read It?
Thanks.
Salvador
|
What's your sql? It seems that your index file isn't keep up to date.
>If I reindex the table the driver run correct but a few days later
> I can't read the new records with jdbc (but I can with dbd32).
What applicatio will modify and maintain that table?
|
I'm reading from a database which is updated by a delphi application. The problem is that it not detect this index up to date and work correctly. I use the paradox driver only for read the tables and when I include the clause "where" (and I suppose the driver uses the index) . I understand it isn't a driver problem because the index is up to date but I don't undersand because the Delphi application with the BDE run correctly and I can't rebuild the indexs every time and I don't know if the records I read are all . Don't worry. I changed my applications and now I don't use 'where' in my sql calls , I read all the records and filter it with code. I can't see another solution.
Thanks.
|
>The problem is that it not detect this index up to date and work correctly.
Try delayedClose=0 connection property. Then your issue should disappear.
|
I've tried
"DriverManager.getConnection("jdbc:paradox:/c:/dades/emelec/ventas/dat/001?delayedClose=0","","")".
and neither works.
Sorry but I didn't tell correctly last mail
The problem is that it (Delphi application) not detect that index IS NOT up to date and work correctly. I use the jdbc paradox driver only for read the tables and when I include the clause "where" (and I suppose the driver uses the index) jdbc don't read some records. I understand it isn't a driver problem because the index is not up to date and when I reindex it the driver run properly.
|
Sorry, you should try lockTimeout=-1 connection property. If you failed still, please let us know, then we will try to skip specially that issue for you.
|