Problem with SQL2POI command
Last Post 17 Jan 2013 04:48 AM by gio.cot. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Basic Member
Basic Member

17 Jan 2013 04:48 AM
Hi all
i should create a xls file with filter preloaded for all the colunms; i'm try to use SQL2POI command of SQL2XLS library; but when i run the command :

SQL2POI SQLSTMT('select * from mylib/mufile')

i receive the following errors;

pheraps my poi-2.5.1.jar is too old ? i tried to download the poi-3.2-FINAL-jar, but when i tyry to compile it i receve errrors

can some one help me

Thanks in advance

at java.lang.Throwable.(
at java.lang.Exception.(
at java.lang.reflect.InvocationTargetException.(
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(
at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(
at java.lang.reflect.Constructor.newInstance(Construc
at org.apache.poi.hssf.record.RecordFactory.createRec ord(
at org.apache.poi.hssf.record.RecordFactory.createRec ords(
at org.apache.poi.hssf.usermodel.HSSFWorkbook.(
at org.apache.poi.hssf.usermodel.HSSFWorkbook.(
at SQL2POI.main(
Caused by: java.lang.ArrayIndexOutOfBoundsException
at java.lang.Throwable.(
at java.lang.Exception.(
at java.lang.RuntimeException.(
at java.lang.IndexOutOfBoundsException.(
at java.lang.ArrayIndexOutOfBoundsException.(
at org.apache.poi.hssf.record.UnknownRecord.(
at org.apache.poi.hssf.record.SubRecord.createSubReco rd(
at org.apache.poi.hssf.record.ObjRecord.fillFields(Ob
at org.apache.poi.hssf.record.Record.fillFields(Recor
at org.apache.poi.hssf.record.Record.(
at org.apache.poi.hssf.record.ObjRecord.(
... 8 more

ERROR: Unable to construct record instance, the following exception occured: null
You are not authorized to post a reply.

Acceptable Use Policy