<font size=2 face="sans-serif">Hi Frank and Wolfgang,</font>
<br><font size=2 face="sans-serif"> </font>
<br><font size=2 face="sans-serif">Thank you for your help,</font>
<br><font size=2 face="sans-serif">I did everything as you both said,still
i am getting the same error,</font>
<br>
<br>
<br><font size=2 face="sans-serif">java.lang.RuntimeException: [12,19]:
[ERR 101] Line 12:19 no viable alternative at input ''[12,27]: [ERR 101]
Line 12:27 no viable alternative at input ''[13,15]: [ERR 101] Line 13:15
no viable alternative at input ''[13,21]: [ERR 101] Line 13:21 no viable
alternative at input ''[23,19]: [ERR 101] Line 23:19 no viable alternative
at input ''[23,27]: [ERR 101] Line 23:27 no viable alternative at input
''[24,15]: [ERR 101] Line 24:15 no viable alternative at input ''[24,21]:
[ERR 101] Line 24:21 no viable alternative at input ''[34,19]: [ERR 101]
Line 34:19 no viable alternative at input ''[34,25]: [ERR 101] Line 34:25
no viable alternative at input ''[35,15]: [ERR 101] Line 35:15 no viable
alternative at input ''[35,21]: [ERR 101] Line 35:21 no viable alternative
at input ''[45,19]: [ERR 101] Line 45:19 no viable alternative at input
''[45,27]: [ERR 101] Line 45:27 no viable alternative at input ''[46,15]:
[ERR 101] Line 46:15 no viable alternative at input ''[46,21]: [ERR 101]
Line 46:21 no viable alternative at input ''</font>
<br><font size=2 face="sans-serif">Error in kbuildefr ......</font>
<br><font size=2 face="sans-serif">Error in main ...</font>
<br><font size=2 face="sans-serif">Error is java.lang.RuntimeException:
[12,19]: [ERR 101] Line 12:19 no viable alternative at input ''[12,27]:
[ERR 101] Line 12:27 no viable alternative at input ''[13,15]: [ERR 101]
Line 13:15 no viable alternative at input ''[13,21]: [ERR 101] Line 13:21
no viable alternative at input ''[23,19]: [ERR 101] Line 23:19 no viable
alternative at input ''[23,27]: [ERR 101] Line 23:27 no viable alternative
at input ''[24,15]: [ERR 101] Line 24:15 no viable alternative at input
''[24,21]: [ERR 101] Line 24:21 no viable alternative at input ''[34,19]:
[ERR 101] Line 34:19 no viable alternative at input ''[34,25]: [ERR 101]
Line 34:25 no viable alternative at input ''[35,15]: [ERR 101] Line 35:15
no viable alternative at input ''[35,21]: [ERR 101] Line 35:21 no viable
alternative at input ''[45,19]: [ERR 101] Line 45:19 no viable alternative
at input ''[45,27]: [ERR 101] Line 45:27 no viable alternative at input
''[46,15]: [ERR 101] Line 46:15 no viable alternative at input ''[46,21]:
[ERR 101] Line 46:21 no viable alternative at input ''</font>
<br>
<br><font size=2 face="sans-serif"> at
com.model.Student_College.readBase(Student_College.java:90)</font>
<br><font size=2 face="sans-serif"> at
com.model.Student_College.main(Student_College.java:31)</font>
<br>
<br>
<br><font size=2 face="sans-serif">Now i am sending my main class and .xls
file.</font>
<br>
<br><font size=2 face="sans-serif">public class Student_College {</font>
<br><font size=2 face="sans-serif"> </font>
<br><font size=2 face="sans-serif"> public
static void main(String args[]) throws IOException</font>
<br><font size=2 face="sans-serif"> {</font>
<br><font size=2 face="sans-serif">
</font>
<br><font size=2 face="sans-serif">
Student s=new Student();</font>
<br><font size=2 face="sans-serif">
College c=new College();</font>
<br><font size=2 face="sans-serif">
s.setAge(20);</font>
<br><font size=2 face="sans-serif">
s.setMarks(35);</font>
<br><font size=2 face="sans-serif">
c.setRanking("B");</font>
<br><font size=2 face="sans-serif">
c.setLocation("elhi");</font>
<br><font size=2 face="sans-serif">
</font>
<br><font size=2 face="sans-serif">
</font>
<br><font size=2 face="sans-serif">
</font>
<br><font size=2 face="sans-serif">
try</font>
<br><font size=2 face="sans-serif">
{</font>
<br><font size=2 face="sans-serif">
KnowledgeBase
kbase = readBase();</font>
<br><font size=2 face="sans-serif">
StatefulKnowledgeSession
ksession = kbase.newStatefulKnowledgeSession();</font>
<br><font size=2 face="sans-serif">
</font>
<br><font size=2 face="sans-serif">
ksession.insert(s);</font>
<br><font size=2 face="sans-serif">
ksession.insert(c);</font>
<br><font size=2 face="sans-serif">
ksession.fireAllRules();</font>
<br><font size=2 face="sans-serif">
System.out.println("Department
is "+s.getDepartment());</font>
<br><font size=2 face="sans-serif">
</font>
<br><font size=2 face="sans-serif">
System.out.println("Status
is " + c.getStatus());</font>
<br><font size=2 face="sans-serif">
</font>
<br><font size=2 face="sans-serif">
ksession.dispose();</font>
<br><font size=2 face="sans-serif">
</font>
<br><font size=2 face="sans-serif">
</font>
<br><font size=2 face="sans-serif">
</font>
<br><font size=2 face="sans-serif">
}</font>
<br><font size=2 face="sans-serif">
catch(RuntimeException re)</font>
<br><font size=2 face="sans-serif">
{</font>
<br><font size=2 face="sans-serif">
System.out.println("Error
in main ...");</font>
<br><font size=2 face="sans-serif">
re.printStackTrace();</font>
<br><font size=2 face="sans-serif">
System.out.println("Error
is "+re);</font>
<br><font size=2 face="sans-serif">
</font>
<br><font size=2 face="sans-serif">
}</font>
<br><font size=2 face="sans-serif">
</font>
<br><font size=2 face="sans-serif"> }</font>
<br><font size=2 face="sans-serif"> </font>
<br><font size=2 face="sans-serif"> private
static KnowledgeBase readBase() throws IOException</font>
<br><font size=2 face="sans-serif"> {</font>
<br><font size=2 face="sans-serif">
DecisionTableConfiguration dconf = KnowledgeBuilderFactory.newDecisionTableConfiguration();</font>
<br><font size=2 face="sans-serif">
dconf.setInputType(DecisionTableInputType.XLS);</font>
<br><font size=2 face="sans-serif">
</font>
<br><font size=2 face="sans-serif">
KnowledgeBuilder kbuilder = KnowledgeBuilderFactory.newKnowledgeBuilder();</font>
<br><font size=2 face="sans-serif">
kbuilder.add(ResourceFactory.newClassPathResource("manohar.xls",
Student_College.class), ResourceType.DTABLE, dconf);</font>
<br><font size=2 face="sans-serif">
</font>
<br>
<br><font size=2 face="sans-serif">
if(kbuilder.hasErrors())</font>
<br><font size=2 face="sans-serif">
{</font>
<br><font size=2 face="sans-serif">
System.out.println("Error
in kbuildefr ......");</font>
<br><font size=2 face="sans-serif">
throw
new RuntimeException(kbuilder.getErrors().toString());</font>
<br><font size=2 face="sans-serif">
</font>
<br><font size=2 face="sans-serif">
}</font>
<br><font size=2 face="sans-serif">
</font>
<br><font size=2 face="sans-serif">
KnowledgeBase kbase = KnowledgeBaseFactory.newKnowledgeBase();</font>
<br><font size=2 face="sans-serif">
kbase.addKnowledgePackages(kbuilder.getKnowledgePackages());</font>
<br><font size=2 face="sans-serif">
</font>
<br><font size=2 face="sans-serif">
return kbase;</font>
<br><font size=2 face="sans-serif">
</font>
<br><font size=2 face="sans-serif">
</font>
<br><font size=2 face="sans-serif"> }</font>
<br>
<br><font size=2 face="sans-serif">}</font>
<br>
<br>
<br><font size=2 face="sans-serif">In above main class i used the following
code to interpret my manohar.xls file...</font>
<br>
<br><font size=2 face="sans-serif">String drlString = null;</font>
<br><font size=2 face="sans-serif">
try {</font>
<br><font size=2 face="sans-serif">
drlString
= DecisionTableFactory.loadFromInputStream(ResourceFactory.newClassPathResource("manohar.xls",
Student_College.class).getInputStream(), dconf);</font>
<br><font size=2 face="sans-serif">
} catch (IOException e) {</font>
<br><font size=2 face="sans-serif">
// TODO
Auto-generated catch block</font>
<br><font size=2 face="sans-serif">
System.out.println("Error
in drl String .....");</font>
<br><font size=2 face="sans-serif">
e.printStackTrace();</font>
<br><font size=2 face="sans-serif">
}</font>
<br><font size=2 face="sans-serif">
</font>
<br><font size=2 face="sans-serif">
System.out.println("..........."+drlString);</font>
<br>
<br>
<br>
<br>
<br><font size=2 face="sans-serif">manohar.xls:</font>
<br>
<br>
<table>
<tr>
<td><font size=1 face="Arial">RuleSet</font>
<td><font size=1 face="Arial">com.model</font>
<td>
<td>
<td>
<td>
<tr>
<td><font size=1 face="Arial">Import</font>
<td><font size=1 face="Arial">com.model.Student, com.model.College</font>
<td>
<td>
<td>
<td>
<tr>
<td>
<td>
<td>
<td>
<td>
<td>
<tr>
<td><font size=1 face="Arial">RuleTable </font>
<td><font size=1 face="Arial">Allocation Rule</font>
<td>
<td>
<td>
<td>
<tr>
<td><font size=1 face="Arial">CONDITION</font>
<td><font size=1 face="Arial">CONDITION</font>
<td><font size=1 face="Arial">CONDITION</font>
<td><font size=1 face="Arial">CONDITION</font>
<td><font size=1 face="Arial">ACTION</font>
<td><font size=1 face="Arial">ACTION</font>
<tr>
<td colspan=2><font size=1 face="Arial">$s:Student </font>
<td colspan=2><font size=1 face="Arial">$c:College </font>
<td>
<td>
<tr>
<td><font size=1 face="Arial">age</font>
<td><font size=1 face="Arial">marks</font>
<td><font size=1 face="Arial">ranking</font>
<td><font size=1 face="Arial">location</font>
<td><font size=1 face="Arial">$s.setDepartment(“$param”);</font>
<td><font size=1 face="Arial">$c.setStatus(“$param”);</font>
<tr>
<td>
<td>
<td>
<td>
<td>
<td>
<tr>
<td>
<div align=right><font size=1 face="Arial">18</font></div>
<td>
<div align=right><font size=1 face="Arial">85</font></div>
<td><font size=1 face="Arial">A</font>
<td><font size=1 face="Arial">Delhi</font>
<td><font size=1 face="Arial">Science</font>
<td><font size=1 face="Arial">AICTE</font>
<tr>
<td>
<div align=right><font size=1 face="Arial">18</font></div>
<td>
<div align=right><font size=1 face="Arial">90</font></div>
<td><font size=1 face="Arial">B</font>
<td><font size=1 face="Arial">Kanpur</font>
<td><font size=1 face="Arial">Science</font>
<td><font size=1 face="Arial">AICTE</font>
<tr>
<td>
<div align=right><font size=1 face="Arial">20</font></div>
<td>
<div align=right><font size=1 face="Arial">90</font></div>
<td><font size=1 face="Arial">A</font>
<td><font size=1 face="Arial">Mumbai</font>
<td><font size=1 face="Arial">Maths</font>
<td><font size=1 face="Arial">AICTE</font>
<tr>
<td>
<div align=right><font size=1 face="Arial">23</font></div>
<td>
<div align=right><font size=1 face="Arial">87</font></div>
<td><font size=1 face="Arial">C</font>
<td><font size=1 face="Arial">Hyderabad</font>
<td><font size=1 face="Arial">Physics</font>
<td><font size=1 face="Arial">AICTE</font></table>
<br><br>
<table>
<tr>
<td>
<td>
<td>
<td>
<td>
<td>
<tr>
<td>
<td>
<td>
<td>
<td>
<td>
<tr>
<td>
<td>
<td>
<td>
<td>
<td>
<tr>
<td>
<td>
<td>
<td>
<td>
<td>
<tr>
<td>
<td>
<td>
<td>
<td>
<td>
<tr>
<td>
<td>
<td>
<td>
<td>
<td>
<tr>
<td colspan=2>
<td colspan=2>
<td>
<td>
<tr>
<td>
<td>
<td>
<td>
<td>
<td>
<tr>
<td>
<td>
<td>
<td>
<td>
<td>
<tr>
<td>
<div align=right></div>
<td>
<div align=right></div>
<td>
<td>
<td>
<td>
<tr>
<td>
<div align=right></div>
<td>
<div align=right></div>
<td>
<td>
<td>
<td>
<tr>
<td>
<div align=right></div>
<td>
<div align=right></div>
<td>
<td>
<td>
<td>
<tr>
<td>
<div align=right></div>
<td>
<div align=right></div>
<td>
<td>
<td>
<td></table>
<br>
<br><font size=2 face="sans-serif">Thanks and Regards<br>
Manohar Kokkula<br>
Mailto: manohar.kokkula@tcs.com<br>
</font><pre style="white-space:normal">=====-----=====-----=====<br>Notice: The information contained in this e-mail<br>message and/or attachments to it may contain <br>confidential or privileged information. If you are <br>not the intended recipient, any dissemination, use, <br>review, distribution, printing or copying of the <br>information contained in this e-mail message <br>and/or attachments to it are strictly prohibited. If <br>you have received this communication in error, <br>please notify us by reply e-mail or telephone and <br>immediately and permanently delete the message <br>and any attachments. Thank you<br><br><br></pre>