Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access 7.0.033
  HXTT Cobol 4.0.033
  HXTT DBF 7.0.033
  HXTT Excel 6.0.034
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Paradox 7.0.033
  HXTT PDF 1.1.033
  HXTT Text(CSV) 7.0.033
  HXTT Word 1.0.031
  HXTT XML 3.0.033
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 Excel
Use of FLUSH
Raúl Martins
2019-04-04 14:09:55.0
Hi,

We updated JDBC version 4.0 to current version.
Our target is to get Excel files updated before our program ends.

I found in your FAQs that including xls file name in the connection URL, the file is updated when closing the connection.
It could solve some or the process cases, when the file name is known at configuration time.
As we also process unknown Excel files, we can't include their names in URL and need to execute the FLUSH DATABASE database_name instruction.

When executing this instructions we get both in our program and in Squirrel an error:

Error: Failed to flush database recepcionMateriales.xlsx.
SQLState: 3D000
ErrorCode: 249856

What is the reason for the message?
I would appreciate some guidance about using FLUSH DATABASE also.

Thank you in advance
Re:Use of FLUSH
HXTT Support
2019-04-04 14:50:30.0
> 3D000
Invalid catalog name

>As we also process unknown Excel files, we can't include their names in URL and need to execute the FLUSH DATABASE database_name instruction.

Yeah. What's your JDBC url and FLUSH sql?


Re:Re:Use of FLUSH
Raúl Martins
2019-04-04 15:48:02.0
Hi,

In my Squirrel example URL is: "jdbc:excel:///C:/ETL/Entrada/"

and the SQL statement is: "flush database recepcionmateriales"

FYI, before running FLUSH I executed successfully the following statement:
"select * from recepcionmateriales.detalle"

Tks
Re:Re:Re:Use of FLUSH
HXTT Support
2019-04-04 22:13:48.0
Recurred.
java.sql.SQLException: Failed to flush database test.xls.
Error Code:249856
SQL State:3D000
Failed to flush database test.xls.
Error Code:249856
SQL State:3D000

You should add delayedClose=0 connection property.

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