Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access 7.1.252
  HXTT Cobol 5.0.251
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT DBF 7.1.252
  HXTT Excel 6.1.255
  HXTT Json 1.0.223
  HXTT Paradox 7.1.251
  HXTT PDF 2.0.251
  HXTT Text(CSV) 7.1.251
  HXTT Word 1.1.251
  HXTT XML 4.0.252
Offshore Outsourcing
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
   
   
   
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

HXTT Cobol
Cobol JDBC driver with Talend ETL
Jean-Marc
2013-03-18 04:58:22
Hi,

I tried to use your driver in Talend ETL, with the standard JDBC mapper, but the files in the directory are not shown when displaying the "database" schema in Talend, so we can't make any query on them...

Can you help me ?
Re:Cobol JDBC driver with Talend ETL
HXTT Support
2013-03-18 05:10:12
fileExtension connection property: To specify other suffix as default extension of Cobol data file. Default value: DAT
Please check whether your files is using other file suffix. If yeah, you should use jdbc:cobol:///yourpath?fileExtension=yourSuffix .

Re:Re:Cobol JDBC driver with Talend ETL
Jean-Marc
2013-03-18 05:17:17
Files don't have any extension
They are microfocus cobol files : can you connect to them ?
Re:Re:Re:Cobol JDBC driver with Talend ETL
HXTT Support
2013-03-18 05:18:48
>Files don't have any extension
Then you can use jdbc:cobol:///yourpath?fileExtension=null .

>They are microfocus cobol files :
No issue.
Re:Re:Re:Re:Cobol JDBC driver with Talend ETL
Jean-Marc
2013-03-18 05:25:20
No, it doesn't work

I also tried to copy the files in a directory and changed their extension : Talend can now see them but it cannot guess their schema
Re:Re:Re:Re:Re:Cobol JDBC driver with Talend ETL
HXTT Support
2013-03-18 05:31:03
>No, it doesn't work
>I also tried to copy the files in a directory and changed their extension :
What's your jdbc url?

> Talend can now see them but it cannot guess their schema
fileDescriptionExtension connection property: Indicates whether Cobol driver supports other extension beside 'cpy', 'fd', 'sel', 'cbl', and 'cob' as default file description extension. The supported formats inlcude Cobol source code file, Copybook file, FD file, and SEL file. You can use comma to assign more than one extension, for instance, cobolExtension=CBL,ECOB . Default value: null

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap