Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  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 Excel
Excel JDBC Driver
Prashanth Salur
2009-01-16 10:07:21.0
Hi,
I was evaluating your jdbc driver for excel and I ran into a few issues which I need some clarification.

1. I configured a connection pool in weblogic 8.1.4 using this driver and tested it. When I perform a query, i am able to retrieve the results. But when I do a insert, i can see the INSERT statement in the log file but the data is not getting inserted into the excel file. I tried using local mode and server mode. Same issue with both

2. When the excel server is running, how can I update the excel file. For e.g. if I need to replace the existing excel file which is more recent with new data. Currently, I can't update the file when the excel server is running.

3. Can the driver return data from across multiple excel files with a single query. For .e.g. if I have MyFile1.xls, MyFile2.xls, MyFile3.xls which have a worksheet by name MyTable. Can I perform a query like "SELECT * FROM MyTable" which will return the data from all the three excel files ?

Thanks in advance.

Sincerely,
Prashanth
Re:Excel JDBC Driver
HXTT Support
2009-01-18 17:15:37.0
>1. I configured a connection pool in weblogic 8.1.4 using this driver and
>tested it. When I perform a query, i am able to retrieve the results. But when
> I do a insert, i can see the INSERT statement in the log file but the data is
> not getting inserted into the excel file. I tried using local mode and server
> mode. Same issue with both
1st. delayedClose connectin property is using to decide when HXTT Excel will flush the actual file.
2nd. If you using axlsFile.xls in your jdbc url, that file will be flushed after that connection close.

>2. When the excel server is running, how can I update the excel file. For e.g.
>if I need to replace the existing excel file which is more recent with new
>data. Currently, I can't update the file when the excel server is running.
1st solution: Call con.close() in time.
2nd solutuon: Don't use jdbc:excel:////dataidr/yourxlsfile.xls as jdbc url, you should use jdbc:excel:////datadir as jdbc url, then use yourxls.sheet1 in your sql, or use con.setCatalog() to open that xls.

>3. Can the driver return data from across multiple excel files with a single
> query. For .e.g. if I have MyFile1.xls, MyFile2.xls, MyFile3.xls which have a
> worksheet by name MyTable.
> Can I perform a query like "SELECT * FROM MyTable" which will return the data
>from all the three excel files ?
Yeah. It can query on different xls files on different hosts even. For instance,
select * from myfile1.mytable join select * from myfile2.mytable join select * from myfile3.mytable if your jdbc url is jdbc:excel:////datadir .



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