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
HXTT Excel: URGENT HELP Required.(java.lang.ArrayIndexOutOfBoundsException: 11)
Attiq Shahzad
2006-09-16 07:56:30.0
Below is the information & error:

JAVA=v5.0
ClassPath=All Set
HXTT Driver=Excel_Embedded_JDBC30.jar
Connection URL=jdbc:excel:/C:/123.xls
Class Loaded=com.hxtt.sql.excel.ExcelDriver
Exception in thread "AWT-EventQueue-0" java.lang.ArrayIndexOutOfBoundsException: 11

at com.hxtt.sql.HxttDriver.a(Unknown Source)

at com.hxtt.sql.HxttDriver.a(Unknown Source)

at com.hxtt.sql.HxttDriver.acceptsURL(Unknown Source)

at com.hxtt.sql.HxttDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:525)

at java.sql.DriverManager.getConnection(DriverManager.java:171)

at ConManETL.(ConManETL.java:53)

Can anyone let me know why is this happening to me?
Re:HXTT Excel: URGENT HELP Required.(java.lang.ArrayIndexOutOfBoundsException: 11)
HXTT Support
2006-09-16 08:20:36.0
Please check your classpath, and make sure that you haven't used an older HXTT package, for instance, DBF, or Access before 2006-08-15. If you wish to use those package, you should replace those package with the latest package too. That's all.
Problem Solved...But next Problem !!!
Attiq Shahzad
2006-09-16 08:24:52.0
java.sql.SQLException: Can't parse select * from Sheet1!:

java.lang.NoSuchFieldError: new

at com.hxtt.a.b.f(Unknown Source)

at com.hxtt.sql.bl.l(Unknown Source)

at com.hxtt.sql.ag.if(Unknown Source)

at com.hxtt.sql.ag.a(Unknown Source)

at com.hxtt.sql.ag.executeQuery(Unknown Source)

at ConManETL.eXecute(ConManETL.java:58)

Re:Re:Re:HXTT Excel: URGENT HELP Required.(java.lang.ArrayIndexOutOfBoundsException: 11)
HXTT Support
2006-09-16 08:29:15.0
You should use:
select * from Sheet1;
Or
select * from [Sheet1!];

The preferable sql is
select * from Sheet1;
Thanks
Attiq Shahzad
2006-09-16 08:33:04.0
Yes, I am using this query "select * from Sheet1" but in exception trace, as i provided you earlier. It is showing Sheet1!.
What is worng?
Waiting for your response.
Thanks
Attiq Shahzad
2006-09-16 08:35:18.0
Yes, I am using this query "select * from Sheet1" but in exception trace, as i provided you earlier. It is showing Sheet1!.
What is worng?
Waiting for your response.
Re:Re:Re:Re:Re:HXTT Excel: URGENT HELP Required.(java.lang.ArrayIndexOutOfBoundsException: 11)
HXTT Support
2006-09-16 08:39:35.0
select * from Sheet1;
Or
>select * from [Sheet1!];
select * from [Sheet1$]; //Not !

>java.lang.NoSuchFieldError: new
>What is worng?
You have still used an old package in your classpath, please remove it.

