Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
  HXTT Cobol v5.0
  HXTT DBF v7.1
  HXTT Excel v6.1
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Json v1.0
  HXTT Paradox v7.1
  HXTT PDF v2.0
  HXTT Text(CSV) v7.1
  HXTT Word v1.1
  HXTT XML v4.0
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
Issue with the Excel Driver
sankar iyer
2009-07-09 07:52:31
We are getting the following error when we try running a query :

Failed to get a double value from java.lang.String: PINYX; CODE: 139264

The query is as follows :

select * from ( SELECT 1 OrderNo,max(FundName) Fundcategory,sum(1M_Rank) 1M_Rank,Sum(1M_Rank_Lip) 1M_Rank_Lip,sum(1m_Perc) 1M_Perc,sum(1M_Perc_Lip) 1M_Perc_Lip,sum(QTD_Rank) QTD_Rank,sum(QTD_Rank_Lip) QTD_Rank_Lip,sum(QTD_Perc) QTD_Perc,sum(QTD_Perc_Lip) QTD_Perc_Lip,sum(3M_Rank) 3M_Rank,sum(3M_Rank_Lip) 3M_Rank_Lip,sum(3M_Perc) 3M_Perc,sum(3M_Perc_Lip) 3M_Perc_Lip,sum(YTD_Rank) YTD_Rank,sum(YTD_Rank_Lip) YTD_Rank_Lip,sum(YTD_Perc) YTD_Perc,sum(YTD_Perc_Lip) YTD_Perc_Lip,sum(1Y_Rank) 1Y_Rank,sum(1Y_Rank_Lip) 1Y_Rank_Lip,sum(1Y_Perc) 1Y_Perc,sum(1Y_Perc_Lip) 1Y_Perc_Lip,sum(3Y_Rank) 3Y_Rank,sum(3Y_Rank_Lip) 3Y_Rank_Lip,sum(3Y_Perc) 3Y_Perc,sum(3Y_Perc_Lip) 3Y_Perc_Lip,sum(5Y_Rank) 5Y_Rank,sum(5Y_Rank_Lip) 5Y_Rank_Lip,sum(5Y_Perc) 5Y_Perc,sum(5Y_Perc_Lip) 5Y_Perc_Lip,sum(10Y_Rank) 10Y_Rank,sum(10Y_Rank_Lip) 10Y_Rank_Lip,sum(10Y_Perc) 10Y_Perc,sum(10Y_Perc_Lip) 10Y_Perc_Lip from (select FundName FundName,'' Category,1M_Rank, 0 1M_Rank_Lip,1M_Perc, 0 1M_Perc_Lip,QTD_Rank, 0 QTD_Rank_Lip,QTD_Perc, 0 QTD_Perc_Lip,3M_Rank, 0 3M_Rank_Lip,3M_Perc, 0 3M_Perc_Lip,YTD_Rank, 0 YTD_Rank_Lip,YTD_Perc, 0 YTD_Perc_Lip,1Y_Rank, 0 1Y_Rank_Lip,1Y_Perc, 0 1Y_Perc_Lip,3Y_Rank, 0 3Y_Rank_Lip,3Y_Perc, 0 3Y_Perc_Lip,5Y_Rank, 0 5Y_Rank_Lip,5Y_Perc, 0 5Y_Perc_Lip,10Y_Rank, 0 10Y_Rank_Lip,10Y_Perc, 0 10Y_Perc_Lip FROM LipperRank L1 WHERE L1.NASDAQ='PINYX' ) union SELECT 2 OrderNo,max(Category) Fundcategory ,sum(1M_Rank) 1M_Rank,sum(1M_Rank_Lip) 1M_Rank_Lip,sum(1M_Perc) 1M_Perc,sum(1M_Perc_Lip) 1M_Perc_Lip,sum(QTD_Rank) QTD_Rank,sum(QTD_Rank_Lip) QTD_Rank_Lip,sum(QTD_Perc) QTD_Perc,sum(QTD_Perc_Lip) QTD_Perc_Lip,sum(3M_Rank) 3M_Rank,sum(3M_Rank_Lip) 3M_Rank_Lip,sum(3M_Perc) 3M_Perc,sum(3M_Perc_Lip) 3M_Perc_Lip,sum(YTD_Rank) YTD_Rank,sum(YTD_Rank_Lip) YTD_Rank_Lip,sum(YTD_Perc) YTD_Perc,sum(YTD_Perc_Lip) YTD_Perc_Lip,sum(1Y_Rank) 1Y_Rank,sum(1Y_Rank_Lip) 1Y_Rank_Lip,sum(1Y_Perc) 1Y_Perc,sum(1Y_Perc_Lip) 1Y_Perc_Lip,sum(3Y_Rank) 3Y_Rank,sum(3Y_Rank_Lip) 3Y_Rank_Lip,sum(3Y_Perc) 3Y_Perc,sum(3Y_Perc_Lip) 3Y_Perc_Lip,sum(5Y_Rank) 5Y_Rank,sum(5Y_Rank_Lip) 5Y_Rank_Lip,sum(5Y_Perc) 5Y_Perc,sum(5Y_Perc_Lip) 5Y_Perc_Lip,sum(10Y_Rank) 10Y_Rank,sum(10Y_Rank_Lip) 10Y_Rank_Lip,sum(10Y_Perc) 10Y_Perc,sum(10Y_Perc_Lip) 10Y_Perc_Lip from (select FundName FundName,'' Category,1M_Rank, 0 1M_Rank_Lip,1M_Perc, 0 1M_Perc_Lip,QTD_Rank, 0 QTD_Rank_Lip,QTD_Perc, 0 QTD_Perc_Lip,3M_Rank, 0 3M_Rank_Lip,3M_Perc, 0 3M_Perc_Lip,YTD_Rank, 0 YTD_Rank_Lip,YTD_Perc, 0 YTD_Perc_Lip,1Y_Rank, 0 1Y_Rank_Lip,1Y_Perc, 0 1Y_Perc_Lip,3Y_Rank, 0 3Y_Rank_Lip,3Y_Perc, 0 3Y_Perc_Lip,5Y_Rank, 0 5Y_Rank_Lip,5Y_Perc, 0 5Y_Perc_Lip,10Y_Rank, 0 10Y_Rank_Lip,10Y_Perc, 0 10Y_Perc_Lip FROM LipperRank L1 WHERE L1.NASDAQ='PINYX' union select '' FundName,Category Category,0 1M_Rank, 1M_Rank 1M_Rank_Lip,0 1M_Perc, 1M_Perc 1M_Perc_Lip,0 QTD_Rank, QTD_Rank QTD_Rank_Lip,0 QTD_Perc, QTD_Perc QTD_Perc_Lip,0 3M_Rank, 3M_Rank 3M_Rank_Lip,0 3M_Perc, 3M_Perc 3M_Perc_Lip,0 YTD_Rank, YTD_Rank YTD_Rank_Lip,0 YTD_Perc, YTD_Perc YTD_Perc_Lip,0 1Y_Rank, 1Y_Rank 1Y_Rank_Lip,0 1Y_Perc, 1Y_Perc 1Y_Perc_Lip,0 3Y_Rank, 3Y_Rank 3Y_Rank_Lip,0 3Y_Perc, 3Y_Perc 3Y_Perc_Lip,0 5Y_Rank, 5Y_Rank 5Y_Rank_Lip,0 5Y_Perc, 5Y_Perc 5Y_Perc_Lip,0 10Y_Rank, 10Y_Rank 10Y_Rank_Lip,0 10Y_Perc, 10Y_Perc 10Y_Perc_Lip FROM LipperRank L2 WHERE L2.CategoryClass = (select distinct LipperClass FROM LipperRank L3 where L3.NASDAQ='PINYX')) )].

ERROR: Failed to get a double value from java.lang.String: PINYX; CODE: 139264
Not sure what would be a way to fix this..

Re:Issue with the Excel Driver
HXTT Support
2009-07-09 08:23:28
Try maxScanRows=0 connection property.
maxScanRows: Indicates how many rows should be scanned when determining the column types. If you set maxScanRows to 0, the entire file is scanned. If you set maxScanRows to a negative value, the file won't be scanned. Default value: 10

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 | Refund | Sitemap