HXTT Excel: URGENT HELP Required.(java.lang.ArrayIndexOutOfBoundsException: 11) |
Attiq Shahzad |
2006-09-16 07:56:30 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
|
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 |
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 |
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 |
>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 |
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 |
>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 |
|
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 .
|
Main
webmaster@hxtt.com