Alex | 2006-08-31 07:19:59.0 | |
I am trying to use the HXTT DBF jdbc driver to extract data from a VFP database to DB2/400. It does work, but for a certain table, i get the following error:
270336 : 42000 : java.sql.SQLException: Can't parse index expression NVL(persoonid," ")+PADL(YEAR(datumaangemeld),4,"0")+PADL(MONTH(datumaangemeld),2,"0")+PADL(DAY(datumaangemeld),2,"0")+PADL(HOUR(datumaangemeld),2,"0")+PADL(MINUTE(datumaangem All other tables in the database get transfered correctly, but only with this table, it gets the error. Does anybody know a reason for this and maybe even how to solve it? Cheers! Alex | ||
HXTT Support | 2006-08-31 07:48:47.0 | |
It failed to load one index expression for that table.
Whether your index expression is:
? | ||
HXTT Support | 2006-08-31 09:55:35.0 | |
According to our test, my listed expression is supported. Maybe your index expression in index file is corrupted. You can use ftp service to send your sample so that we can help you to fix it. You can remove simply that index file too, then your table will be immigrated:)
ftp site: ftp.hxtt.com ftp user: anonymous@hxtt.com ftp password: (empty) login mode: normal (not anonymous) ftp port:21 upload directory: incoming After upload, you can't see that upload file, but it has been upload. then notify us through webmaster@hxtt.com . | ||
Alex | 2006-09-01 07:00:06.0 | |
The problem is that I am restricted to alter anything on the source database, because it lies under an application which is in use by business. I am only allowed to connect to it (jdbc or odbc) so that i can extract data out of it.
Removing the index file would probably have big consequences for the application using it. Any suggestion to work around this? | ||
HXTT Support | 2006-09-01 07:14:41.0 | |
You need to remove it:)
First, you can use lockType=VFP to detect the lock from VFP applcation so that they can access the same data at the same time. Secondly, you can use loadIndices=false to avoid HXTT DBF to load that corrupted index file. | ||
Alex | 2006-09-04 01:52:30.0 | |
Great, i think the option "loadincides" is exactly what i need. Is there a guide on how to apply this to the driver?
On this page I found the information about this: http://www.hxtt.com/dbf/installation.html But I have not figured out how to execute the following statement in Sunopsis: Connection con = DriverManager.getConnection(url, properties); Once I can get this working, I don't see why there should be any other problems. Thanks in advance | ||
Alex | 2006-09-04 01:53:13.0 | |
Great, i think the option "loadincides" is exactly what i need. Is there a guide on how to apply this to the driver?
On this page I found the information about this: http://www.hxtt.com/dbf/installation.html But I have not figured out how to execute the following statement in Sunopsis: Connection con = DriverManager.getConnection(url, properties); Once I can get this working, I don't see why there should be any other problems. Thanks in advance | ||
HXTT Support | 2006-09-04 02:07:11.0 | |
For instance, your jdbc url is:
jdbc:dbf:/c:/dbfiles then you can use jdbc:dbf:/c:/dbfiles?loadIndices=false :) | ||
Alex | 2006-09-04 06:00:48.0 | |
Thank you so much for the very helpful information on such a short notice.
I have just one final question. If I want to use multiple commands, what do I use to seperate them? So if I want to use loadIndices=false and lockType=VFP Does this look right? jdbc:dbf:/c:/dbfiles?loadIndices=false,lockType=VFP | ||
Alex | 2006-09-04 06:06:36.0 | |
Thank you so much for the very helpful information on such a short notice.
I have just one final question. If I want to use multiple commands, what do I use to seperate them? So if I want to use loadIndices=false and lockType=VFP Does this look right? jdbc:dbf:/c:/dbfiles?loadIndices=false,lockType=VFP | ||
HXTT Support | 2006-09-04 06:07:53.0 | |
You should use ;
jdbc:dbf:/c:/dbfiles?loadIndices=false;lockType=VFP | ||
Alex | 2006-09-04 06:34:38.0 | |
Great, that's about all I needed to know.
Request to purchase the driver has already been sent to business :) Thanks very much! Kind regards, Alex | ||
Alex | 2006-09-04 06:51:03.0 | |
Great, that's about all I needed to know.
Request to purchase the driver has already been sent to business :) Thanks very much! Kind regards, Alex |