Re:Re:Re:Re:Re:Re:Re:HXTT Excel: URGENT HELP Required.(java.lang.ArrayIndexOutOfBoundsException: 11)
HXTT Support
2006-09-16 08:41:16.0
Please let us know your classpath setting, for instance, java -cp .... ConManETL?
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Excel: URGENT HELP Required.(java.lang.ArrayIndexOutOfBoundsException:
Attiq Shahzad
2006-09-16 08:47:25.0
Also, for your information, I am using:

Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Excel: URGENT HELP Required.(java.lang.ArrayIndexOutOfBoundsException:
Attiq Shahzad
2006-09-16 08:49:15.0
C:\Program Files\Java\jdk1.5.0_07\bin\javac.exe About.java ConManETL.java ConnectionManager.java ControlPanel.java ETL.java Exchange.java FileRegister.java Log.java Login.java MemoryMonitor.java MonitorManager.java Operators.java Options.java print\AbstractHasStatus.java print\AutofitTableColumns.java print\BaseControl.java print\Cell.java print\CellEditor.java print\CellMouseControl.java print\CheckInput.java print\CloseAction.java print\CommonUtil.java print\EditMouseControl.java print\FirstPageAction.java print\FJDateField.java print\FJDatePicker.java print\FJReport.java print\FJReportEditor.java print\FJReportIO.java print\FJReportPage.java print\GridBagUtil.java print\HasStatus.java print\JStatusBar.java print\LastPageAction.java print\Line.java print\LineEditor.java print\LineMouseControl.java print\ModalDialog.java print\MultiPage.java print\MyCellEditor.java print\MyCellRenderer.java print\NewPageAction.java print\NextPageAction.java print\PageTableModel.java print\PageTablePrint.java print\PrePageAction.java print\PrintAction.java print\Printer.java print\PrintSetupAction.java print\RemovePageAction.java print\ReportFileFilter.java print\StatusChangeListener.java print\StringResource.java print\XmlRW.java Printer.java Reports.java Switches.java
Working Directory - C:\proj\Diallog\ControlPanel\
Class Path - C:\proj\Diallog\lib\dirchooser.jar;C:\proj\Diallog\lib\ojdbc.jar;C:\proj\Diallog\lib\skinlf.jar;C:\proj\Diallog\ControlPanel;C:\proj\Diallog\lib\calendar.jar;C:\proj\Diallog\lib\Text_Embedded_JDBC30.jar;C:\proj\Diallog\lib\Excel_Embedded_JDBC30.jar;.;C:\Program Files\Java\jre1.5.0_07\lib\ext\QTJava.zip;c:\dist-disk\kawa pro 5.0\installed\kawaclasses.zip;c:\program files\java\jdk1.5.0_07\lib\tools.jar;c:\program files\java\jdk1.5.0_07\jre\lib\rt.jar
File Compiled...
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Excel: URGENT HELP Required.(java.lang.ArrayIndexOutOfBoundsException:
HXTT Support
2006-09-16 08:49:47.0
>Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
> ResultSet.CONCUR_READ_ONLY);
That wasn't the key of your issue. The key is to check the classpath.
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Excel: URGENT HELP Required.(java.lang.ArrayIndexOutOfBoundsException:
Attiq Shahzad
2006-09-16 08:53:14.0
Yes, I was using HXTT Access older package. But know situation is different. When I removed, I got following error on Query "select * from Sheet1"

Exception in thread "AWT-EventQueue-0" java.lang.NoSuchFieldError: oo

at com.hxtt.sql.excel.a9.e(Unknown Source)

at com.hxtt.sql.excel.ad.a(Unknown Source)

at com.hxtt.sql.excel.ad.(Unknown Source)

at com.hxtt.sql.excel.v.a(Unknown Source)

at com.hxtt.sql.bl.if(Unknown Source)

at com.hxtt.sql.db.a(Unknown Source)

at com.hxtt.sql.db.a(Unknown Source)

at com.hxtt.sql.bl.a(Unknown Source)

at com.hxtt.sql.bl.a(Unknown Source)

at com.hxtt.sql.ag.a(Unknown Source)

at com.hxtt.sql.ag.a(Unknown Source)

at com.hxtt.sql.ag.executeQuery(Unknown Source)

at ConManETL.eXecute(ConManETL.java:59)
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Excel: URGENT HELP Required.(java.lang.ArrayIndexOutOfBoundsException:
HXTT Support
2006-09-16 08:54:23.0
>Text_Embedded_JDBC30.jar;Excel_Embedded_JDBC30.jar
Check whether that you're using the latest Text_Embedded_JDBC30.jar ((658,169bytes), and Excel_Embedded_JDBC30.jar(723,660 bytes).
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Excel: URGENT HELP Required.(java.lang.ArrayIndexOutOfBoundsException:
HXTT Support
2006-09-16 08:57:51.0
You download Text_Embedded_JDBC30.jar at Sat Sep 16 00:16:14, and Excel_Embedded_JDBC30.jar at Sep 16 07:12:16. Please redownload Text_Embedded_JDBC30.jar since it's updated at 03:14 .

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