Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT DBF
Sunopsis to Visual Foxpro
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
Re:Sunopsis to Visual Foxpro
HXTT Support
2006-08-31 07:48:47.0
It failed to load one index expression for that table.

Whether your index expression is:

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),2,"0")

?
Re:Re:Sunopsis to Visual Foxpro
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 .
Re:Re:Re:Sunopsis to Visual Foxpro
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?
Re:Re:Re:Re:Sunopsis to Visual Foxpro
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.
Re:Re:Re:Re:Re:Sunopsis to Visual Foxpro
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
Re:Re:Re:Re:Re:Sunopsis to Visual Foxpro
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
Re:Re:Re:Re:Re:Re:Re:Sunopsis to Visual Foxpro
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

:)
Re:Re:Re:Re:Re:Re:Re:Re:Sunopsis to Visual Foxpro
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

Re:Re:Re:Re:Re:Re:Re:Re:Sunopsis to Visual Foxpro
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

Re:Re:Re:Re:Re:Re:Re:Re:Sunopsis to Visual Foxpro
HXTT Support
2006-09-04 06:07:53.0
You should use ;
jdbc:dbf:/c:/dbfiles?loadIndices=false;lockType=VFP
Re:Re:Re:Re:Re:Re:Re:Re:Sunopsis to Visual Foxpro
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
Re:Re:Re:Re:Re:Re:Re:Re:Sunopsis to Visual Foxpro
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

Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap