4:43 a.m.
Hello,
some days ago I implemented rules with a dicision table (5.0.1) and
everything works fine.
But suddenly I ran into a strange ArrayIndexOutOfBoundsException. I thought
my
decision table is the problem and so I tried to test with some simple tables
but I still
get the same error.
Here is the stacktrace:
java.lang.ArrayIndexOutOfBoundsException
at java.lang.System.arraycopy(Native Method)
at jxl.biff.StringHelper.getUnicodeString(StringHelper.java:155)
at jxl.biff.FormatRecord.<init>(FormatRecord.java:158)
at jxl.read.biff.WorkbookParser.parse(WorkbookParser.java:538)
at jxl.Workbook.getWorkbook(Workbook.java:253)
at jxl.Workbook.getWorkbook(Workbook.java:235)
at
org.drools.decisiontable.parser.xls.ExcelParser.parseFile(ExcelParser.java:74)
at
org.drools.decisiontable.SpreadsheetCompiler.getRuleSheetListener(SpreadsheetCompiler.java:148)
at
org.drools.decisiontable.SpreadsheetCompiler.compile(SpreadsheetCompiler.java:131)
at
org.drools.decisiontable.DecisionTableProviderImpl.compileStream(DecisionTableProviderImpl.java:32)
at
org.drools.decisiontable.DecisionTableProviderImpl.loadFromInputStream(DecisionTableProviderImpl.java:19)
at
org.drools.compiler.DecisionTableFactory.loadFromInputStream(DecisionTableFactory.java:16)
at
org.drools.compiler.PackageBuilder.addKnowledgeResource(PackageBuilder.java:508)
at
org.drools.builder.impl.KnowledgeBuilderImpl.add(KnowledgeBuilderImpl.java:31)
This is the code the files get loaded with:
KnowledgeBuilder kBuilder = KnowledgeBuilderFactory.newKnowledgeBuilder();
DecisionTableConfiguration dtconf =
KnowledgeBuilderFactory.newDecisionTableConfiguration();
dtconf.setInputType( DecisionTableInputType.XLS );
dtconf.setWorksheetName("Tables");
kBuilder.add(ResourceFactory.newClassPathResource(source),
ResourceType.DTABLE, dtconf);
This is the simple Test.xls, just with a package- and ruletable-declaration:
http://n3.nabble.com/forum/FileDownload.jtp?type=n&id=756101&name...
Test.xls
Regards,
Christian
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/Strange-ArrayIndexOut...
Sent from the Drools - User mailing list archive at Nabble.com.
4:57 a.m.
It seems that Excel save the files in a format that will be parsed by the
JExcelApi in a wrong way.
So I tried to save the file with Openoffice and it worked well.
So what's the solution for Excel? I tried Excel'97 format but that didn't
help.
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/Strange-ArrayIndexOut...
Sent from the Drools - User mailing list archive at Nabble.com.
5:40 a.m.
I don't know whether this applies here, but I quote a comment from
Michael Kay (posted today on another list):
"... the other problem is that in the XML output from Excel, empty
cells are often omitted, their presence signalled only by the
existence of an attribute on the next Cell element that indicates what
column number it is in. This makes processing the XML quite
challenging."
If the XMLs from Excel and OpenOffice differ in that respect, then
this could be a pointer for fixing the problem in Drools.
Michael Kay also mentions the possibility of unifying the Cell
elements so all have the column attribute using a simple XSLT
transformation. (I guess I could provide that, if necessary.)
-W
On Tue, Apr 27, 2010 at 10:57 AM, murphy <christian.niehues(a)its-telco.de> wrote:
It seems that Excel save the files in a format that will be parsed by the
JExcelApi in a wrong way.
So I tried to save the file with Openoffice and it worked well.
So what's the solution for Excel? I tried Excel'97 format but that didn't
help.
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/Strange-ArrayIndexOut...
Sent from the Drools - User mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
5111
days inactive
5112
days old
2 comments
2 participants
participants (2)
-
murphy -
Wolfgang Laun